none
SharePoint 2010 Upgrade- Reporting Services Migration issue RRS feed

  • Question

  • Hi,

    This is regarding the report server migration.

    Current enviroment- MOSS 2007+ SQL Server 2008 (Reporting Services)

    Proposed environment- SharePoint 2010 + SQL Server 2008 R2 RS (multi server farm setup)

    We are building the DEV/ TEST environment now before go with Production upgrade. We followed the below steps.

    1. Installed SSRS 2008 R2 (CU #5) with NO configure option.

    2. Installed and configured the SharePoint 2010

    3. Configured the SSRS with create new repository database option.

    4. Integrated with SharePoint

    5. Backup/ Restore the Repository DB's (ReportServer/ ReportServerTempDB) from PROD to DEV

    6. Re-Configure the SSRS use the restored DB's and Encryption Keys

    7. Restart the SSRS service (Yet to migrate the SharePoint content DB)

    8. Compared the configuration files PROD vs DEV

    • Rsreportserver.config

    • Rssvrpolicy.config

    • Rsmgrpolicy.config

    • Reportingservicesservice.exe.config

    • Web.config

    The Report Server URL works fine http://DEV2010/ReportServer . But below error message keep on getting added in the log files and the mini dump files were being created frequently. The references still point the PROD URL.

    i INFO: Upgrading SharePoint catalog paths.

    i INFO: Failed to create SPSite for: http://prod2007/Team Sites/Site1/Reports Report Bldr/Test Folder

    e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.;

    Error upgrading the items with name 'UpgradeSharePointCatalogPaths'

    Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.Catalog' with unique index 'IX_Catalog'. The duplicate key value is (/{00000000-0000-0000-0000-000000000000}/Sample Report.rdl).
    The statement has been terminated.

    We need some assistance on fixing this issue. Much appreciate if you can share some experience on this.

    Referred the below articles, but no clue on this issue.

    http://msdn.microsoft.com/en-us/library/ms155814.aspx

    http://blogs.msdn.com/b/prash/archive/2011/06/11/migrating-ssrs-2008-r2-sharepoint-mode-from-one-sharepoint-farm-to-another.aspx

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/d3deb257-cef5-4b6b-8ce8-0aa2015dd3dc


    --Jey


    • Edited by Jeyakumarvs Wednesday, May 9, 2012 4:46 AM Formatting
    Wednesday, May 9, 2012 4:45 AM

Answers

  • Hi,

    We successfully resolved all the issues now. Below is the current understanding.

    For issue #3 above, the reports that never been ran (for the first time) in the MOSS 2007 environment did NOT have the entry in the catalog table of report server repository. Those reports needs to be republished in SharePoint 2010 environment.

    Summary

    We missed the configuration entries in the Alternate Access Mappings (AAM) settings in SharePoint integration page (Centel Admin). Once the issue with AAM fixed, all the reports start work fine WITHOUT any manual updates to Report Server repository.

    Hope this helps!!

    http://msdn.microsoft.com/en-us/library/ee384252%28SQL.100%29.aspx


    --Jey

    • Marked as answer by Jeyakumarvs Monday, May 28, 2012 2:09 PM
    Monday, May 28, 2012 2:09 PM

All replies

  • Thank you for visit this thread.

    After follow the below steps, the above mentioned error messages has been STOPPED log in the log files.

    Step #1

    DELETE all the content from the ReportServerTempDB database

    Step #2

    Below updates for ReportServer database

    update ServerParametersInstance set Path=REPLACE(path,'prod2007','dev2010')
    update Catalog set Path=REPLACE(path,'prod2007','dev2010')
    update Schedule set Path=REPLACE(path,'prod2007','dev2010')

    Step #3

    Restart the Report Server machine.

    NOTE: NOT sure that this is a right approach to follow. Followed this approach after some analysis.

    Below is the error messages logged (post this information here after monitor the server for 2 hours)

    Error Messages

    #1

    Failed to create SPSite for http://dev2010/Team Sites/Site1/Reports Report Bldr/Test Folder/Sample Report.rdl: Invalid catalog path

    Above could be a valid error, as we haven't migrated the SharePoint Content DB.

    #2

    Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: SharePoint zone not initialized, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:

    PollingMaintenance: Restarting maintenance thread for the following exception: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details..

    This error message get logged every 30 minutes (approx) and the respective mini dump file has been created for the same.

    It would be great if any assistance on resolve the error #2.

    Update (from Mini dump file) for Error #2:

    'Exception message: An internal error occurred on the report server. See the error log for more details. additional message:
    SharePoint zone not initialized'

    We are going to migrate the SharePoint Content DB from production now and see if that resolve the remaining issues.

    Thanks, Jey



    Update (18/May)

    Below is the current status.

    #1

    The 'path' column 'Catalog' table in the SSRS Metadata repository has 2 types of values as below. One with GUID and another with absolute server path. Example,

    http://dev2010/Team Sites/Site1/Reports Report Bldr/Test Folder/Sample Report.rdl

    /{xxxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}/Team Sites/Site1/Reports Report Bldr/Test Folder/Sample Report 2.rdl

    The report with GUID works fine and another with http://dev2010 did not work.

    Workaround: We ran the UPDATE command and replaced the http://dev2010 with GUID. So, the Sample Report 2.rdl report start work now.

    #2

    The Mini dump file generation has been stopped now.

    #3

    Still some of the reports did not work for which there is NO entry in the SSRS Metadata repository. Error message follows

    http://dev2010/Team Sites/Site1/Reports Report Bldr/Test Folder/Sample Report 3.rdl can not be found.

    It opens in Report Builder Report, but unable to RUN/ SAVE the report. (Same error as above)

    Note: In Production (MOSS 2007), similar case works very well.

    Do you have any idea on #3? Any assistance is much appreciated.

    Thanks, Jey

    • Edited by Jeyakumarvs Friday, May 18, 2012 5:49 PM Updates
    Thursday, May 10, 2012 6:44 AM
  • Hi,

    We successfully resolved all the issues now. Below is the current understanding.

    For issue #3 above, the reports that never been ran (for the first time) in the MOSS 2007 environment did NOT have the entry in the catalog table of report server repository. Those reports needs to be republished in SharePoint 2010 environment.

    Summary

    We missed the configuration entries in the Alternate Access Mappings (AAM) settings in SharePoint integration page (Centel Admin). Once the issue with AAM fixed, all the reports start work fine WITHOUT any manual updates to Report Server repository.

    Hope this helps!!

    http://msdn.microsoft.com/en-us/library/ee384252%28SQL.100%29.aspx


    --Jey

    • Marked as answer by Jeyakumarvs Monday, May 28, 2012 2:09 PM
    Monday, May 28, 2012 2:09 PM