locked
Gather Data stopped working RRS feed

  • Question

  • Hi, we are in a migration from 2007 to 2012.

    Right now, we face the fact, that GATHER DATA Process for the 2007 Sites stopped working.

    The account or PWD has not changed.. and is also not locked. The Migctrl. log just says:

                                                                    ERROR: [Worker]:         System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.     at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)     at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)     at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, 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.ExecuteReader(CommandBehavior behavior, String method)     at System.Data.SqlClient.SqlCommand.ExecuteReader()     at Microsoft.ConfigurationManagement.MigrationManager.LegacyRepository.GetDataReader(String sqlQuery, Dictionary`2 parameters, Boolean ignoreLocalSite)     at Microsoft.ConfigurationManagement.MigrationManager.SyncAgentJob.<SyncDependencies>d__75.MoveNext()     at Microsoft.ConfigurationManagement.MigrationManager.SyncAgentJob.<SyncObjectsInformation>d__25.MoveNext()     at Microsoft.ConfigurationManagement.MigrationManager.ExtensionMethods.<AttachErrorHandler>d__6`1.MoveNext()     at Microsoft.ConfigurationManagement.MigrationManager.ExtensionMethods.<AttachErrorHandler>d__6`1.MoveNext()    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
    STATMSG: ID=8617 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_MIGRATION_MANAGER" SYS=HAMI0371.Global.BDFGroup.net SITE=BDF PID=5728 TID=5224 GMTDATE=Di Aug 07 04:01:36.491 2012 ISTR0="HAMI0371.Global.BDFGroup.net (BDF)" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    [Worker]: ==================== Sync Agent Job 3 Ended ====================    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    ERROR: [Worker]: System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.     at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)     at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)     at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, 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.ExecuteReader(CommandBehavior behavior, String method)     at System.Data.SqlClient.SqlCommand.ExecuteReader()     at Microsoft.ConfigurationManagement.MigrationManager.LegacyRepository.GetDataReader(String sqlQuery, Dictionary`2 parameters, Boolean ignoreLocalSite)     at Microsoft.ConfigurationManagement.MigrationManager.SyncAgentJob.<SyncDependencies>d__75.MoveNext()     at Microsoft.ConfigurationManagement.MigrationManager.SyncAgentJob.<SyncObjectsInformation>d__25.MoveNext()     at Microsoft.ConfigurationManagement.MigrationManager.ExtensionMethods.<AttachErrorHandler>d__6`1.MoveNext()     at Microsoft.ConfigurationManagement.MigrationManager.ExtensionMethods.<AttachErrorHandler>d__6`1.MoveNext()     at Microsoft.ConfigurationManagement.MigrationManager.SyncAgentJob.<get_ExecutionPlan>d__7.MoveNext()     at Microsoft.ConfigurationManagement.MigrationManager.Job`1.ExecuteNext()    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    [Worker]: Start processing status changed event for MIG_SiteMapping.ID=3    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    [Worker]:         Set the schedule item 3 end time    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    [Worker]:         Set the schedule item 3 status to Failed    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    [Worker]: End processing status changed event for MIG_SiteMapping.ID=3    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    [Worker]: Disposing Job 3    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    [Worker]: Disposing worker    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    [Worker]: Disposing current site connection    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    [Worker]: Removing Job 3 from job manager.    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
                                                                    [Worker]: Removing the Job with Id 3.    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
    ERROR: [MigMCtrl]: FAILED to EXECUTE job. error = Unknown error 0x80131509, 80131509    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
    ERROR: [MigMCtrl]: FAILED to EXECUTE job. error = Unknown error 0x80131509, 80131509    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    5224 (0x1468)
    Connection string = Data Source=(local);Initial Catalog=CM_BDF;Integrated Security=True;Persist Security Info=False;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=False;Application Name="Migration Manager".    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    6308 (0x18A4)
    Created new sqlConnection to (local)    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    6308 (0x18A4)
    [MigrationManager]: Start two step scheduling for MIG_SiteMapping    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    6308 (0x18A4)
    [MigrationManager]:         Step 1. Query the schedule items that was running or requested to start immediately ...    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    6308 (0x18A4)
    [MigrationManager]:         Step 2. Query the first item in order of DateNextRun ...    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    6308 (0x18A4)
    [MigrationManager]:                 The item MIG_SiteMapping 2 is scheduled to run at 08/07/2012 06:01:08 UTC, 08/07/2012 08:01:08 Local Time, sleep for 01:59:32.0860000.    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    6308 (0x18A4)
    [MigrationManager]: End two step scheduling for MIG_SiteMapping    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    6308 (0x18A4)
    Connection string = Data Source=(local);Initial Catalog=CM_BDF;Integrated Security=True;Persist Security Info=False;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=False;Application Name="Migration Manager".    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    6308 (0x18A4)
    Created new sqlConnection to (local)    SMS_MIGRATION_MANAGER    07.08.2012 06:01:36    6308 (0x18A4)

    Any Ideas... we got no clue... and even cannot continue with the migration.. because we dont get any updates on the DPs.. we are migrating...

    Tuesday, August 7, 2012 5:39 AM

All replies

  • I have seen a similar error in the past. I recommend that you look in CM07 to see if something is causing the error. Look at the status messages and the log files. In my case it was a collection causing the problems.

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund

    Tuesday, August 7, 2012 5:57 AM
  • Hi Kent, thx for the quick response. you got any specific LOG to look at... ?
    Tuesday, August 7, 2012 6:00 AM
  • http://blog.coretech.dk/kea/error-migrating-from-configmgr-2007-to-configmgr-2012/ It might not be the same problem that you have, but it's worth a try.

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund

    Tuesday, August 7, 2012 6:05 AM
  • no collection.. seems to be that some advertisements may cause this.....

    CPolicySource::CreateSoftwarePolicy: Package hash data (BSS00357) has not been created or replicated on this site, will retry later.    SMS_POLICY_PROVIDER    07.08.2012 08:20:08    7112 (0x1BC8)
    Failed to create policy and policy assignment based on package BSS00357, program VR0758XX101 Uninstall and offer BSS20BEA    SMS_POLICY_PROVIDER    07.08.2012 08:20:08    7112 (0x1BC8)
    CPolicySource::CreateSoftwarePolicy: Package hash data (BSS001CF) has not been created or replicated on this site, will retry later.    SMS_POLICY_PROVIDER    07.08.2012 08:20:08    7112 (0x1BC8)
    Failed to create policy and policy assignment based on package BSS001CF, program VR0754XX102 Install and offer BSS2056A    SMS_POLICY_PROVIDER    07.08.2012 08:20:08    7112 (0x1BC8)
    CPolicySource::CreateSoftwarePolicy: Package hash data (BSS00357) has not been created or replicated on this site, will retry later.    SMS_POLICY_PROVIDER    07.08.2012 08:20:08    7112 (0x1BC8)
    Failed to create policy and policy assignment based on package BSS00357, program VR0758XX101 Install and offer BSS20BE9    SMS_POLICY_PROVIDER    07.08.2012 08:20:08    7112 (0x1BC8)

    Tuesday, August 7, 2012 6:29 AM
  • let us know

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund

    Tuesday, August 7, 2012 6:30 AM