
Hi dear colleagues!
I have a strange issue with Purchase RFQ list page form, where applied to custom workflow.
So, when user submits any RFQ to workflow, the system gives error like "
Cannot create a record in Request for quotations publish cases (PurchRFQPublishTable_PSN). PurchRFQCaseTableRecId: 0, 0.
The record already exists.)
After ctrl+f5 error disappears.
But, the same RFQ successfully sends from Purch RFQ case table form, from inside of RFQ form.
Custom workflow already 1 years worked without this error, i think issue not related with workflow's class methods or PurchRFQCaseTable update methods. User just clicked to Submit , sent RFQ to Workflow and changed custom field - approval status to Submitted.
PurchRFQ list page form inherited from PurchRFQListPageTIteration class and has 2 datasource PurchRFQCaseTable, PurchRFQPublishTable_PSN .
Looks like the form tries to insert record to PurchRFQPublishTable_PSN table with PurchRFQRecId = 0 and index gives error, but it is abnormal, so we didn't publish RFQ.
Here screenshot of debug (i specially changed insert method, ignore it)
How to solve this issue?
Thanks in advance!
*This post is locked for comments
I have the same question (0)Thanks, but no result.
Cache/sync unlikely - form, tables compiled/sync ,Incremental CIL done, xppIL cleared, AOS restarted.