Encountering Process Errors in record Type nodes post oracle database data sync to tables in lower environments.

Question

Hi All, 
We are facing  issue where record type is involved in all our processWe have requested out Oracle DBA Team to sync production data to lower environments after that we in Appian have synced the record types (using Sync Option- Start Full Sync) as our application is record type driven. We created requests in UI for just testing the flows and all the Process models started failing at the record types with error: 
Unable to write to or delete from the source due to a data integrity violation.Error Details: ORA-00001: unique constraint (BPMDEV.SYS_C00153674) violated.
So, have just tried hoping this would solve the issue By  going to data model in record type -In Source Selected the option Change source and selected the option database and selected the same table again, now if I'm trying to restart the failed node it is throwing an error like Unable to write to or delete from the source due to a data integrity violation.Error Details: ORA-01400: cannot insert NULL into ("DEV"."SI_EVENT"."SI_EVENT_ID")

Could you please suggest what actually can be done here as no changes have been implemented by us before or after.

shubhama926776 · Answer

Based on my understanding issue might be, Data refresh without sequence sync = guaranteed primary key conflicts in Appian record writes.

Ask Oracle DBA to reset All sequences for your record type tables:

SELECT MAX(SI_EVENT_ID) + 1 FROM RID_SI_EVENT; (Find out what the highest ID currently in the table is)
ALTER SEQUENCE your_sequence_name RESTART WITH [max_value + 1];(Reset the sequence to start from that number)

Don't use Change Source to same table, this corrupts mappings.
Verify record to ensure primary key fields are set to autogenerate
Clear and Full Sync the record types again
Restart failed process instances.

Let me know if that works for you.

Sign up

Login with SSO

Login to the community

Login with SSO