Article ID: 946741 - View products that this article applies to.
Bug: #50002134 (SQL Hotfix)
You migrate a Microsoft SQL Server 2000 Reporting Services deployment directly to a new instance of Microsoft SQL Server 2005 Reporting Services Service Pack 2 (SP2). To do this, you use the method that is described on the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms143724.aspxThen, when you display a report, you receive the following error message:
Note This issue does not occur if the following conditions are true:
An internal error occurred on the report server. See the error log for more details. (rsInternalError)
Cannot insert the value NULL into column 'SnapshotDataID', table 'ReportServerTempDB.dbo.SessionData'; column does not allow nulls. INSERT fails. The statement has been terminated.
This issue occurs because the ReportServerTempDB database is not correctly migrated if you migrate SQL Server 2000 Reporting Services directly to SQL Server 2005 SP2.
To work around this issue, use one of the following methods.
Method 1After you migrate SQL Server 2000 Reporting Services directly to SQL Server 2005 SP2, run the following statements against the ReportServerTempDB database.
Method 2Migrate SQL Server 2000 Reporting Services to the release version of SQL Server 2005 Reporting Services or to SQL Server 2005 Service Pack 1 (SP1). Then, install SQL Server 2005 SP2.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about how to migrate Reporting Services, visit the following Microsoft Developer Network (MSDN) Web site:
Article ID: 946741 - Last Review: January 10, 2008 - Revision: 1.3