135
Is anyone familiar with this issue? When I tried to delete a Sales Order it freezes AX, i've tried debugging the issue and it just goes through the normal standard codes, but I noticed that it just loops through the same standard methods.
Hi Nikolaos,
As per checking the table DocuRef standard method existAnothervalue is causing the issue, it is most likely related to an indexing issue.
Hello everyone,
I have finally found the cause of the issue, and it is standard code. It seems that the existAnothervalue method in DocuRef is causing the issue, because there are a lot of notes attached to the sales order, this method is slowing down the whole deletion process, because each note takes about 5-7 minutes each to delete, which causes the freezing I have stated. To resolve this issue temporarily, I added a firstOnly to the query in existAnothervalue method to speed things up.
Thanks for all your help guys.
Hi Nikolaos, as per checking it seems that the issue is being caused by the attachments, as there are a lot of attachments on the SO that i have just checked. Initially i thought it was looping but after further checking it seems that there are just a very substantial amount of attachments on the SO. Will check if this is truly the cause of this issue.
DocuRef is used to add attachments (text or files) to basically any record in AX. If the parent record (such as order) is deleted, also the attachments related to it are deleted. Still I think there most likely is some customization that explains your issue. Have you checked if you have some customization in DocuRef? Are there any details that you didn't yet share with us? Such as the methods that you see when "it just loops through the same standard methods.".
Hello everyone,
Good day, I have tried removing all customizations but to no avail, it is still freezing. but after checking the freezing seems to be occurring at the DocuRef\Methods\Delete method. Can anyone explain to me the use of the DocuRef table or link me a website with information pertaining to the table?
Good day Nikolaos,
Thank you for your input.
I keep freezing in the delete method in the SalesTable methods. Also if I try via job to use delete() or update(), it also freezes AX, only on that specific SO.
Good day,
An update on this.
I've tried deleting the record from the SalesTable via X++ Job in our test environment, but even through the backend it still freezes only on that Specific SO. Also i've tried updating any value on that specific SO, it will also freeze AX.
Hi all,
I have disabled all customizations with association with the delete process, and it is still freezing, will try to check the standard delete method again.
Thank you.
#1
André Arnaud de Cal...
291,820
Super User 2024 Season 2
#2
Martin Dráb
230,514
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
