search

ohdsi-studies / PioneerWatchfulWaiting

This study is part of the joint PIONEER - EHDEN - OHDSI studyathon in March 2021, and aims to advance understanding of clinical management and outcomes of watchful waiting in prostate cancer.
Apache License 2.0
7 stars 18 forks source link

Error in runStudy #66

Closed rfherrerac closed 3 years ago

rfherrerac commented 3 years ago

Backtrace:

  1. PioneerWatchfulWaiting::runStudy(...)
  2. PioneerWatchfulWaiting:::createBulkCharacteristics(...)
  3. DatabaseConnector::executeSql(connection = connection, sql = sql)
  4. base::tryCatch(...)
  5. base:::tryCatchList(expr, classes, parentenv, handlers)
  6. base:::tryCatchOne(expr, names, parentenv, handlers[[1L]])
  7. value[3L]
  8. DatabaseConnector:::.createErrorReport(...) Run rlang::last_trace() to see the full context. errorReportSql.txt
rfherrerac commented 3 years ago

<error/rlang_error> Error executing SQL: java.sql.SQLException: Amazon Invalid operation: syntax error at or near "#" Position: 22; An error report has been created at /home/ronald/errorReportSql.txt Backtrace:

  1. PioneerWatchfulWaiting::runStudy(...)
  2. PioneerWatchfulWaiting:::createBulkCharacteristics(...)
  3. DatabaseConnector::executeSql(connection = connection, sql = sql)
  4. base::tryCatch(...)
  5. base:::tryCatchList(expr, classes, parentenv, handlers)
  6. base:::tryCatchOne(expr, names, parentenv, handlers[[1L]])
  7. value[3L]
  8. DatabaseConnector:::.createErrorReport(...) Run rlang::last_trace() to see the full context.

    rlang::last_trace() <error/rlang_error> Error executing SQL: java.sql.SQLException: Amazon Invalid operation: syntax error at or near "#" Position: 22; An error report has been created at /home/ronald/errorReportSql.txt Backtrace: █

  9. └─PioneerWatchfulWaiting::runStudy(...)
  10. └─PioneerWatchfulWaiting:::createBulkCharacteristics(...)
  11. └─DatabaseConnector::executeSql(connection = connection, sql = sql)
  12. └─base::tryCatch(...)
  13. └─base:::tryCatchList(expr, classes, parentenv, handlers)
  14. └─base:::tryCatchOne(expr, names, parentenv, handlers[[1L]])
  15. └─value[3L]
  16. └─DatabaseConnector:::.createErrorReport(...)
rfherrerac commented 3 years ago

Maybe it is in BulkFeature SQL file, line 172. There is an extra space.

bdemeulder commented 3 years ago

Corrected the BulkFeatureExtraction.sql file.