Sign In  Sign Up Live-Chat

Oracle Exception while creating/updating process instance

Last post 01-05-2008, 5:56 AM by iret. 2 replies.
Sort Posts: Previous Next
  •  12-19-2007, 6:31 AM 106689

    Oracle Exception while creating/updating process instance

    While creating/updating process instance we are getting following oracle exceptions:

    ^^-------------------------------------------------------------------^^
    Source  : System.Data.OracleClient
    Method  : CheckError
    Date  : 2:56:39 PM
    Time  : 12/11/2007
    Error  : Rollback of Aspose Workflow transaction happened.,ORA-22922: nonexistent LOB value
    ORA-06512: at "TPESS.WORKFLOW_SAVEACTIVITYDATA", line 30
    ORA-06512: at line 1
    Stack Trace : at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
       at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
       at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
       at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
       at x2b1298adb48a52e7.x285cf195701c5a4a.Persist(xe584a83baa10f67e var, xe181a1cadf7490e1 ti)
       at x10763278ed98d245.x8233c0336894cc45.Persist(xe584a83baa10f67e var, xe181a1cadf7490e1 ti)
       at x7e8bbce6fec2b3e7.DoPersist(xe181a1cadf7490e1 t)
       at xd0bfdab2df603e6b.x0a77fb3a5a6f6664.Persist(xe181a1cadf7490e1 t, x11bbead5c1b0e3a7 persistence)
       at xc26610dacef50ada.x2095013df7cec01f.CompleteTaskEx2(String taskId, IDictionary variables, Boolean executeTool, IRuntimeCallback callback, DateTime simulateDateTime)
    ^^-------------------------------------------------------------------^^

    ^^-------------------------------------------------------------------^^
    Source  : System.Data.OracleClient
    Method  : CheckError
    Date  : 3:17:15 PM
    Time  : 12/11/2007
    Error  : DeadLineCheck Fail:,ORA-22922: nonexistent LOB value
    ORA-06512: at "TPESS.WORKFLOW_SAVEPROCESSDATA", line 22
    ORA-06512: at line 1
    Stack Trace : at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
       at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
       at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
       at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
       at x2b1298adb48a52e7.x758ff3d5037da8f3.Persist(xd0067f48fa945cc2 var, xe181a1cadf7490e1 ti)
       at x10763278ed98d245.x8233c0336894cc45.Persist(xd0067f48fa945cc2 var, xe181a1cadf7490e1 ti)
       at x96460fb1d55c73b8.DoPersist(xe181a1cadf7490e1 t)
       at xd0bfdab2df603e6b.x0a77fb3a5a6f6664.Persist(xe181a1cadf7490e1 t, x11bbead5c1b0e3a7 persistence)
       at x05275b37e9dcfae8.xc39a68845ce59ffe.CheckDeadlines()
       at xf270d4e82e64cb05.xfa907197a66cff21.x7d1fa06c2e560da1()
    ^^-------------------------------------------------------------------^^

    Can anybody gives us its reson and/or solution.

     

     
  •  12-23-2007, 9:51 PM 107068 in reply to 106689

    Re: Oracle Exception while creating/updating process instance

    Hello,

    Our developer is working on this issue. We will get back to you shortly.

    Best regards


    Team Lead
    Aspose Guangzhou Team
    About Us

    Contact Us
     
  •  01-05-2008, 5:56 AM 107827 in reply to 107068

    Re: Oracle Exception while creating/updating process instance

    Attachment: Present (inaccessible)
    Hello,

    The root is described in the oracle KB:

    ORA-22922: nonexistent LOB value
    Cause: The LOB value associated with the input locator does not exist. The information in the locator does not refer to an existing LOB.
    Action: Repopulate the locator by issuing a select statement and retry the operation.

    I have added some fix. Please try to replace the store-procedures with the attached.


    Team Lead
    Aspose Guangzhou Team
    About Us

    Contact Us
     
View as RSS news feed in XML