locked
SQL Server 2008 R2 Reporting Servies Repair fails "Object reference not set to an instance of an object" RRS feed

  • General discussion

  • When running an upgrade from SQL Server 2008 to SQL Server 2008 R2 we encountered an error which failed the database and reporting services components from upgrading.  We determined from the log that this was because our msdb database was restricted in size and the log filled up.  We corrected this and did a repair on the installation with the SQL Server 2008 R2 media.  This led to a null reference exception from the installer and would not repair.  Also, the SQL Server agent wouldn't start anymore.  We had to uninstall and reinstall the entire installation to get it working again.  Has anyone else ever encountered this error?

     

    Here is a snippet of the log:

    2011-07-22 11:08:29 Slp: Skipping Scheduling Action Install_Sql2000ia64_AnyInstance_Cpu64_Action

    2011-07-22 11:08:29 Slp: Skipping Scheduling Action Install_Sql2000ia64_AS_Cpu64_Action

    2011-07-22 11:08:29 Slp: Completed Action: ScheduleUpgradePackageInstallActionsAction, returned True

    2011-07-22 11:08:30 Slp: ----------------------------------------------------------------------

    2011-07-22 11:08:30 Slp: Running Action: ScheduleConfigAction

    2011-07-22 11:08:36 Slp: Completed Action: ScheduleConfigAction, returned True

    2011-07-22 11:08:37 Slp: ----------------------------------------------------------------------

    2011-07-22 11:08:37 Slp: Running Action: NotifyProgressCountDisplay

    2011-07-22 11:08:37 Slp: Completed Action: NotifyProgressCountDisplay, returned True

    2011-07-22 11:08:37 Slp: Completed Action: ExecuteScheduleActionsWorkflow, returned True

    2011-07-22 11:08:37 Slp: ----------------------------------------------------------------------

    2011-07-22 11:08:37 Slp: Skipping Action: ExecuteRemoveCompleteImageShortcutForUninstall

    2011-07-22 11:08:37 Slp: Action is being skipped due to the following restrictions: 

    2011-07-22 11:08:37 Slp: Condition "Is the user's scenario set to Uninstall" did not pass as it returned false and true was expected.

    2011-07-22 11:08:37 Slp: ----------------------------------------------------------------------

    2011-07-22 11:08:37 Slp: Running Action: ExecuteStandardTimingsWorkflow

    2011-07-22 11:08:37 Slp: Workflow to execute: 'STANDARDTIMINGS'

    2011-07-22 11:08:37 Slp: ----------------------------------------------------------------------

    2011-07-22 11:08:37 Slp: Running Action: ValidationTimingConfigAction

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Sco: Attempting to get feature configuration state for feature RS_Server_Adv, instance MSRS10_50.OASYSHDB

    2011-07-22 11:08:38 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature RS_Server_Adv, instance MSRS10_50.OASYSHDB, machine name MAINREPORTSVR

    2011-07-22 11:08:38 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MAINREPORTSVR

    2011-07-22 11:08:38 Slp: Sco: Attempting to open registry subkey 

    2011-07-22 11:08:38 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10_50.OASYSHDB\ConfigurationState

    2011-07-22 11:08:38 Slp: Sco: Attempting to get registry value RS_Server_Adv

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: Sco: Attempting to get feature configuration state for feature RS_Server_Adv, instance MSRS10_50.OASYSHDB

    2011-07-22 11:08:38 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature RS_Server_Adv, instance MSRS10_50.OASYSHDB, machine name MAINREPORTSVR

    2011-07-22 11:08:38 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MAINREPORTSVR

    2011-07-22 11:08:38 Slp: Sco: Attempting to open registry subkey 

    2011-07-22 11:08:38 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10_50.OASYSHDB\ConfigurationState

    2011-07-22 11:08:38 Slp: Sco: Attempting to get registry value RS_Server_Adv

    2011-07-22 11:08:38 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:08:38 Slp: ---- Flush datastore cache before calling configuration action 'RSInstanceID_repair_mergeconfig_Cpu64'

    2011-07-22 11:08:38 Slp: ---- Flush datastore cache before calling configuration action 'RSInstanceID_repair_mergeconfig_Cpu64'

    2011-07-22 11:08:38 Slp: ----------------------------------------------------------------------

    2011-07-22 11:08:38 Slp: Running Action: RSInstanceID_repair_mergeconfig_Cpu64

    2011-07-22 11:08:38 Slp: Action Data:

    2011-07-22 11:08:38 Slp:   Feature = RS_Server_Adv_sql_rs_Cpu64

    2011-07-22 11:08:38 Slp:   Scenario = repair

    2011-07-22 11:08:38 Slp:   Timing = MergeConfig

    2011-07-22 11:08:38 Slp:   ConfigObjectType = Microsoft.SqlServer.Configuration.SetupExtension.RsInstanceIdPrivateConfigObject

    2011-07-22 11:08:38 Slp:   FeatureName = RS_Server_Adv

    2011-07-22 11:08:38 Slp:   FeatureCpuType = Cpu64

    2011-07-22 11:08:38 Slp:   FeaturePackageId = sql_rs

    2011-07-22 11:08:38 Slp:   FromVersion = 

    2011-07-22 11:08:38 Slp:   InstallId = Machine[@ID='MAINREPORTSVR']/Product[@ID='SQL2008']/Instance[@ID='OASYSHDB.INACTIVE']/Feature[@ID='RS_CTP5' and @RegistryPath='SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10_50.OASYSHDB\Setup' and @RootPath='SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10_50.OASYSHDB']/Install[@ProductCode='8A665A38-9FFC-4220-B5C2-895F438EE5DF']

    2011-07-22 11:08:38 Slp: SlpConfigAction.ExecuteAction(actionId: RSInstanceID_repair_mergeconfig_Cpu64) completed

    2011-07-22 11:08:38 Slp: Checkpoint: REPAIR:MERGECONFIG:RS_SERVER_ADV

    2011-07-22 11:08:38 Slp: Completed Action: RSInstanceID_repair_mergeconfig_Cpu64, returned True

    2011-07-22 11:08:38 Slp: ---- Flush datastore cache before calling configuration action 'SqlRSConfigAction_repair_mergeconfig_Cpu64'

    2011-07-22 11:08:38 Slp: ---- Flush datastore cache before calling configuration action 'SqlRSConfigAction_repair_mergeconfig_Cpu64'

    2011-07-22 11:08:38 Slp: ----------------------------------------------------------------------

    2011-07-22 11:08:38 Slp: Running Action: SqlRSConfigAction_repair_mergeconfig_Cpu64

    2011-07-22 11:08:38 Slp: Action Data:

    2011-07-22 11:08:38 Slp:   Feature = RS_Server_Adv_sql_rs_Cpu64

    2011-07-22 11:08:38 Slp:   Scenario = repair

    2011-07-22 11:08:38 Slp:   Timing = MergeConfig

    2011-07-22 11:08:38 Slp:   ConfigObjectType = Microsoft.SqlServer.Configuration.RSExtension.SQLRSConfigurationPrivate

    2011-07-22 11:08:38 Slp:   FeatureName = RS_Server_Adv

    2011-07-22 11:08:38 Slp:   FeatureCpuType = Cpu64

    2011-07-22 11:08:38 Slp:   FeaturePackageId = sql_rs

    2011-07-22 11:08:38 Slp:   FromVersion = 

    2011-07-22 11:08:38 Slp:   InstallId = Machine[@ID='MAINREPORTSVR']/Product[@ID='SQL2008']/Instance[@ID='OASYSHDB.INACTIVE']/Feature[@ID='RS_CTP5' and @RegistryPath='SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10_50.OASYSHDB\Setup' and @RootPath='SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10_50.OASYSHDB']/Install[@ProductCode='8A665A38-9FFC-4220-B5C2-895F438EE5DF']

    2011-07-22 11:08:38 RS: STATUS: Repair started timing: MergeConfig

    2011-07-22 11:08:38 RS: STATUS: Repair_MergeConfig started

    2011-07-22 11:08:38 RS: Entering GetCurrentRepairServiceStatus()

    2011-07-22 11:08:38 Slp: Configuration action failed for feature RS_Server_Adv during timing MergeConfig and scenario MergeConfig.

    2011-07-22 11:08:38 Slp: Object reference not set to an instance of an object.

    2011-07-22 11:08:38 Slp: The configuration failure category of current exception is ConfigurationFailure

    2011-07-22 11:08:38 Slp: Configuration action failed for feature RS_Server_Adv during timing MergeConfig and scenario MergeConfig.

    2011-07-22 11:08:38 Slp: System.NullReferenceException: Object reference not set to an instance of an object.

    2011-07-22 11:08:38 Slp:    at Microsoft.SqlServer.Configuration.RSExtension.Helper.GetRSServiceName(String instanceName)

    2011-07-22 11:08:38 Slp:    at Microsoft.SqlServer.Configuration.RSExtension.SQLRSConfigurationPrivate.GetCurrentRepairServiceStatus(SQLRSConfigurationPublic rsPublicObj)

    2011-07-22 11:08:38 Slp:    at Microsoft.SqlServer.Configuration.RSExtension.SQLRSConfigurationPrivate.Repair_MergeConfig(Dictionary`2 actionData, PublicConfigurationBase spcb)

    2011-07-22 11:08:38 Slp:    at Microsoft.SqlServer.Configuration.RSExtension.SQLRSConfigurationPrivate.RepairImpl(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)

    2011-07-22 11:08:38 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)

    2011-07-22 11:08:38 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)

    2011-07-22 11:08:38 Slp: Exception: System.NullReferenceException.

    2011-07-22 11:08:38 Slp: Source: Microsoft.SqlServer.Configuration.RSExtension.

    2011-07-22 11:08:38 Slp: Message: Object reference not set to an instance of an object..

    2011-07-22 11:08:38 Slp: Watson Bucket 1 

     Original Parameter Values 

     

    2011-07-22 11:08:38 Slp: Parameter 0 : SQL Server 2008 R2@RTM@ 

     

    2011-07-22 11:08:38 Slp: Parameter 1 : Microsoft.SqlServer.Configuration.RSExtension.Helper.GetRSServiceName 

     

    2011-07-22 11:08:38 Slp: Parameter 2 : Microsoft.SqlServer.Configuration.RSExtension.Helper.GetRSServiceName 

     

    2011-07-22 11:08:38 Slp: Parameter 3 : System.NullReferenceException@-2147467261 

     

    2011-07-22 11:08:38 Slp: Parameter 4 : System.NullReferenceException@-2147467261 

     

    2011-07-22 11:08:38 Slp: Parameter 5 : SqlRSConfigAction_repair_mergeconfig 

     

    2011-07-22 11:08:38 Slp: Parameter 6 : REPAIR@MERGECONFIG@RS_SERVER_ADV 

     

    2011-07-22 11:08:38 Slp: 

     Final Parameter Values 

     

    2011-07-22 11:08:38 Slp: Parameter 0 : SQL Server 2008 R2@RTM@ 

     

    2011-07-22 11:08:38 Slp: Parameter 1 : 0xACA1A548 

     

    2011-07-22 11:08:38 Slp: Parameter 2 : 0xACA1A548 

     

    2011-07-22 11:08:38 Slp: Parameter 3 : 0x44A889F9 

     

    2011-07-22 11:08:38 Slp: Parameter 4 : 0x44A889F9 

     

    2011-07-22 11:08:38 Slp: Parameter 5 : SqlRSConfigAction_repair_mergeconfig 

     

    2011-07-22 11:08:38 Slp: Parameter 6 : 0x172D3170 

     

    2011-07-22 11:08:39 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110722_110502\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_

    2011-07-22 11:08:39 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110722_110502\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_

    2011-07-22 11:08:39 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110722_110502\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_

    2011-07-22 11:08:39 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110722_110502\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_

    2011-07-22 11:08:40 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110722_110502\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_

    2011-07-22 11:08:40 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110722_110502\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_

    2011-07-22 11:08:41 Slp: Object reference not set to an instance of an object.

    2011-07-22 11:08:41 Slp: Watson bucket for exception based failure has been created

    2011-07-22 11:41:25 Slp: Error: Action "SqlRSConfigAction_repair_mergeconfig_Cpu64" failed during execution.

    2011-07-22 11:41:25 Slp: Completed Action: SqlRSConfigAction_repair_mergeconfig_Cpu64, returned False

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Sco: Attempting to get feature configuration state for feature Analysis_Server_Full, instance MSAS10_50.OASYSHDB

    2011-07-22 11:41:25 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature Analysis_Server_Full, instance MSAS10_50.OASYSHDB, machine name MAINREPORTSVR

    2011-07-22 11:41:25 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MAINREPORTSVR

    2011-07-22 11:41:25 Slp: Sco: Attempting to open registry subkey 

    2011-07-22 11:41:25 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.OASYSHDB\ConfigurationState

    2011-07-22 11:41:25 Slp: Sco: Attempting to get registry value Analysis_Server_Full

    2011-07-22 11:41:25 Slp: Entering ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Sco: Attempting to get instance feature flag ClusterState for feature Analysis_Server_Full, instance MSAS10_50.OASYSHDB, machine name MAINREPORTSVR

    2011-07-22 11:41:25 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MAINREPORTSVR

    2011-07-22 11:41:25 Slp: Sco: Attempting to open registry subkey 

    2011-07-22 11:41:25 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.OASYSHDB\ClusterState

    2011-07-22 11:41:25 Slp: Sco: Attempting to get registry value Analysis_Server_Full

    2011-07-22 11:41:25 Slp: Exiting ValidateClusterStateForRepair

    2011-07-22 11:41:25 Slp: Sco: Attempting to get feature configuration state for feature Analysis_Server_Full, instance MSAS10_50.OASYSHDB

    2011-07-22 11:41:25 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature Analysis_Server_Full, instance MSAS10_50.OASYSHDB, machine name MAINREPORTSVR

    2011-07-22 11:41:25 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MAINREPORTSVR

     

    Monday, July 25, 2011 10:24 PM

All replies

  • Yes, or at least it looks like the same situation to me. The upgrade from SQL 2008 to 2008R2 failed because the msdb was a different collation. I used a rebuildmaster to get the SQL engine working again,  followed by a setup repair to get the agent running again. But no such luck on SSRS. The service didn't start and the report configuration manager can't find the instance ("provider load failure")

    I tried this tip (http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4c46da3b-17ed-4c1f-aa92-11bc09ff98ed, didnt work), a tip about adding perfmon entries to the registry and a tip about adding WBEM to the path (didnt work either). I read every log file I can find, and tried every Google search (maybe I should have tried Bing ;-), but somehow I doubt that ).

    Sunday, March 25, 2012 8:34 AM