web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / TempDB table field can...
Microsoft Dynamics AX (Archived)

TempDB table field cannot be empty for RecId 5637149827.

(0) ShareShare
ReportReport
Posted on by atef@83 805

Hi all

TempDB table field cannot be empty for RecId 5637149827. 

i am  getting  this  error  when  trying to  print summary trial balnce 

Plz help me to solve 

Regards

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,243 Super User 2025 Season 2 on at
    RE: TempDB table field cannot be empty for RecId 5637149827.

    Hi Atef,

    Make sure the AX configuration on the reporting server is pointing to the correct environment.

  • atef@83 Profile Picture
    atef@83 805 on at
    RE: TempDB table field cannot be empty for RecId 5637149827.

    still error i checked i already pointing to the correct environment

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,243 Super User 2025 Season 2 on at
    RE: TempDB table field cannot be empty for RecId 5637149827.

    Hi atef,

    Can you find some related warnings or errors in the Windows event viewer? Is the correct report server setup in your AX environment?

  • atef@83 Profile Picture
    atef@83 805 on at
    RE: TempDB table field cannot be empty for RecId 5637149827.

    hi andre

    there is no related warnings or errors in the windows event viewer

    for your information ha have 2 database and 2 AOS the first one is working perfect but when i try to run the second database with the second AOS it show this error not for all reports but specific report like print journal and trial balance ( summary & detailed )

  • atef@83 Profile Picture
    atef@83 805 on at
    RE: TempDB table field cannot be empty for RecId 5637149827.

    Hi Andrea

    i found one error related to this issue

    An error has occurred during report processing. (rsProcessingAborted)

    An error has occurred during report processing. (rsProcessingAborted)

    Microsoft.Reporting.WinForms.ReportServerException

      at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

      at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

      at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)

      at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()

      at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()

      at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

    Query execution failed for dataset 'LedgerJournalDS'. (rsErrorExecutingCommand)

    Microsoft.Reporting.WinForms.ReportServerException

    An exception occurred in the query metadata execution. The exception is TempDB table field cannot be empty for RecId 5637152081..

    Microsoft.Reporting.WinForms.ReportServerException

    TempDB table field cannot be empty for RecId 5637152081.

    Microsoft.Reporting.WinForms.ReportServerException

    TempDB table field cannot be empty for RecId 5637152081.

    Microsoft.Reporting.WinForms.ReportServerException

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,243 Super User 2025 Season 2 on at
    RE: TempDB table field cannot be empty for RecId 5637149827.

    Hi Atef,

    When you have multiple instances running on the same server, review the next page where it is described how to do this setup. technet.microsoft.com/.../hh389760.aspx

    When the setup is not correct it will try to connect to the "active" AOS which is the wrong one. So in fact I still think it is trying to point to the wrong AOS.

  • atef@83 Profile Picture
    atef@83 805 on at
    RE: TempDB table field cannot be empty for RecId 5637149827.

    thanks andre so much

  • Anks27 Profile Picture
    Anks27 1,085 on at
    RE: TempDB table field cannot be empty for RecId 5637149827.

    We are facing same issue and in event log it's same which you mentioned in your thread, we are using three instance on same server.

    Can you tell me how you solve this issue??

    Thanks,

    Ankit

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans