Error ‘Invalid object name #ax_tmp_’


You may see similar error while posting ledger journal:


Posting - Journal
Journal: 000004_061
Voucher: 8004_062
Cannot select a record in ().
The SQL database has issued an error.
The journal is not posted and the update is canceled.
SQL error description: [Microsoft][SQL Native Client][SQL Server]Invalid object name '#ax_tmp_dmo3_52_0'.


This error is caused by collecting Query plans while doing SQL tracing. To avoid this error you need to disable Query plan collection in Tools | Options on SQL tab.


image


Martin F

Comments (0)

Skip to main content