web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Form invalid record insert issue - after submitting RFQ Case to custom workflow

(0) ShareShare
ReportReport
Posted on by

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) 

Screen-Shot-2017_2D00_10_2D00_18-at-09.02.01.png

How to solve this issue?

Thanks in advance!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Thanks, but no result.

    Cache/sync unlikely - form, tables compiled/sync ,Incremental CIL done, xppIL cleared, AOS restarted.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans