hello,
I am deploying a script which uses InlineQuerier Transformer which executes SQL queries against xlsx files "coming" from another system.
Everything works ok when FME Server is installed on Windows env, also works ok in FME Desktop on my Windows laptop, but when I deploy the script (and execute it) on FME Sever (from Linux environment) I receive following errors:
2022-3-30 15:51:09 | Remove_tasks_already_assigned (InlineQueryFactory): Error preparing database query: near ",": syntax error Unable to execute statement2532022-3-30 15:51:09 | Remove_tasks_already_assigned (InlineQueryFactory): Database was unable to prepare query 'SELECT2542022-3-30 15:51:09 | *2552022-3-30 15:51:09 | FROM2562022-3-30 15:51:09 | "Failed"2572022-3-30 15:51:09 | WHERE2582022-3-30 15:51:09 | ("CALL__T","ACTION_NO","CREW","EVENT__T") not in (select "CALL__T","ACTION_NO","CREW","EVENT__T" from "Passed")'.2592022-3-30 15:51:09 | Remove_tasks_already_assigned (InlineQueryFactory): A fatal error has occurred. Check the logfile above for details2602022-3-30 15:51:09 | A fatal error has occurred. Check the logfile above for details2612022-3-30 15:51:09 | Match_tasks_and_teams (InlineQueryFactory): A fatal error has occurred. Check the logfile above for details2622022-3-30 15:51:09 | Match_tasks_and_teams (InlineQueryFactory): A fatal error has occurred. Check the logfile above for details
Any ideas?
Cheers,
Nicu