Yesterday at one of our company client was facing this issue, on every transaction or even on validating the Journal post error popup as
Invalid object name “tempd.dbo.t4887_”.
“Sql statement, select t1.recid from tempdb.”DBO”.t4887_”
I feel that this error is due tempdb space fill in sql server or temp table created in SQL already exists. It did not let delete or create temp tables inside SQL server. I solve this issue with following work around.
- Stop AOS.
- Stop, analysis services, and SSRS services
- Stop Sql server and sql server agent ( If running)
- Start SQL server.
- Start analysis services and ssrs services.
- Start AOS.
Last one week this error is not appear on client.
I think there will be planned down time on AX production environment, where AOS and SQL services must be restarted after weekly or monthly basis.