Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
cgrossman
Contributor
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
Contributor
Contributor
Author

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.