Reports fail to run after an upgrade with error: Table [DS_.....] already exists and is unavailable for DataSnapshots Data.

Products

• IT Management Suite

Issue/Introduction

After upgrading from 7.x to 8.0 some reports fail to run for some or all users.

The error in the logs is "Table [DS_Data_TABLE_NAME_HERE] already exists and is unavailable for DataSnapshots Data.

Table [DS_Data_TABLE_NAME_HERE] already exists and is unavailable for DataSnapshots Data.

Environment

Version 8.0

Cause

Cause 1: Data in the snapshot tables has become corrupt.

Cause 2: Cloned reports, sharing snapshot table. (cloning report via manual XML modifications)

Resolution

For Cause 1:

1. Run the following query in SQL Management Studio and copy the results to a new tab.
   select distinct 'drop table [' + SnapshotDataTableName + ']' from DataSnapshot
   
   
2. Run the results from the above query to drop the tables.
   
   
3. Run this to clean up the references to the tables holding the snapshot data
   truncate table DataSnapshot

For Cause 2:

Reclone the affected reports via Symantec Management Console, that will allow the snapshot table information in the report to be regenerated.