Temp Table Error

Hi,

I got problems with temporary tables, these errors occur when I am generating a report.

  1. Report1

Cannot create a record in TempTableName1.
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name ‘TEMPTABLENAME1’.
SQL statement: INSERT INTO TEMPTABLENAME1 (Field1, Field2 Field3, Field4) VALUES (?,?,?,?)
session 22 (Admin)

  1. Report2

Cannot edit a record in TempTable2 (TempTable2).
The record has never been selected

Report1 error occur after importing the upgrade or enhance version.

Report2, as I check on my code there were no update query, I only used select statement.

Any idea guys, thanks in advance.

Re 1: Make sure that everything compiles and that you’ve synchronized database.
Re 2: Looks like a bug in code. Use the debugger to find where exactly it happens.

Hi Martin;

Each report works fine in the development environment. But when promoted to production environment, those error occur.

You may not tested well.
There may be some reasons why it behaves odd with development environment, such as the business data may be different…etc.

Re 1: Set table to InMemory
Re 2: Restart report server, clear caches

Thanks Martin for the time