OHDSI Home | Forums | Wiki | Github

CohortDiagnostics package executeDiagnostics error

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

exportFolder ← “export”
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.

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.

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