topic Re: November 2017 - problem with sql common table expressions in Management & Governance https://community.qlik.com/t5/Management-Governance/November-2017-problem-with-sql-common-table-expressions/m-p/1458998#M11706 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Fri, 05 Jan 2018 14:03:17 GMT cgrossman 2018-01-05T14:03:17Z November 2017 - problem with sql common table expressions https://community.qlik.com/t5/Management-Governance/November-2017-problem-with-sql-common-table-expressions/m-p/1458997#M11705 <HTML><HEAD></HEAD><BODY><P>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). </P><P></P><P>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.</P></BODY></HTML> Thu, 04 Jan 2018 18:17:07 GMT https://community.qlik.com/t5/Management-Governance/November-2017-problem-with-sql-common-table-expressions/m-p/1458997#M11705 cgrossman 2018-01-04T18:17:07Z Re: November 2017 - problem with sql common table expressions https://community.qlik.com/t5/Management-Governance/November-2017-problem-with-sql-common-table-expressions/m-p/1458998#M11706 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Fri, 05 Jan 2018 14:03:17 GMT https://community.qlik.com/t5/Management-Governance/November-2017-problem-with-sql-common-table-expressions/m-p/1458998#M11706 cgrossman 2018-01-05T14:03:17Z