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)