Data Tier Update Failed for 89.7

Modified on Thu, 05 Jan 2017 14:01 by Kevin Ricciardo — Categorized as: Uncategorized

Error - The business tier is currently locked for the following purpose(s): * Unable to update the Data Tier. You will not be able to log in until the problem is fixed. Contact technical support so that they can view the event logs. DTUpdate 89.7 failed


Is there a cw_daily_tasks table in the CW_Data database? This can be checked using SQL Server Management Studio on the database server.
  1. Start SQL Server Management Studio.
  2. Click Connect, after selecting the CAREWare database instance.
  3. Expand Databases.
  4. Expand CW_Data.

Scroll down to verify the cw_daily_tasks table is there. If not:


  1. Start SQL Server Management Studio.
  2. Click Connect, for the CAREWare database instance.
  3. Expand Databases.
  4. Right CW_Data.
  5. Click Properties.
  6. Click Options.

Verify that the Compatibility Level is set to the save version of SQL used for that database (i.e. SQL Server 2008 mode and the database instance is 10.0 or 10.5).

Here is a list of SQL Server numbers to verify the version.


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



Back to Recent Build Fixes