Microsoft Dynamics AX (Archived)

update_recordset hangs/ doesn't finish execution

(0) Share

Report

Posted on by BrandonSA

1,673

Hi everyone

I need help regarding the update_recordset.

The one I have implemented in my code works for small amounts of data but hangs for large amounts of data (ie. 12000 records)

The statement looks like this:

update_recordSet mytable

setting

ImportStatus = _status,
HasError = NoYes::No,
InfologData = conNull()

where mytable.field1 = _field1

&& mytable.field2 = _field2;

- ImportStatus is an enum, HasError is an Enum, InfologData a container

- myTable has no code on it; it does not have an overridden update method

- Also tried AOS restart and CIL compilation

Yesterday this statement took up to 14 hours to execute with no result; we had to kill the Ax session.

Does anyone know what the problem is or have any solutions or know how to update/optimise this?

Thank you

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Mea_ 60,284 on at

Like (0)

Report

RE: update_recordset hangs/ doesn't finish execution

Hi BrandonSA,

Did you try to look at blocking transactions report in SQL management studio while you are executing this statement ?

Because if this table is updated via another transaction it could be locked by another update\delete\insert statement.

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

RE: update_recordset hangs/ doesn't finish execution

When you say small amounts of data what number are you talking about?

Also do you have database log activated on this table?

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: update_recordset hangs/ doesn't finish execution

Do you have any validateField, modifiedField, validateWrite, or update method overrides on your table?

If yes, the set-based operation will fall back from SQL to row-based operation, so it would take a long time.

Also make sure you have a clustered, or non-clustered index on field1 and field2 otherwise SQL will do table scan which is killing performance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: update_recordset hangs/ doesn't finish execution

container test = connull();

mytable.skipDatabaseLog(true);
mytable.skipDataMethods(true);

mytable.skip...

update_recordSet mytable

setting

ImportStatus = _status,
HasError = NoYes::No,
InfologData = test

where mytable.field1 = _field1

&& mytable.field2 = _field2;

?

Was this reply helpful? Yes No