web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) TempDB table field can...

Microsoft Dynamics AX (Archived)

TempDB table field cannot be empty for RecId

(0) Share

Report

Report

Posted on by Community Member

Dear All,

when I run Dimension statement, Ledger transaction list, Detailed trial balance report system give below error message and other reports like Balance list running perfectly. "tempdb table field cannot be empty for recld" I am running Dynamics AX 2012 R3 CU12. I already do for solving but didn't success ;

1. in SSRS server open file: C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\rssrvpolicy.config

find "Name=”Report_Expressions_Default_Permissions”"

change permissions to FullTrust (instead of PermissionSetName=”Execution”)

2. Reconfigure Reporting services manager, restarted SSRS & AOS

3. Delete user temp AX, still can't generate

4. But if i try with other user account that report can be Generated

Thanks,

Andri

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 26

#2

#3

André Arnaud de Cal... 4 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans