Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

cgrossman
New Contributor

November 2017 - problem with sql common table expressions

We are currently in the process of upgrading to the November 2017 version. I was doing some regression testing for a release after the upgrade and noticed that my applications where I had to do a common table expression in the sql load script are no longer working. There is no error code, it just runs and keeps running ( ran all night).

I've tested the query by itself a few times and it runs fine (runs in less than 15 seconds). I walked through the load script testing sections out. Any help would be appreciated.

1 Reply
cgrossman
New Contributor

Re: November 2017 - problem with sql common table expressions

I fixed the issue. There were some comments in the sql script that was causing the issue. I was troubleshooting sections and removing comments as I went and it ran fine after that.

Community Browser