Hi @Frank,
We are trying to setup our Microsoft SQL databases in our production servers.
When we run Achilles using production data we are getting the above error “query processor ran out of internal resources”. When adding the excludeAnalysisIds=c(2004) as a parameter to the Achilles execution, we don’t see the error in the production environment .
We tested Achilles on our test servers, using test data generated from unit testing scripts from Rabbit-In-A-Hat. When we ran Achilles on this test data we didn’t see the error.
Not sure if this is due to the volume of data within the production tables or more a server setup. I have attached a file which provides some details on the CPU, memory and cores used:
Results.xlsx (2.9 KB)
Thank you,
Solmaz