I am trying to update a database table through write to data store entity smart

Certified Lead Developer
I am trying to update a database table through write to data store entity smart service. The CDT has an ID column which is defined as follows:
<xsd:element form="qualified" name="routingRuleWorkflowId"
nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
                                        @Id
                                        @GeneratedValue
                              </xsd:appinfo>
</xsd:annotation>
</xsd:element>



When the table is created with the above xsd definition (along with some additional columns) – a Primary Key constraint is also created automatically in DB for this column with name: C0079862.


When I am trying to write above CDT to table – I am getting following error:
Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (BPMBUSINESS.SYS_C0079862) violated
[Appian Work Item - 30984 - ProcessExec01 : UnattendedJavaActivityRequest] ERROR com.appiancor...

OriginalPostID-167906

OriginalPostID-167906

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    ...p.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=269041297, classname=com.appiancorp.process.runtime.activities.WriteToDataStoreSmartService
    (Appian Work Item - 30984 - ProcessExec01 : UnattendedJavaActivityRequest) com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.duringWrite.userMsg=An error occurred while trying to write to the entity “RoutingRuleWorkflows” [id=e441eea9-cc6c-459a-ad31-0d8179728dd7@87483, type=XXX_RoutingRuleWorkflows (id=4222)] (data store: XXXDatastore). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (BPMBUSINESS.SYS_C0079862) violated
    (Appian Work Item - 30984 - ProcessExec01 : UnattendedJavaActivityRequest) Data: TypedValue[it=4223,v={{2,2,1,0,1,1,1,1,0,Ketan,<null>,ketan,2015-09-17 20:27:16.53,1,1,1},{<null>,2,1,0,1,0,1,0,1,ketan,2015-09-17 20:27:16.53,9/...
Reply
  • 0
    Certified Lead Developer
    ...p.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=269041297, classname=com.appiancorp.process.runtime.activities.WriteToDataStoreSmartService
    (Appian Work Item - 30984 - ProcessExec01 : UnattendedJavaActivityRequest) com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.duringWrite.userMsg=An error occurred while trying to write to the entity “RoutingRuleWorkflows” [id=e441eea9-cc6c-459a-ad31-0d8179728dd7@87483, type=XXX_RoutingRuleWorkflows (id=4222)] (data store: XXXDatastore). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (BPMBUSINESS.SYS_C0079862) violated
    (Appian Work Item - 30984 - ProcessExec01 : UnattendedJavaActivityRequest) Data: TypedValue[it=4223,v={{2,2,1,0,1,1,1,1,0,Ketan,<null>,ketan,2015-09-17 20:27:16.53,1,1,1},{<null>,2,1,0,1,0,1,0,1,ketan,2015-09-17 20:27:16.53,9/...
Children
No Data