RecordInsertList.add(Common) Method error

(0) Share

Report

Posted on by Community member

Hi,

I'm using RecordInsertList to insert records.

There is same record has existed in DB, so the error should be throw when insertDatabase() called.

I understand that the add method only insert buffer to memory, but the method add throw error Microsoft.Dynamics.Ax.Xpp.DuplicateKeyNotRecoveredException

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Martin Dráb 239,055 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

No, your understand isn't correct. You believe that if you add a million records, the systems holds all of them in memory and that it makes a single insert with million rows. That's not what RecordInsertList is for.

RecordInsertList adds records in bathes (if possible), but not necessarily in just a single batch. For example, if decides to insert records in a batch of 100 records, there are inserts to DB when you call add() for the 100th record, 200th record and so on. insertDatabase() just ensures that remaining records, that haven't been inserted yet, are inserted too.

Note that you should consult the documentation if you're unsure about how something works. In this case, you can find it under RecordInsertList Class.

Was this reply helpful? Yes No
Community member 12 on at

Like (0)

Report
Copy link

Link copied!

Thank Martin,

Ive already read document for every method of class, and a lot of other post on google before posted a question, but I cant guess the add method do insert by batch of records.

(the google translate "flush" = "delete", my bad).

Was this reply helpful? Yes No
Martin Dráb 239,055 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It's not the most detailed explanation, but the information is there.

You see that "The add method can flush records to the database [...]" and "insertDatabase method [is used] to insert all remaining records".

You can also read that "Records are inserted only when the kernel finds the time appropriate, but no later than the call to the insertDatabase". This contradicts your original assumption, which can be formulated like "Records are inserted only when insertDatabase is called".

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report
Copy link

Link copied!

Same problem here.

If I skip RecordInsertList the problem doesn't appear, so it is not related to the data itself.

Always come at record count 63 not depends the field values.

Really annoying.

Was this reply helpful? Yes No