After registering the Integration Pack of System Center Configuration Manager 2012 SP1 I tried to use the activity “query configmgr” to get the results of a predefined SCCM-query into my runbook.
When trying to check in the runbook i received an error:
"An error occured saving the activity to the data storage. Please check the Orchestrator Management Service trace logs."
So did I and found the following
2013-03-21 07:18:55 [2300] 1 CODBDataStore::ModifyObject({38C5285B-7812-4A14-B8C3-12E4260B31E2}): try again
2013-03-21 07:18:55 [2300] 1 DBDataStore: ::(InternalSaveObject)
2013-03-21 07:18:55 [2300] 1 DBDataStore: ::Error #-2147217873
Description: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_OBJECTS_OBJECTTYPES". The conflict occurred in database "Orchestrator", table "dbo.OBJECTTYPES", column 'UniqueID'.
Source: Microsoft OLE DB Provider for SQL Server
Error #-2147217873
Description: The statement has been terminated.
Source: Microsoft OLE DB Provider for SQL Server
2013-03-21 07:18:55 [2300] 1 DBDataStore: ::Exception caught in long __thiscall CODBDataStore::InternalSaveObject(wchar_t *,wchar_t *,struct IXMLDOMNode *):
ODBDataStore.cpp(3449)
<Exception><Type>_com_error</Type><ErrorMessage>IDispatch error #3119</ErrorMessage><Description>The INSERT statement conflicted with the FOREIGN KEY constraint "FK_OBJECTS_OBJECTTYPES". The conflict occurred in database "Orchestrator", table "dbo.OBJECTTYPES", column 'UniqueID'.</Description><HResult>-2147217873</HResult></Exception>
2013-03-21 07:18:55 [2300] 1 DBDataStore: ::Error #-2147217873
Description: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_OBJECTS_OBJECTTYPES". The conflict occurred in database "Orchestrator", table "dbo.OBJECTTYPES", column 'UniqueID'.
Source: Microsoft OLE DB Provider for SQL Server
Error #-2147217873
Description: The statement has been terminated.
Source: Microsoft OLE DB Provider for SQL Server
2013-03-21 07:18:55 [2300] 1 CODBDataStore::ModifyObject({38C5285B-7812-4A14-B8C3-12E4260B31E2}): attempt 10 failed
Now i searched for the UniqueID "38C5285B-7812-4A14-B8C3-12E4260B31E2" in the table "dbo.OBJECTTYPES" in the Orchestrator DB but there is no column with this id.
I uninstalled the Integration Pack for SCCMSP1 on the runbook designers and runbook server, restarted the server, registered the SCCMSP1-IP again but the runbooks still can´t be checked in.
As I saw, the DB-Entries for the SCCM IP were never deleted while the IP was not installed.
It seems to be a wider spread problem, as another member of technet gets the same problem.
I will update this post if there is any solution to this.
Meanwhile you can follow the thread on technet: http://social.technet.microsoft.com/Forums/en-US/scogeneral/thread/7dab8517-d760-4ea5-9d70-3fb78ffd806c