Microsoft Dynamics AX (Archived)

SSRS report, unable to run due to temp table

(0) Share

Report

Posted on by AnkurBh

107

I have moved report form one server to another and the report deployed successfully.

But when i run the report the following error comes.

Cannot create a record in tmpTable

The sql database has issued an error.

Sql error description : invalid object name tmpTable.

Then there is sql query.

When i make the table as Regular report runs( obviously with repeated data as table is not flushed)

I synchronized the table. Redployed the report. But it dosnt work when table type is Temp/inMemory

Plus i dont have visual studio in the server where report is moved.

Please help

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Sathish Sivakumar 3,732 on at

Like (0)

Report

Can you share your code what you have written and share the screenshot of the Temp table properties?

Was this reply helpful? Yes No
Fx 425 on at

Like (0)

Report

Hi AnkurBh,

Is your report based on a Dynamics AX Query or a DataProvider class?

If you're using a DataProvider class, can you tell us which class are you extending ?

Regards

FX

Was this reply helpful? Yes No
AnkurBh 107 on at

Like (0)

Report

Do you want the whole code of RDP class?

Report is running fine in the server on which i created the report

Was this reply helpful? Yes No
AnkurBh 107 on at

Like (0)

Report

I am using RDP based class. And passing querry attribute through srsqueryattribute.

The report is working fine in one instance.

Was this reply helpful? Yes No
Suggested answer

Iulian Cordobin 8,201 on at

Like (0)

Report

The table should be TempDB, not InMemory. Change the Table type property.

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

Also, I assume you have the proper security rights for that table (to write to).

Was this reply helpful? Yes No
AnkurBh 107 on at

Like (0)

Report

I am working as System Admin user so i guess i have security rights.

And i have tried with both TempDB and inMemory properties

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Try to stop AOS iF It works I tell you why.

Was this reply helpful? Yes No
Rizwan Ahmed 200 on at

Like (0)

Report

Have you given "Delete" rights to the temp table? Secondly are getting any error? or Just blank report?

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report

could be simular issue like

community.dynamics.com/.../195184

Was this reply helpful? Yes No