Failed SQL Statement in dataset fill helper: SELECT cw_daily_tasks

Modified on Wed, 27 Jan 2016 16:23 by Kevin Ricciardo — Categorized as: Uncategorized

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.

For assistance with resolving this error, contact the CAREWare Help Desk by following the instructions here.