Welcome Guest, Login

Page History: Failed SQL Statement in dataset fill helper: SELECT cw_daily_tasks

Compare Page Revisions

4 3 2 1 0 Current 4 3 2 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Fri, 15 Jan 2016 18:12

Failed SQL Statement in dataset fill helper:
SELECT cw_daily_tasks.* FROM cw_daily_tasks WHERE cw_daily_tasks.dl_ts_enabled = @wdl_ts_enabled1
Parameter values were:
@wdl_ts_enabled1 = True


Verbose Stack Trace Information: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at jProgBusiness.jBusiness.jSQLDatasetFillHelper.jTableDescriptor.FillTable(DataSet TheDataset, IDbConnection Connection)

This error may be the result of the cw_daily_tasks table being missing due to an update error in the database. This can occur if the Database Compatibility Level is set to SQL 2000. Check the database for the cw_daily tasks table using SQL Server Management Studio. If the cw_daily_tasks table if missing follow these steps to complete the database update.

To check the Database Compatibility Level:

1. Go to C:\Program Files(x86)\CAREWare\RW CAREWare Business Tier\CW Admin.
2. Right click on the CW Admin utility.
3. Click Run as Administrator.
4. Click Database Info.
5. Enter the SA password.
6. Change the Database Compatibility Level.
7. Click Apply
   

If the Database Compatibility Level is SQL 2000, change the level to match the current version of the SQL Server database.

Restart the data tier updater back to 84.5046 to rebuild the database. Restarting the business tier will be required to fix this issue, so make sure all users log off while you perform these steps. You can restart the DTUpdater following these instructions:

1. Go to C:\Program Files(x86)\CAREWare\RW CAREWare Business Tier\CW Admin.
2. Right click on the CW Admin utility.
3. Click Run as Administrator.
4. Click Stop Server.
5. Click Common Storage Settings tab.
6. Scroll down to UpdateToRun under cmm_st_pk.
7. Type in '84.5046' in the column cmm_st_number in the UpdateToRun row.
8. Click any other box to save.
9. Click Server Settings.
10. Click Start Server.
    

Then log in to CAREWare again. This will rerun the update for the data tier and rebuild the database to include the missing table. Let us know if any errors come up or if you need additional instruction.