Skip to main content

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

Hi @nicolae.soare​, what version of FME Server are you running in your Linux environment? This was a known issue with FME 2021 that was resolved in FME 2022. Have you also tried running the workspace on FME Desktop on Linux?


Hello,

FME Server version is 2021.2.2

FME Server 2022 is still in beta version and I don't think customer will agree with beta version on production.

 

Regarding your last question, unfortunately I have access through browser (IP) to that FME Server and I deploy there the workspaces via my FME Desktop (windows).

 

So do you think a solution can be to change FME Server 2021 with 2022 ?

 

Thank you,

 

Nicu


Reply