ORA-00955: name is already used by an existing object

[lichao060103]

I ran into this problem when I was executing.

2020-06-04 19:24:14 [Main thread] TRACE PatientLevelPrediction Running setting 2 2020-06-04 19:24:15 [Main thread] TRACE PatientLevelPrediction 3 Error with getPlpData:Error: Error executing SQL: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object An error report has been created at /root/errorReport.txt 2020-06-04 19:24:15 [Main thread] TRACE PatientLevelPrediction Done plpData. 2020-06-04 19:24:15 [Main thread] INFO PatientLevelPrediction No plpData - probably empty cohort issue 2020-06-04 19:24:15 [Main thread] TRACE PatientLevelPrediction Setting population settings for setting 2 2020-06-04 19:24:15 [Main thread] WARN PatientLevelPrediction addExposureDaysToStart is depreciated - please use startAnchor instead 2020-06-04 19:24:15 [Main thread] WARN PatientLevelPrediction addExposureDaysToEnd is depreciated - please use endAnchor instead 2020-06-04 19:24:15 [Main thread] TRACE PatientLevelPrediction 3 Error with pop:Error in class(plpData) %in% c("plpData.libsvm", "plpData.coo", "plpData"): argument "plpData" is missing, with no default

[jreps]

What SQL language are you using? It seems a table or something from a prior data extract may not have been deleted

[lichao060103]

oracle

[lichao060103]

  1 DBMS:
  2 oracle
  3 
  4 Error:
  5 java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
  6 
  7 
  8 SQL:
  9 CREATE TABLE HGH.t1tcvom9cov_1
 10  AS
 11 SELECT
 12 CAST(FLOOR((EXTRACT(YEAR FROM cohort_start_date) - year_of_birth) / 5) * 1000 + 3 AS NUMBER(19)) AS covariate_id,
 13 
 14 
 15         cohort.row_id AS row_id,
 16         1 AS covariate_value
 17 
 18 
 19 FROM
 20 HGH.t1tcvom9cohort_person cohort
 21 INNER JOIN HGH.person
 22         ON cohort.subject_id = person.person_id
 23 
 24 
 25 
 26 
 27 
 28 R version:
 29 R version 3.6.0 (2019-04-26)
 30 
 31 Platform:
 32 x86_64-redhat-linux-gnu
 33 
 34 Attached base packages:
 35 - stats
 36 - graphics
 37 - grDevices
 38 - utils
 39 - datasets
 40 - methods
 41 - base
 42 
 43 Other attached packages:
 44 - SevereInHospitalizedPatients (0.0.1)
 45 - DatabaseConnector (2.4.2)

[lichao060103]

library(SevereInHospitalizedPatients) outputFolder <- "/root/SevereInHospitalizedPatientsResults" options(fftempdir = "/root/ohdsi")

dbms <- 'oracle' user <- '' pw <- '' server <- '.../***' port <- '1521'

connectionDetails <- DatabaseConnector::createConnectionDetails(dbms = dbms, server = server, user = user, password = pw, port = port)

cdmDatabaseSchema <- '' cdmDatabaseName <- '' cohortDatabaseSchema <- '***' oracleTempSchema <- NULL

cohortTable <- 'OHDSICohort'

execute(connectionDetails = connectionDetails, cdmDatabaseSchema = cdmDatabaseSchema, cdmDatabaseName = cdmDatabaseName, cohortDatabaseSchema = cohortDatabaseSchema, cohortTable = cohortTable, oracleTempSchema = oracleTempSchema, outputFolder = outputFolder, createProtocol = F, runDiagnostic = F, viewDiagnostic = F, createCohorts = F, runAnalyses = T, createResultsDoc = F, packageResults = F, createValidationPackage = F, minCellCount= 5)