TempDB table field cannot be empty for RecId

(0) Share

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)