The extractor to export measurables/relationships and involvements is failing as the number of left joins is increasing and the time taken to run the extract exceeds the 30 sec limit imposed by our apache httpd server.
Solution is probably to optimize the output as there are a lot of duplicative columns. Perhaps look to use stuff (mssql) or vendor alternatives to inline lists.
The extractor to export measurables/relationships and involvements is failing as the number of left joins is increasing and the time taken to run the extract exceeds the 30 sec limit imposed by our apache httpd server.
Solution is probably to optimize the output as there are a lot of duplicative columns. Perhaps look to use
stuff(mssql) or vendor alternatives to inline lists.