• State Verified Answer
  • +2 person also asked this people also asked this
  • Replies 12 replies
  • Subscribers 8 subscribers
  • Views 6294 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Can not update existing data after changing CDT org.hibernate.ObjectDeletedException

manisht

Hi,

I have a complex CDT structures in the Processes. Earlier i was able to save retrieve and update the data. i made few changes to the CDT and now save a nd retrieve works but I cant update an existing data. I get an exception on "Write to DataStore Node".

I have verified in the process models all pvs and sub-process mappings refer to the latest cdts. I was succesfull in saving the Processes and publishing them eliminating the chances of missing some previous references to the CDT(I think).

The alert and server logs dont specify much but say some deleted object will be recreated.

Here is what i get in the alerts
"There is a problem with task “Write to Data Store Entity” in the process “ Initiate Request”. An error occurred while trying to write to the entity “CK_Request_ET” [id=b886d2c3-19ad-49c2-996a-dccaf4845d09@59999, type=Request (id=12412)] (data store: CK_DATA_STORE). Details: org.hibernate.ObjectDeletedException: deleted object would ...

OriginalPostID-128485

OriginalPostID-128485

  Discussion posts and replies are publicly visible

Parents
  • 0
    It should be an update.

    Error : There is a problem with task “Enter Collect Status” in the process “BW_CK_START01182”. An error occurred while trying to write to the entity “CBG_CDD_Request_ET”
    [id=67850886-6197-4292-ac4b-e725d3338231@21306, type=CBG_CDD_Request (id=4672)] (data store: CBG_CDD_DATASTORE). Details: org.hibernate.exception.ConstraintViolationException:
    Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (APPIAN_BUSINESS.SYS_C0011202) violated Data: TypedValue[it=4672,v={3,1183,TestRequestType,TestClientName,
    TestUniqueIdentifier,TestProduct,,....................

    But as I mentioned its text type with multiple occurrence, so we are not creating table for it. In turn appian is creating to maintain the multiple choices inside a question type.
    in some questions that dont have choice it is empty and in others it is either single or multiple.
    I am attaching the request object for your reference. you can see choices in question.

    just mentioning again, In our dev env it is working as expected. And even on QA it was good before the import

    RequestValues.txt

Reply
  • 0
    It should be an update.

    Error : There is a problem with task “Enter Collect Status” in the process “BW_CK_START01182”. An error occurred while trying to write to the entity “CBG_CDD_Request_ET”
    [id=67850886-6197-4292-ac4b-e725d3338231@21306, type=CBG_CDD_Request (id=4672)] (data store: CBG_CDD_DATASTORE). Details: org.hibernate.exception.ConstraintViolationException:
    Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (APPIAN_BUSINESS.SYS_C0011202) violated Data: TypedValue[it=4672,v={3,1183,TestRequestType,TestClientName,
    TestUniqueIdentifier,TestProduct,,....................

    But as I mentioned its text type with multiple occurrence, so we are not creating table for it. In turn appian is creating to maintain the multiple choices inside a question type.
    in some questions that dont have choice it is empty and in others it is either single or multiple.
    I am attaching the request object for your reference. you can see choices in question.

    just mentioning again, In our dev env it is working as expected. And even on QA it was good before the import

    RequestValues.txt

Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.