Today i got an error while opening SALES ORDER in AX 2009 as like below
"Cannot select a record in Sales orders (SalesTable). Sales order: , .The SQL database has issued an error."
I tried to execute select command on SALES TABLE, returns no errors.
And I tried in AOT tables, whether SALES TABLE exists or not But it is there in the AOT . I don't know how to resolve this error..
Can any one please suggest me.
Thanks & Regards,
"The SQL database has issued an error" is usually followed by the failing SQL command. Don't you see any in the infolog?Synchronizing the database might help, therefore it's worth trying.
DB sync should solve the issue. Please try that.