Achilles 1.6 can't operate in oracle

11112 · October 28, 2019, 2:51am

Hi I’m Park!
Now we use “oracle” DBMS and it only support ‘single thread’ because of License.

But when I try run a Achilles 1.6 on “numThreads=1” settings, It didint work.
I think it’s occurred “scratchDatabaseSchema” variable in Achilles Libary.
I already set the value to “scratchDatabaseSchema= OUR_RESULT_SCHEMA”, but it also didint works.

For this case how can I solve this Erorr.

11112 · October 28, 2019, 5:30am

I think it is occurred from this code in Achilles Package code.

What can I do for this error.

Ajit_Londhe · October 28, 2019, 9:50pm

Hi @11112 – we have some forthcoming fixes for Achilles to resolve this. Essentially, we aren’t properly using the oracleTempSchema parameter in Achilles currently.

In the meantime, you can try the oraclefixes branch:

devtools::install_github("OHDSI/Achilles, ref = "oraclefixes")

11112 · October 29, 2019, 2:55am

@ Ajit_Londhe thank you for your help.
I try to reinstall “Achilles-oraclefixes branch” and then run a “Achilles”.
But it occurred same error 「 ORA-00911: invalid character」 because of “#”.