Java error from getDbCovariateData #146
Comments
|
Not sure if this is helpful, but in general I highly recommend not using OpenJDK, but Oracle Java instead. |
|
|
Could you run ParallelLogger::addDefaultErrorReportLogger()Then rerun your code to recreate the error, and share the content of the error report? |
|
Thanks for helping out Martijn! I run it, but no error file is created. And if I create the file empty before I run, still no content. |
|
Wait, of course. I removed a try-catch, and then it was indeed created :) Thread: Main Stack trace: R version: Platform: Attached base packages:
Other attached packages:
Thread: Main Stack trace: R version: Platform: Attached base packages:
Other attached packages:
Thread: Main Stack trace: R version: Platform: Attached base packages:
Other attached packages:
|
|
Note/Explanation: In the execution above we used a copy of the original function getDbCohortMethodData() called custom_getDbCohortMethodData(), that we use for debugging. However same problem do arise if I call the built in function directly: Thread: Main Stack trace: R version: Platform: Attached base packages:
Other attached packages:
|
|
Sorry, I'm still at a loss what is going wrong. I've simplified the problem to just the Java call that is throwing the error. Could you try running this? (It doesn't throw an error for me) covariateSettings <- FeatureExtraction::createCovariateSettings(useConditionGroupEraLongTerm = TRUE,
excludedCovariateConceptIds = c(31317, 1139699))
settings <- FeatureExtraction:::.toJson(covariateSettings)
cohortTable <- "cohort_table"
cohortId <- -1
cdmDatabaseSchema <- "main"
rowIdField <- "SUBJECT_ID"
aggregated <- FALSE
rJava::J("org.ohdsi.featureExtraction.FeatureExtraction")$init(system.file("", package = "FeatureExtraction"))
json <- rJava::J("org.ohdsi.featureExtraction.FeatureExtraction")$createSql(settings, aggregated, cohortTable, rowIdField, rJava::.jarray(as.character(cohortId)), cdmDatabaseSchema) |
|
Thanks Martijn! I've now taken our own code, and made the simpliest version I could come up with, that still emulates our call to getDbCohortMethodData(), and that does also run. I will work my way up to the code we have today, bit by bit, and see exactly what eventually makes the call fail. |
|
This is of course what we should have done to start with. We accidentally used strings instead of integers in the parameter excludedCovariateConceptIds in the function createCovariateSettings. This caused the error. Thank you for you help and patience, and sorry for creating confusion and taking your time. |
|
Great to hear the problem is solved. Some more informative error messages would have helped ;-) @anthonysena: Perhaps some input checks could be added? Perhaps in the |
Hello!
After many months of work without this bug, we've recently come across a bug on two separate computers that seem to originate from java.
"Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, :
java.lang.ClassCastException: class java.lang.String cannot be cast to class java.lang.Integer (java.lang.String and java.lang.Integer are in module java.base of loader 'bootstrap')"
We feed a cohort table to getDbCohortMethodData, which calls getDbCovariateData, which in turn calls getDbDefaultCovariateData. Running the code there line-by-line points toward the following call:
rJava::J("org.ohdsi.featureExtraction.FeatureExtraction")$createSql(settings, aggregated, cohortTable, rowIdField, java_array, cdmDatabaseSchema)We're running sql server, this is the java-version information:
The input arguments to this rJava::J-function are not very helpful as reproducible example, since a restart of R and feeding the same argument gives you a different error message ("Error in jclassName(class, class.loader = class.loader) : java.lang.ClassNotFoundException"). But here are our input arguments:
settings = '{\"temporal\":false,\"DemographicsGender\":true,\"DemographicsAge\":true,\"ConditionOccurrenceLongTerm\":true,\"ConditionGroupEraLongTerm\":true,\"DrugGroupEraLongTerm\":true,\"longTermStartDays\":-180,\"mediumTermStartDays\":-180,\"shortTermStartDays\":-90,\"endDays\":0,\"includedCovariateConceptIds\":[],\"addDescendantsToInclude\":true,\"excludedCovariateConceptIds\":[\"31317\",\"1139699\"],\"addDescendantsToExclude\":true,\"includedCovariateIds\":[]}' aggregated = FALSE cohortTable = "#cohort_person" rowIdField = "subject_id" java_array = rJava::.jarray(as.character(-1)) cdmDatabaseSchema = "OmopCdm.synpuf5pct_20180710"If we instead feed a drug_era and condition_era instead of cohort-tables to getDbCohortMethodData, things are working again.
I've also tried to reproduce the bug starting from Eunomia, but the bug does not appear there.
`connection <- DatabaseConnector::connect(Eunomia::getEunomiaConnectionDetails())
DatabaseConnector::executeSql(connection, "DROP TABLE IF EXISTS cohort_table")
DatabaseConnector::executeSql(connection, "CREATE TABLE cohort_table (SUBJECT_ID INT, COHORT_DEFINITION_ID INT, COHORT_START_DATE DATETIME, COHORT_END_DATE DATETIME)")
DatabaseConnector::executeSql(connection, "INSERT INTO cohort_table(SUBJECT_ID, COHORT_DEFINITION_ID, COHORT_START_DATE, COHORT_END_DATE) VALUES (1, 1, '2000-01-01 12:00:00', '2000-01-02 12:00:00')")
DatabaseConnector::querySql(connection, "SELECT * FROM cohort_table")
covSettings <- FeatureExtraction::createCovariateSettings(useConditionGroupEraLongTerm = TRUE, excludedCovariateConceptIds = c(31317, 1139699))
covariateData <- FeatureExtraction::getDbCovariateData(connection = connection,
cdmDatabaseSchema = "main",
cdmVersion = 5,
cohortTable = "cohort_table",
cohortTableIsTemp = FALSE,
rowIdField = "SUBJECT_ID",
covariateSettings = covSettings)
`
Any ideas or input on how to solve this would be highly appreciated. Have there been any recent updates to FeatureExtraction/Java-related matters the last week?
The text was updated successfully, but these errors were encountered: