AX 2009 R2 - Error Code: 50109 in Sales Order Load

Question Status

Suggested Answer
Prabath Ranasinghe asked a question on 16 Feb 2014 10:16 PM

Following error is popping up at the Sales order screen loading time.

We have already,

1. cleared index files and restarted

2. Cleared Cache

But the issue is still not solved.

 

 

 

Can someone help to resolve this issue?

Thanks

prabath

 

Reply
Suggested Answer
Denis Macchinetti responded on 17 Feb 2014 12:30 AM

Hi Prabath

What's do you mean for "cleared index files?"

If not yet done, from the folder C:\Users\USERNAME\AppData\Local\.. delete all *.auc and *.kti files

Hope this help you

Regards

Reply
Prabath Ranasinghe responded on 18 Feb 2014 10:52 PM

Hi Denis,

Thanks for the reply

Index files are the *.*I files created at the AOS start time.

This issue is not an user specific one. Every one gets the same error. Anyway We tried your solution for one user. Its not working.

According to our investigation this error is because AX is failed to read last record of sales order.

Reply
Denis Macchinetti responded on 19 Feb 2014 4:39 AM

Hi Prabath

The Sales Order form is customized?

You have added new datasources?

Please, can you give me more info about this form?

Regards

Reply
Suggested Answer
Nitesh Ranjan responded on 1 Mar 2014 6:19 AM

it seems you have sales table or sales Line Table is setup as entire table cache

as SalesTable and SalesLine Table is high transaction table so we should not have such setup

please verify and modify the setup accordingly and update the output accordingly.

Reply
Suggested Answer
Denis Macchinetti responded on 17 Feb 2014 12:30 AM

Hi Prabath

What's do you mean for "cleared index files?"

If not yet done, from the folder C:\Users\USERNAME\AppData\Local\.. delete all *.auc and *.kti files

Hope this help you

Regards

Reply
Suggested Answer
Nitesh Ranjan responded on 1 Mar 2014 6:19 AM

it seems you have sales table or sales Line Table is setup as entire table cache

as SalesTable and SalesLine Table is high transaction table so we should not have such setup

please verify and modify the setup accordingly and update the output accordingly.

Reply