Invalid object name '#s_tmpach_1818' error when I ran Achilles in R studio

Implementers
1

Hi all,

I’m trying to make atlas work and stuck on the following issue when I try to run Achilles in R studio. I hope you guys can point me to the right direction.

Executing SQL took 0.073 secs
[Main Analysis] [COMPLETE] 2201 (0.081000 secs)
Merging scratch Achilles tables
|======================================================== | 50%Merging scratch Achilles tables [ERROR] (Error: Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name ‘#s_tmpach_1818’.
An error report has been created at C:/Users/mb/Documents/errorReportSql.txt
)
Done. Achilles results can now be found in schema OMAP.results
Connecting using SQL Server driver using Windows integrated security
| | 0%Error: Error executing SQL:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object “OMAP.results.achilles_results” because it does not exist or you do not have permissions.
An error report has been created at C:/Users/mb/Documents/errorReportSql.txt

Below is the error message detail from errorReportSql.txt.

DBMS:

sql server

Error:

com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object “OMAP.results.achilles_results” because it does not exist or you do not have permissions.

SQL:

create index idx_ar_aid on OMAP.results.achilles_results (analysis_id)

Thanks,
MB

2

Looks like the database name varies between OMAP and OMOP in the error messages. Is there a typo in your script?

3

Thanks Frank, That’s a typo. Both are OMAP. I corrected it.