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

Ketan Patel

Certified Lead Developer

over 8 years ago

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...

Discussion posts and replies are publicly visible

Top Replies

Ketan Patel over 8 years ago +1
Certified Lead Developer

...17/2015 8:27 PM GMT+00:00,2015-09-17 20:27:16.53,2,0,1}}]] alertMsg[error.duringWrite.alertMsg=An error occurred while trying to write to the entity “RoutingRuleWorkflows” [id=e441eea9-cc6c-459a-ad31…

Parents

0 Ketan Patel
Certified Lead Developer
over 8 years ago

...17/2015 8:27 PM GMT+00:00,2015-09-17 20:27:16.53,2,0,1}}]] alertMsg[error.duringWrite.alertMsg=An error occurred while trying to write to the entity “RoutingRuleWorkflows” [id=e441eea9-cc6c-459a-ad31-0d8179728dd7@87483, type=RoutingRuleWorkflows (id=4222)] (data store: XXXMDatastore). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (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/17/2015 8:27 PM GMT+00:00,2015-09-17 20:27:16.53,2,0,1}}]]
(Appian Work Item - 30984 - ProcessExec01 : UnattendedJavaActivityRequest) at com.appiancorp.suiteapi.process.exceptions.SmartServiceException$Builder.build(SmartServiceException.java:127)

The CDT has two records:
Record1...
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Ketan Patel
Certified Lead Developer
over 8 years ago

...17/2015 8:27 PM GMT+00:00,2015-09-17 20:27:16.53,2,0,1}}]] alertMsg[error.duringWrite.alertMsg=An error occurred while trying to write to the entity “RoutingRuleWorkflows” [id=e441eea9-cc6c-459a-ad31-0d8179728dd7@87483, type=RoutingRuleWorkflows (id=4222)] (data store: XXXMDatastore). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (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/17/2015 8:27 PM GMT+00:00,2015-09-17 20:27:16.53,2,0,1}}]]
(Appian Work Item - 30984 - ProcessExec01 : UnattendedJavaActivityRequest) at com.appiancorp.suiteapi.process.exceptions.SmartServiceException$Builder.build(SmartServiceException.java:127)

The CDT has two records:
Record1...
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data