X++: Cannot insert multiple records in table. The insert_recordset operation cannot be performed due to an internal error.

(0) Share

Report

Posted on by Liya Cheng

Description:

i create a test case, need to use insert_recordset statement to insert record which include utcdatetime field, sometime the test case can run passed, but sometime it will failed due to the error: Cannot insert multiple records in table. The insert_recordset operation cannot be performed due to an internal error. it is unstable .the tables and test code are very simple, only insert one record to on table, and use insert_recordset to insert to another table, so please give me some suggestions , Thanks! (PS: only can use insert_recordset , because we want to test the insert_recordset statements)

I have the same question (0)

All responses (22)

Answers (2)

Blue Wang on at

Like (0)

Report

Hi Apple,

Sharing code will be better.

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

Seeing the code would really help, as well as any additional details.

Was this reply helpful? Yes No
Liya Cheng on at

Like (0)

Report

you can refer to the following code, The error is an random issue, cannot be reproduced steadily. and two table is a simple and regular tables. because i try many ways , but cannot find any ways t improve the testcase, so do you know what can we do to improve it to avoid the error based on using insert_recordset.

Table1 : regular table, Fields: StrField, copyCreatedDateTime(Type: utcDateTime), copyModifiedDateTime(Type:utcDateTime)

Table2: regular table, Field: Field1, set properties of Created Date Time and Modified DateTime to Yes

class Class1 extends SysTestCase

{

Table2 table2;

public void setUp()

{

ttsbegin;

table1.Field1 = "testField";

table1.insert();

ttscommit;

}

[SysTestCheckInTest]

public void testMethod()

{

// Arrange.

Table1 table1;

Table2 localTable2;

// Execute.

table1.selectForUpdate(true);

ttsbegin;

insert_recordset table1(CopyCreatedDateTime, CopyModifiedDateTime, StrField)

select CreatedDateTime, ModifiedDateTime, Field1

from localTable2;

ttscommit;

}

}

Was this reply helpful? Yes No
Liya Cheng on at

Like (0)

Report

please refer to the above answer , please give me some suggestions , thanks!

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

Could it be that the record that you are trying to insert is a duplicate?

You could try to run it in a while select statement and individual inserts for a while and see if it fails with a more meaningful error message.

Was this reply helpful? Yes No
Liya Cheng on at

Like (0)

Report

i am confused, because i clear table before create records, it shouldn't have cache records, why it is a duplicate? and because the case is test insert_recordset statement, so i must use it , cannot change to while select statement or other

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Well, I don't know anything about your table except what you shared. So I can't tell if there could be duplicate records or not when your test runs.

Of course you don't need to change your test into a while statement to get more info. It was just a suggestion to change it temporarily. Other option is to keep it like it is, and not get the additional info that the while statement could possibly give you.

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

Like (0)

Report

Where do you clear the records? I see the opposite - you explicitly insert a record to table1 in setUp().

Nikolaos suggested using a while select for debugging. That you don't want to use it in your final implementation doesn't mean that you can use it during development to isolate the bug.

Was this reply helpful? Yes No
Liya Cheng on at

Like (0)

Report

sorry, the teardown() method i didn't attached. in my code, i use teardown method to delete table.

i am sorry for misunderstand Nikolaos' meaning, i will try it.

Was this reply helpful? Yes No
Liya Cheng on at

Like (0)

Report

i am sorry for misunderstand your meaning, i will try to debug it use while select statement , thanks!

Was this reply helpful? Yes No