web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Invalid Object Name on...

Microsoft Dynamics AX (Archived)

Invalid Object Name on Tempdb table

(0) Share

Report

Report

Posted on by Leonardo

640

Hi everyone.

I have an error when try to print purchase orders. There is an error message that says "Invalid object name tempdb.dbo.t100454_443...".

It's like the AOS can't find a temporary table on tempdb.

Any ideas what could be causing this?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Tommy Skaue Moderator on at

Like (0)

Report

Restart the AOS and try again. Most likely the session against the TempDB is invalid.

Was this reply helpful? Yes No
Leonardo 640 on at

Like (0)

Report

Thank you very much for the answer.

We already try to restart the AOS and it works, but after a period of time, the error is showing again.

Was this reply helpful? Yes No
Tommy Skaue Moderator on at

Like (0)

Report

I have seen this myself, but very seldom.

There is another thread here:

community.dynamics.com/.../163271.aspx

Have a look at the "lifetime" section here:

msdn.microsoft.com/.../gg845661.aspx

Temporary tables in general:

msdn.microsoft.com/.../ms177399(v=sql.105).aspx

Hope it helps.

Was this reply helpful? Yes No
Leonardo 640 on at

Like (0)

Report

Thank you, i will check the links.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans