1 Reply Latest reply: Jan 5, 2018 9:03 AM by Christopher Grossman RSS

    November 2017 - problem with sql common table expressions

    Christopher Grossman

      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.