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

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

book

Article ID: 164288

calendar_today

Updated On:

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.

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:

Step 1: Run the following query in SQL Management Studio and copy the results to a new tab.
select distinct 'drop table [' + SnapshotDataTableName + ']' from DataSnapshot

Step 2: Run the results from the above query to drop the tables.

Step 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.