funny problems installing Reporting

Discussion:

(too old to reply)

BobBobABob

2009-12-01 15:39:01 UTC

The set-up:
SCOM 2007 R2, single server solution with Windows 2008 R2, SQL 2008 Std with
Reporting Services installed & checked. all 64-bit.

SCOM 2007 R2 is installed & working fine, but when I try & install Reporting
sevices, after I enter the RS & SCOM server info, it starts installing then
finishes with 'the setup wizard was interrupted before OM 2007 R2 could be
installed', and then an error with 'value 3'.

I checked & found a few similar problems but not an exact match. I am
running the install as a DA, the DW & DRA accounts seem to have the correct
access to the OperationsManagerDW DB (checked in SQL). I was able to install
the DW only by just selecting that in the install, but reporting will not
install.

From the log file (line 9 seems like the start of the problem, not sure what
perms it needs(

2009-12-01T15:27:35.5539611+00:00 Debug: ManagementGroupConnectOrDisconnect:
SQL Server is: SCOMSERVER
2009-12-01T15:27:35.5549612+00:00 Debug: ManagementGroupConnectOrDisconnect:
Database Name is: OperationsManagerDW
2009-12-01T15:27:35.5549612+00:00 Debug: ManagementGroupConnectOrDisconnect:
Domain is: MYDOMAIN
2009-12-01T15:27:35.5549612+00:00 Debug: ManagementGroupConnectOrDisconnect:
User is: SCOMDWACT
2009-12-01T15:27:35.5559613+00:00 Debug: ManagementGroupConnectOrDisconnect:
logOnName is: MYDOMAIN\SCOMDWACT
2009-12-01T15:27:35.5559613+00:00 Debug: ManagementGroupConnectOrDisconnect:
MG GUID is: 321f3f78-2a26-4dad-e99b-9401a5cdf5e5
2009-12-01T15:27:35.5559613+00:00 Debug: ManagementGroupConnectOrDisconnect:
MG Default Name is: MgmtGroup1
2009-12-01T15:27:35.9490006+00:00 Debug: ManagementGroupDisconnectHelper:
Disconnect MG MgmtGroup1
2009-12-01T15:27:36.6310688+00:00 Error: ManagementGroupDisconnectHelper
error: Management group with id '321F3F78-2A26-4DAD-E99B-9401A5CDF5E5' is not
a member of this Data Warehouse or you do not have permissions to perform
actions for that management group.
2009-12-01T15:27:36.6340691+00:00 Error: StackTrace: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at
Microsoft.Reporting.Setup.ReportingManagedCAs.ManagementGroupDisconnectHelper(Session
session, String sqlServer, String databaseName, String domain, String user,
String password, String mgGuid, String mgDefaultName)
2009-12-01T15:27:36.6520709+00:00 Debug: ManagementGroupDisconnectHelper:
Disconnect success, now prepare connect MG MgmtGroup1
2009-12-01T15:27:36.6530710+00:00 Debug: ManagementGroupConnectHelper:
Prepare connect MG MgmtGroup1
2009-12-01T15:27:36.6620719+00:00 Error: ManagementGroupConnectOrDisconnect
error: Login specified as Management Group Writer Login is already specified
as writer login for another pending Management Group connect operation.
Choose different login or confirm/reject previous connect operation.
2009-12-01T15:27:36.6640721+00:00 Error: StackTrace: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at
Microsoft.Reporting.Setup.ReportingManagedCAs.ManagementGroupConnectHelper(Session
session, String sqlServer, String databaseName, String domain, String user,
String password, String logOnName, String mgGuid, String mgDefaultName)
at
Microsoft.Reporting.Setup.ReportingManagedCAs.ManagementGroupConnectOrDisconnect(Session session)
2009-12-01T15:27:36.6770734+00:00 Debug:

*** Trace Ended ***

CustomAction _ManagementGroupConnect returned actual error code 1603 (note
this may not be 100% accurate if translation happened inside sandbox)
MSI (s) (2C:20) [15:27:36:687]: NOTE: custom action _ManagementGroupConnect
unexpectedly closed the hInstall handle (type MSIHANDLE) provided to it. The
custom action should be fixed to not close that handle.
Action ended 15:27:36: InstallFinalize. Return value 3.

jag901

2010-01-30 18:43:01 UTC

Permalink

Did u get this fixed?

Post by BobBobABob
SCOM 2007 R2, single server solution with Windows 2008 R2, SQL 2008 Std with
Reporting Services installed & checked. all 64-bit.
SCOM 2007 R2 is installed & working fine, but when I try & install Reporting
sevices, after I enter the RS & SCOM server info, it starts installing then
finishes with 'the setup wizard was interrupted before OM 2007 R2 could be
installed', and then an error with 'value 3'.
I checked & found a few similar problems but not an exact match. I am
running the install as a DA, the DW & DRA accounts seem to have the correct
access to the OperationsManagerDW DB (checked in SQL). I was able to install
the DW only by just selecting that in the install, but reporting will not
install.
From the log file (line 9 seems like the start of the problem, not sure what
perms it needs(
SQL Server is: SCOMSERVER
Database Name is: OperationsManagerDW
Domain is: MYDOMAIN
User is: SCOMDWACT
logOnName is: MYDOMAIN\SCOMDWACT
MG GUID is: 321f3f78-2a26-4dad-e99b-9401a5cdf5e5
MG Default Name is: MgmtGroup1
Disconnect MG MgmtGroup1
2009-12-01T15:27:36.6310688+00:00 Error: ManagementGroupDisconnectHelper
error: Management group with id '321F3F78-2A26-4DAD-E99B-9401A5CDF5E5' is not
a member of this Data Warehouse or you do not have permissions to perform
actions for that management group.
2009-12-01T15:27:36.6340691+00:00 Error: StackTrace: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at
Microsoft.Reporting.Setup.ReportingManagedCAs.ManagementGroupDisconnectHelper(Session
session, String sqlServer, String databaseName, String domain, String user,
String password, String mgGuid, String mgDefaultName)
Disconnect success, now prepare connect MG MgmtGroup1
Prepare connect MG MgmtGroup1
2009-12-01T15:27:36.6620719+00:00 Error: ManagementGroupConnectOrDisconnect
error: Login specified as Management Group Writer Login is already specified
as writer login for another pending Management Group connect operation.
Choose different login or confirm/reject previous connect operation.
2009-12-01T15:27:36.6640721+00:00 Error: StackTrace: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at
Microsoft.Reporting.Setup.ReportingManagedCAs.ManagementGroupConnectHelper(Session
session, String sqlServer, String databaseName, String domain, String user,
String password, String logOnName, String mgGuid, String mgDefaultName)
at
Microsoft.Reporting.Setup.ReportingManagedCAs.ManagementGroupConnectOrDisconnect(Session session)
*** Trace Ended ***
CustomAction _ManagementGroupConnect returned actual error code 1603 (note
this may not be 100% accurate if translation happened inside sandbox)
MSI (s) (2C:20) [15:27:36:687]: NOTE: custom action _ManagementGroupConnect
unexpectedly closed the hInstall handle (type MSIHANDLE) provided to it. The
custom action should be fixed to not close that handle.
Action ended 15:27:36: InstallFinalize. Return value 3.

Muhammad Saad

2010-03-26 17:46:14 UTC

Permalink

In my Case my SCOM Operational database on a clustered instance and Reporting
database is on local instance and i am facing the same issue.what i see by
the SCOM Log is my SCOM operational database size is not enough to add the
more Data of SCOM Reporting, i just go to Sql Data and enable auto Grow
option and then i able install the SCOM Reporting Successfully

Cheers

Saad