Error when trying to save a CDT to DB

mohamedb over 7 years ago

I am getting the following error when trying to save a CDT to DB:

There is a problem with task “Write to Request Detail” in the process “WMG GBL Save Request Details”. An error occurred while trying to write to the entity “WMG_GBL_FEE_SETUP” [id=566906b6-f383-47f2-97ed-7bd271f36013@164611, type=WMG_GBL_FEE_SETUP (id=1675)] (data store: PCS_DS). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (APPIAN_WMG_BD.SYS_C0084174) violated Data: TypedValue[it=1675,v={266,417569,666666666,2016-08-11 21:05:56.08,badram01,2016-08-11 21:05:56.08,badram01,In Progress,999.0,999.0,999.0,999.0,Negotiated with client,No,999.0,999,999,2016-08-08,2016-08-19,Monthly,,2016-08-08,<null>,<null>,,,<null>,,,,,Fee Exception,,<null>,{}}]
Problem: An error occurred in executing an Activity Class.
Recommended Action: Examine the activity class to correct the error a...

Discussion posts and replies are publicly visible

0 mohamedb over 7 years ago

...nd then resume.
Priority of this problem: High Priority

The CDT allows all fields to be Nillable except for the primary key.

It also has two columns:
<xsd:element name="insAllocationIncome_int" nillable="true" type="xsd:int" />
<xsd:element maxOccurs="unbounded" minOccurs="0" name="methodOfChargingFee_txt" nillable="true" type="xsd:string" />

Not sure if they are causing the problem.

Have anyone encountered the same problem?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sonalk over 7 years ago

Hi Mohamed,
It looks like you are inserting a new record instead of overwriting the existing one, due to which the error occurs.
Are you using the stored values of the "Write to database" node and storing into the CDT to get the latest primary key ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 7 years ago

Hi Mohamed, Please try to execute the below query in your oracle database
SELECT * FROM ALL_CONS_COLUMNS WHERE CONSTRAINT_NAME = 'SYS_C0084174'
This should give you the exact column which is throwing the error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedb over 7 years ago

Hi narasimhaadityac, thanks for your help. This is the output. It is automatically generated I guess. Do you know how to resolve this problem?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 7 years ago

Could you please check your CDT if these two columns are used. if yes then whether the data provided for those columns already exists in the database table?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedb over 7 years ago

Not at all, those columns are not in the CDT.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 7 years ago

Could you please verify if these two columns are defined as not null able ?
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME IN ()
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 7 years ago

One more reason I am suspecting could be that.. there might be any trigger that is present on your table which might be trying to insert to the other table and which was causing an issue, can you please verify that aspect as well, if there are any triggers present on your entity you are trying to update in Oracle?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedb over 7 years ago

Well, it seems like those columns are autogenerated by appian for nested CDTs inside the main CDT. When we try to *update* the main CDT it throws that error. Not sure if the same will happen on an *Insert*.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedb over 7 years ago

A resolution for this is to delete the row; then to re-insert it again. If the database generated primary key does not matter.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel