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