Achilles script does not create all the tables in results schema

Implementers
1

Dear All,

I am running Achilles scripts by following the documents list here, it runs successfully, but in my results schema, only the following 5 tables are created:

  • ACHILLES_analysis
  • achilles_results
  • achilles_results_dist
  • cohort
  • cohort_definition

There should be a lot more tables created. @Ajit_Londhe or @Chris_Knoll , could you please kindly let me know what could be the possible reason?

Thank you in advance!

2

Did you run the cmds at:

3

yes, pretty much the same commands.

4

Did you executed a link like:

https://yourserver/WebAPI/ddl/results?dialect=yourDBFlavor&schema=results&vocabSchema=yourVocabSchema&tempSchema=your_atlas_temp&initConceptHierarchy=true

?

5

No, I did NOT. I am not sure what that is for?

6
7

Jose, I did a quick look at your above reply, could not get my head around it yet… could you please explain a little bit more? so that would give back the missing tables? thanks!

8

That link creates other needed tables. I made it work an now I am at the Achilles execution part. As far as I know these are the steps we need to complete to create all the “extra” tables.

9

okay. great. let me try that as well.

10

So @jcabrerazuniga , when I ran the following,

https://yourserver/WebAPI/ddl/results?dialect=yourDBFlavor&schema=results&vocabSchema=yourVocabSchema&tempSchema=your_atlas_temp&initConceptHierarchy=true

I got a full long list of SQL commands. Should I run this long list of SQL commands on my CDM server side to create all the tables? Is what correct?

11

nope…
it means they were executed!

12

Okay. I am now even more confused. What I have now is that after I ran the Achilles package, I only see 5 tables, and I was wondering why I am not seeing the other tables.

Now, if I run the following,

https://yourserver/WebAPI/ddl/results?dialect=yourDBFlavor&schema=results&vocabSchema=yourVocabSchema&tempSchema=your_atlas_temp&initConceptHierarchy=true

I got SQL statements, and we should not be running them at all… how does this generated SQL help then? very confused.

13

those tables should be somewhere… After I run the link the error related to the link’s tables disappeared. But, you need to have a ready etl database.

14

@liyang – are you good now, or still having issues?

15

@Ajit_Londhe I am good now, thank you!