OHDSI Home | Forums | Wiki | Github

Achilles 1.6 can't operate in oracle

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.

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

What can I do for this error.

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")

@ 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 “#”.

t