Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error.

(0) Share

Report

Posted on by Community Member

Hi all,

I get this error when opening most of the RDP based report, for example "LedgerTrialBalance" report.

“Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error”

From the book that i have it said the resolution of this problem is :

After you have changed the RDP class, compile it and then go to Visual Studio, then open the report and do a refresh on the dataset (which refers to the RDP), the new parameter will get added. Now redeploy the report and you should be ok.

So, first step is to change my RDP class, right. But i don't know what to change and how. The RDP class for this report is "LedgerTrialBalanceDP" and the contract class is "LedgerTrialBalanceContract". All i know is that the LedgerTrialBalanceContract is where you want to add new parameter in the report. Thanks.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

syed baber 11,633 on at

Like (0)

Report

RE: Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error.

Hi Anisa,

Please verify the following in Visual Studio:

From AOT -> Visual Studio Projects -> Dynamics AX Model Projects node, select LedgerTrialBalanceReport and right click open it in Visual Studio. In Visual Studio, expand the dataset LedgerTrialBalanceDS and expand the Parameters node under that. Verify, if there is a parameter name AX_RdpPreProcessedId and it is referring to a report parameter name AX_RdpPreProcessedId. If this is not the case, then there is something missing. Try to generate full CIL and see if it resolves the issue.

Please verify and let me know what you find.

Thanks,

Baber.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error.

Hi Baber,

Yes, it's there. Ok, i will try to generate full CIL, i'll verify again if it works.

Thank you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error.

Dear Baber,

After i generate full CIL, i right clicked the report to open it again in Visual Studio and it showing another error message :

Error 1 An exception occurred in the query metadata execution. The exception is Map object not initialized.

Stack trace

(S)\Classes\SrsReportProviderQueryBuilder\addTempDBCursorToQueryRun - line 18
(S)\Classes\SrsReportProviderQueryBuilder\getQueryRun - line 22
(S)\Jobs\
. LedgerTrialBalance.Detail [Preview] 0 0

Also the header of the report is appearing, but below it said no data available.

Was this reply helpful? Yes No
venkatesh vadlamani 3,180 on at

Like (0)

Report

RE: Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error.

Is this Customized or standard Trial Balance report? Which version of AX?

Was this reply helpful? Yes No
Suggested answer

venkatesh vadlamani 3,180 on at

Like (0)

Report

RE: Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error.

Seems like you are in R2 Cu7 + versions,

This is pre-processed report, Ideally you cannot execute on visual studio. try it in Ax it should be Fine.

Pre-Processing will have DP executed with user session and the pre-processed tempDB tables physical name is saved in SrsReportPreProcessedDetails as a record and this record id is passed to set the cursor on the queryRun Objects which returns the data set to report.

All this is by-passed in visual studio call and you try to call the query run object without having a physical TempDB table's name and hence the error.

Regards

Venkatesh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error.

Dear Venkatesh,

I'm using AX 2012 R3 with CU9. You are right when i execute it from AOS, it's working just fine (for every report). But i need the report to appear in Sharepoint, and from both Sharepoint mode and native mode showing the same error : “Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error” in their reporting sites. So, any idea what should i do next? Oh, yeah it's not customized, it's the default report.

Was this reply helpful? Yes No
Verified answer

venkatesh vadlamani 3,180 on at

Like (0)

Report

RE: Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error.

These reports cannot be Exposed on share point directly.Since these need Controller instance to trigger the pre-processing ,these cannot be called from Ep or sharepoint.

You can duplicate the same report use SrsReportDataProviderBase instead of using the SRSReportDataProviderPreProcessTempDB in you Dp class inheritence and then expose the new report using EP or Sharepoint.

Hope this is clear

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error.

Sorry for late reply Venkatesh, i've been trying to solve this problem also i already had a session with microsoft.

Been trying to duplicate same report and use SrsReportDataProviderBase like you've said but still no progress.

From microsoft team side they also said what you said earlier, that there's no mechanism for these report to directly processed from within browser. So, now i will take another way around to make a custom report with query based report. Thanks all.

Was this reply helpful? Yes No
venkatesh vadlamani 3,180 on at

Like (0)

Report

RE: Pre-Processed RecId parameter not found. Cannot process report. Indicates a development error.

Hi Anisa,

It is straight forward process wise. But complication is with having this report done as this uses staging tables which are processed by a batch job to update the dimension balances (DimensionFocusBalance etc) and the data is pulled from these tables using TempDB tables for performance advantages.

You could follow the below steps to create a new DP class that extends SrsReportDataProviderBase

1) Duplicate the DP class and change the inheritence

2) Duplicate the tempTables and set the duplicate's property to In-Memory

3) At the end in the process report or the method where the processing is done do an insertRecordSet from Old temp tables to the new duplicates one and return this for report dataset

Create a new report which uses a data-set pointing to this new Dp class and check, please note that this new report will time out based on the setting on QueryService binding in the configuration file being used

Regards

Venaktesh

Was this reply helpful? Yes No