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 1: Data in the snapshot tables has become corrupt.
Cause 2: Cloned reports, sharing snapshot table. (cloning report via manual XML modifications)
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.