locked
Error while checking in runbook with "query configmgr" activity RRS feed

  • Question

  • Hi Everyone,

    i´ve got some trouble with the activity "query configmgr":

    Environment:

    SCORCH 2012SP1 (upgraded DB from SCORCH 2012) and SCCM 2012SP1

    If "query configmgr" is in any runbook,I´m not able to check in this runbook and get this 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. 

    Is there a way to force the IP-Installation to rewrite the DB-Entries? Maybe this way the Activity would get inserted to the DB?

    Thanks for your help!

    chri_tea 

      
    Thursday, March 21, 2013 8:52 AM

Answers

  • Sorry, forgot to update this thread. This is a defect in the packaging of the IP.  The activity does not get registered correctly in the database. The PFE gave me a couple SQL scripts that I ran which did that and viola! Everything worked correctly again. I do not have the scripts since this is a one time shot. At least that is what I remember.

    HTH

    Jim

    Wednesday, September 23, 2015 8:11 PM

All replies