Hello teams,
I have a PowerShell script that loops through an array of CountryNames and generates a SQL file based on the Where clause of the CountryName.
I use latest production SQLcl version to execute the SQL file.
Sometimes it processes the First iteration only then hangs/stops and sometimes it stops in the 4th iteration.
When I the script run manually, it normally goes fine.
Why it hangs after a while? What could be happening? how to troubleshoot it and find errors? (I have a try/catch block and no exceptions are catched)
Please let me know if you need more details.