We try to run catalogueExport() excluding two analyzes (110, 177) because they run very slowly, taking hours or even days.
However, when we set the analysisIds parameter to all analyses except 110 and 117, then we get the message
"java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns not allowed".
In the log we see that there is a lot of incorrect SQL syntax as empty strings are treated as "" and not " space ".
CREATE TABLE EHDENRESULTS.catalogue_analysis AS WITH cte_analyses AS (SELECT 0 as analysis_id, 'Source name' as analysis_name, '' as stratum_1_name, '' as stratum_2_name, '' as stratum_3_name, '' as stratum_4_name, 'NA' as stratum_5_name FROM DUAL) SELECT analysis_id, analysis_name, stratum_1_name, stratum_2_name, stratum_3_name, stratum_4_name, stratum_5_name FROM cte_analyses
We try to run catalogueExport() excluding two analyzes (110, 177) because they run very slowly, taking hours or even days. However, when we set the analysisIds parameter to all analyses except 110 and 117, then we get the message
"java.sql.SQLSyntaxErrorException: ORA-01723: zero-length columns not allowed".In the log we see that there is a lot of incorrect SQL syntax as empty strings are treated as "" and not " space ".
CREATE TABLE EHDENRESULTS.catalogue_analysis AS WITH cte_analyses AS (SELECT 0 as analysis_id, 'Source name' as analysis_name, '' as stratum_1_name, '' as stratum_2_name, '' as stratum_3_name, '' as stratum_4_name, 'NA' as stratum_5_name FROM DUAL) SELECT analysis_id, analysis_name, stratum_1_name, stratum_2_name, stratum_3_name, stratum_4_name, stratum_5_name FROM cte_analysesAny suggestions?