Stream: implementers
Topic: hapi-fhir-cli dry-run fails
Jordi Cabré (Jul 01 2021 at 09:47):
I'm getting this message:
2021-07-01 11:34:50.218 [main] ERROR ca.uhn.fhir.cli.App Error during execution:
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table TRM_CONCEPT_DESIG add constraint FK_CONCEPTDESIG_CSV foreign key (CS_VER_PID) references TRM_CODESYSTEM_VER]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:393)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:431)
at ca.uhn.fhir.jpa.migrate.taskdef.AddTableRawSqlTask.lambda$doExecute$2(AddTableRawSqlTask.java:80)
at ca.uhn.fhir.jpa.migrate.taskdef.AddTableRawSqlTask$$Lambda$139/0000000038802B70.doInTransaction(Unknown Source)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
at ca.uhn.fhir.jpa.migrate.taskdef.AddTableRawSqlTask.doExecute(AddTableRawSqlTask.java:76)
at ca.uhn.fhir.jpa.migrate.taskdef.BaseTask.execute(BaseTask.java:179)
at ca.uhn.fhir.jpa.migrate.TaskOnlyMigrator.migrate(TaskOnlyMigrator.java:59)
at ca.uhn.fhir.cli.BaseFlywayMigrateDatabaseCommand.run(BaseFlywayMigrateDatabaseCommand.java:137)
at ca.uhn.fhir.cli.HapiFlywayMigrateDatabaseCommand.run(HapiFlywayMigrateDatabaseCommand.java:56)
at ca.uhn.fhir.cli.BaseApp.run(BaseApp.java:269)
at ca.uhn.fhir.cli.App.main(App.java:43)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:422)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)
... 11 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 27 common frames omitted
2021-07-01 11:34:50.231 [Thread-3] INFO ca.uhn.fhir.cli.App HAPI FHIR is shutting down...
My database is absolutely empty, and I'm using --dry-run option in order to get sql statements.
My command is:
java -cp hapi-fhir-cli.jar:/home/jeusdi/projects/workarea/salut/mpi/ojdbc8.jar -agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=8000 ca.uhn.fhir.cli.App migrate-database -d ORACLE_12C -n HES_MPI_TEST_ADM -p hesmpitestadm4des -u jdbc:oracle:thin:@10.49.160.114:1521:ORCLCDB --dry-run
Any ideas?
Jordi Cabré (Jul 01 2021 at 10:06):
Currently, I'm getting this other message:
2021-07-01 12:04:14.345 [main] INFO c.u.f.j.m.TaskOnlyMigrator Dry run 4_0_0.20190722.29 Rename column CODE to CODEVAL on table TRM_CONCEPT
2021-07-01 12:04:14.440 [main] ERROR ca.uhn.fhir.cli.App Error during execution:
ca.uhn.fhir.rest.server.exceptions.InternalErrorException: Can not rename TRM_CONCEPT.CODE to CODEVAL because neither column exists!
at ca.uhn.fhir.jpa.migrate.TaskOnlyMigrator.migrate(TaskOnlyMigrator.java:62)
at ca.uhn.fhir.cli.BaseFlywayMigrateDatabaseCommand.run(BaseFlywayMigrateDatabaseCommand.java:137)
at ca.uhn.fhir.cli.HapiFlywayMigrateDatabaseCommand.run(HapiFlywayMigrateDatabaseCommand.java:56)
at ca.uhn.fhir.cli.BaseApp.run(BaseApp.java:269)
at ca.uhn.fhir.cli.App.main(App.java:43)
Caused by: java.sql.SQLException: Can not rename TRM_CONCEPT.CODE to CODEVAL because neither column exists!
at ca.uhn.fhir.jpa.migrate.taskdef.RenameColumnTask.doExecute(RenameColumnTask.java:114)
at ca.uhn.fhir.jpa.migrate.taskdef.BaseTask.execute(BaseTask.java:179)
at ca.uhn.fhir.jpa.migrate.TaskOnlyMigrator.migrate(TaskOnlyMigrator.java:59)
... 4 common frames omitted
Jordi Cabré (Jul 01 2021 at 10:13):
I've just realized that:
1) --dry-run is creating tables on my database :frown:
2) Each time I perform my command I'm getting different messages:
* `bad SQL grammar [alter table TRM_CONCEPT_MAP add constraint FK_TRMCONCEPTMAP_RES foreign key (RES_ID) references HFJ_RESOURCE]`
* bad SQL grammar [alter table TRM_CONCEPT_PROPERTY add constraint FK_CONCEPTPROP_CSV foreign key (CS_VER_PID) references TRM_CODESYSTEM_VER];
* ...
Jordi Cabré (Jul 01 2021 at 10:26):
My goal is to get sql statements scripts... Any idea?
Vassil Peytchev (Jul 01 2021 at 14:46):
If that is happening on a HAPI server, you can probably get better responses on the #hapi channel...
Last updated: Apr 12 2022 at 19:14 UTC
