Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
YoAlareed
Contributor II
Contributor II

Error: "There is already an object named '#temp_SLA_Start'" in Qlik Cloud

 

Hi,

I’m currently working on creating an SLA script for multiple clients in our company. In the editor, I have separate sections for each client, and previously in Qlik Sense, all sections used the same script structure and SQL temporary table names (e.g., #temp_SLA_Start) without any issues.

However, now that we’re using Qlik Cloud, I’m encountering the following error:

Internal error. (Connector error: Status(StatusCode="InvalidArgument", Detail="ERROR [S0001] There is already an object named '#temp_SLA_Start' in the database."))

 

It seems like Qlik Cloud handles SQL temporary tables differently, and it no longer allows multiple sections to use the same temporary table name.

is there a way to drop SQL temp tables as i have tried using drop table #temp_SLA_Start; and its not working

Labels (1)
  • Cloud

0 Replies