OHDSI Home | Forums | Wiki | Github

CohortDiagnostics package executeDiagnostics error

Developers
#1

Hi team,
I got an error when run executeDiagnostics function using Cohort Diagnostics. Can someone help me out? Thanks

exportFolder ← “export”
executeDiagnostics(cohortDefinitionSet,
connectionDetails = connectionDetails,
cohortTable = cohortTable,
cohortDatabaseSchema = cohortDatabaseSchema,
cdmDatabaseSchema = cdmDatabaseSchema,
exportFolder = exportFolder,
databaseId = “temp”,
minCellCount = 5
)

Error in rJava::.jcall(batchedInsert, “Z”, “executeBatch”) :
java.sql.SQLException: [Simba]JDBC Cannot use commit while Connection is in auto-commit mode.

#2

I’m assuming you’re using DataBricks. We’ve also observed this behavior (their driver won’t allow us to change auto-commit mode), and have reached out to DataBricks for support. We will need to wait for their response.

#3

Thank you so much for your information. Our CDM tables do live in Databricks. Fingers crossed.

t