You can translate the question and the replies:

Invalid Object error

I have created Denodo base on SQL stored procedure which is using SQL Global global temporary table (##), i am getting below error, when two users are trying to execute same denodo view Error: Invalid object name '##Org_Data' Do i need to setup some configuration or Denodo do not support SQL Global global temporary table?. Thanks in advance
user
16-05-2023 08:01:40 -0400
code

1 Answer

Greetings, According to Microsoft’s description of [global temporary tables](https://learn.microsoft.com/en-us/sql/relational-databases/tables/tables?view=sql-server-ver16#temporary-tables), “… they are deleted when all users referencing the table disconnect from the instance of SQL Server”. Therefore, I would recommend using an SQL server view instead of a global temporary table in order to safely import the stored procedure when creating the desired base view. Other useful checks would be to : 1. Test the connection to the underlying MSSQL server data source. 2. Verify if subject table/view exists in the underlaying data source and whether users using the base view have Execute privileges. 3. Verify if subject table/view can be accessed using other platforms (e.g., DBVisualiser). For further guidelines, please check the [Creating views using SQL server procedures and functions](https://community.denodo.com/kb/en/view/document/Creating views on SQL Server Functions and Stored Procedures) KB article. If the issue persists and you have a valid support account, create a support case in Denodo Support Site to further assist in resolving this issue. Hope this helps!
Denodo Team
17-05-2023 03:15:00 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here