Thread: Main
Message:  java.sql.SQLException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request
POST https://bigquery.googleapis.com/bigquery/v2/projects/atals-01/jobs
{
  "code": 400,
  "errors": [
    {
      "domain": "global",
      "location": "q",
      "locationType": "parameter",
      "message": "Syntax error: Expected \"(\" but got end of script at [1:122]",
      "reason": "invalidQuery"
    }
  ],
  "message": "Syntax error: Expected \"(\" but got end of script at [1:122]",
  "status": "INVALID_ARGUMENT"
}
Level:  FATAL
Time:  2025-06-24 14:34:36

Stack trace:
17: (function (condition) 
{
    if (is(condition, "error")) {
        log("FATAL", conditionMessage(condition), echoToConsole = FA
16: stop(list("java.sql.SQLException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request\nP
15: .jcheck()
14: rJava::.jcall(batchedInsert, "Z", "executeBatch")
13: insertTable.default(connection = connection, databaseSchema = cohortDatabaseSchema, tableName = cohortInclusionTable, data =
12: DatabaseConnector::insertTable(connection = connection, databaseSchema = cohortDatabaseSchema, tableName = cohortInclusionTa
11: CohortGenerator::insertInclusionRuleNames(connection = connection, cohortDefinitionSet = subset, cohortDatabaseSchema = coho
10: eval(expr)
9: timeExecution(exportFolder, "getInclusionStatsCohortGenerator", parent = "getInclusionStats", expr = {
    CohortGenerator::i
8: getInclusionStats(connection = connection, exportFolder = exportFolder, databaseId = databaseId, cohortDefinitionSet = cohor
7: eval(expr)
6: timeExecution(exportFolder, "getInclusionStats", cohortIds, parent = "executeDiagnostics", expr = {
    getInclusionStats(con
5: cohortDiagnosticsExample.R#49: executeDiagnostics(cohortDefinitionSet, connectionDetails = connectionDetails, cohortTable = 
4: eval(ei, envir)
3: eval(ei, envir)
2: withVisible(eval(ei, envir))
1: source("~/projects/cohortDiagnosticsExample.R", echo = TRUE)

R version:
R version 4.4.2 (2024-10-31)

Platform:
x86_64-pc-linux-gnu

Attached base packages:
- stats
- graphics
- grDevices
- utils
- datasets
- methods
- base

Other attached packages:
- shiny (1.10.0)
- CohortGenerator (0.11.2)
- R6 (2.6.1)
- CohortDiagnostics (3.4.1)
- FeatureExtraction (3.10.0)
- Andromeda (1.0.0)
- dplyr (1.1.4)
- DatabaseConnector (6.4.0)


Thread: Main
Message:  java.sql.SQLException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request
POST https://bigquery.googleapis.com/bigquery/v2/projects/atals-01/jobs
{
  "code": 400,
  "errors": [
    {
      "domain": "global",
      "location": "q",
      "locationType": "parameter",
      "message": "Syntax error: Expected \"(\" but got end of script at [1:122]",
      "reason": "invalidQuery"
    }
  ],
  "message": "Syntax error: Expected \"(\" but got end of script at [1:122]",
  "status": "INVALID_ARGUMENT"
}
Level:  FATAL
Time:  2025-06-24 14:34:36

Stack trace:
17: (function (condition) 
{
    if (is(condition, "error")) {
        log("FATAL", conditionMessage(condition), echoToConsole = FA
16: stop(list("java.sql.SQLException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request\nP
15: .jcheck()
14: rJava::.jcall(batchedInsert, "Z", "executeBatch")
13: insertTable.default(connection = connection, databaseSchema = cohortDatabaseSchema, tableName = cohortInclusionTable, data =
12: DatabaseConnector::insertTable(connection = connection, databaseSchema = cohortDatabaseSchema, tableName = cohortInclusionTa
11: CohortGenerator::insertInclusionRuleNames(connection = connection, cohortDefinitionSet = subset, cohortDatabaseSchema = coho
10: eval(expr)
9: timeExecution(exportFolder, "getInclusionStatsCohortGenerator", parent = "getInclusionStats", expr = {
    CohortGenerator::i
8: getInclusionStats(connection = connection, exportFolder = exportFolder, databaseId = databaseId, cohortDefinitionSet = cohor
7: eval(expr)
6: timeExecution(exportFolder, "getInclusionStats", cohortIds, parent = "executeDiagnostics", expr = {
    getInclusionStats(con
5: cohortDiagnosticsExample.R#49: executeDiagnostics(cohortDefinitionSet, connectionDetails = connectionDetails, cohortTable = 
4: eval(ei, envir)
3: eval(ei, envir)
2: withVisible(eval(ei, envir))
1: source("~/projects/cohortDiagnosticsExample.R", echo = TRUE)

R version:
R version 4.4.2 (2024-10-31)

Platform:
x86_64-pc-linux-gnu

Attached base packages:
- stats
- graphics
- grDevices
- utils
- datasets
- methods
- base

Other attached packages:
- shiny (1.10.0)
- CohortGenerator (0.11.2)
- R6 (2.6.1)
- CohortDiagnostics (3.4.1)
- FeatureExtraction (3.10.0)
- Andromeda (1.0.0)
- dplyr (1.1.4)
- DatabaseConnector (6.4.0)


Thread: Main
Message:  java.sql.SQLException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request
POST https://bigquery.googleapis.com/bigquery/v2/projects/atals-01/jobs
{
  "code": 400,
  "errors": [
    {
      "domain": "global",
      "location": "q",
      "locationType": "parameter",
      "message": "Syntax error: Expected \"(\" but got end of script at [1:122]",
      "reason": "invalidQuery"
    }
  ],
  "message": "Syntax error: Expected \"(\" but got end of script at [1:122]",
  "status": "INVALID_ARGUMENT"
}
Level:  FATAL
Time:  2025-06-24 14:34:36

Stack trace:
17: (function (condition) 
{
    if (is(condition, "error")) {
        log("FATAL", conditionMessage(condition), echoToConsole = FA
16: stop(list("java.sql.SQLException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request\nP
15: .jcheck()
14: rJava::.jcall(batchedInsert, "Z", "executeBatch")
13: insertTable.default(connection = connection, databaseSchema = cohortDatabaseSchema, tableName = cohortInclusionTable, data =
12: DatabaseConnector::insertTable(connection = connection, databaseSchema = cohortDatabaseSchema, tableName = cohortInclusionTa
11: CohortGenerator::insertInclusionRuleNames(connection = connection, cohortDefinitionSet = subset, cohortDatabaseSchema = coho
10: eval(expr)
9: timeExecution(exportFolder, "getInclusionStatsCohortGenerator", parent = "getInclusionStats", expr = {
    CohortGenerator::i
8: getInclusionStats(connection = connection, exportFolder = exportFolder, databaseId = databaseId, cohortDefinitionSet = cohor
7: eval(expr)
6: timeExecution(exportFolder, "getInclusionStats", cohortIds, parent = "executeDiagnostics", expr = {
    getInclusionStats(con
5: cohortDiagnosticsExample.R#49: executeDiagnostics(cohortDefinitionSet, connectionDetails = connectionDetails, cohortTable = 
4: eval(ei, envir)
3: eval(ei, envir)
2: withVisible(eval(ei, envir))
1: source("~/projects/cohortDiagnosticsExample.R", echo = TRUE)

R version:
R version 4.4.2 (2024-10-31)

Platform:
x86_64-pc-linux-gnu

Attached base packages:
- stats
- graphics
- grDevices
- utils
- datasets
- methods
- base

Other attached packages:
- shiny (1.10.0)
- CohortGenerator (0.11.2)
- R6 (2.6.1)
- CohortDiagnostics (3.4.1)
- FeatureExtraction (3.10.0)
- Andromeda (1.0.0)
- dplyr (1.1.4)
- DatabaseConnector (6.4.0)


Thread: Main
Message:  java.sql.SQLException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request
POST https://bigquery.googleapis.com/bigquery/v2/projects/atals-01/jobs
{
  "code": 400,
  "errors": [
    {
      "domain": "global",
      "location": "q",
      "locationType": "parameter",
      "message": "Syntax error: Expected \"(\" but got end of script at [1:122]",
      "reason": "invalidQuery"
    }
  ],
  "message": "Syntax error: Expected \"(\" but got end of script at [1:122]",
  "status": "INVALID_ARGUMENT"
}
Level:  FATAL
Time:  2025-06-24 14:34:36

Stack trace:
17: (function (condition) 
{
    if (is(condition, "error")) {
        log("FATAL", conditionMessage(condition), echoToConsole = FA
16: stop(list("java.sql.SQLException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request\nP
15: .jcheck()
14: rJava::.jcall(batchedInsert, "Z", "executeBatch")
13: insertTable.default(connection = connection, databaseSchema = cohortDatabaseSchema, tableName = cohortInclusionTable, data =
12: DatabaseConnector::insertTable(connection = connection, databaseSchema = cohortDatabaseSchema, tableName = cohortInclusionTa
11: CohortGenerator::insertInclusionRuleNames(connection = connection, cohortDefinitionSet = subset, cohortDatabaseSchema = coho
10: eval(expr)
9: timeExecution(exportFolder, "getInclusionStatsCohortGenerator", parent = "getInclusionStats", expr = {
    CohortGenerator::i
8: getInclusionStats(connection = connection, exportFolder = exportFolder, databaseId = databaseId, cohortDefinitionSet = cohor
7: eval(expr)
6: timeExecution(exportFolder, "getInclusionStats", cohortIds, parent = "executeDiagnostics", expr = {
    getInclusionStats(con
5: cohortDiagnosticsExample.R#49: executeDiagnostics(cohortDefinitionSet, connectionDetails = connectionDetails, cohortTable = 
4: eval(ei, envir)
3: eval(ei, envir)
2: withVisible(eval(ei, envir))
1: source("~/projects/cohortDiagnosticsExample.R", echo = TRUE)

R version:
R version 4.4.2 (2024-10-31)

Platform:
x86_64-pc-linux-gnu

Attached base packages:
- stats
- graphics
- grDevices
- utils
- datasets
- methods
- base

Other attached packages:
- shiny (1.10.0)
- CohortGenerator (0.11.2)
- R6 (2.6.1)
- CohortDiagnostics (3.4.1)
- FeatureExtraction (3.10.0)
- Andromeda (1.0.0)
- dplyr (1.1.4)
- DatabaseConnector (6.4.0)