Guten Abend,
leider habe ich im Support niemanden telefonisch erreicht (Mailbox ging nach paar mal Klingeln nur an). Beim Update auf die Version auf 1.69.0.7 von 1.68.0.9 ist folgende Fehlermeldung erschienen und das Update schlug fehl.
Ich werde nun das Backup der letzten Version wiederherstellen.
Schönen Abend noch.
[cmd 03.31. 20:59]$ tomedo-Update gestartet.
[cmd 03.31. 20:59]$ Updates werden gesucht …
[cmd 03.31. 20:59]$ … update tomedo: v1.68.0.9 -> v1.69.0.7
[cmd 03.31. 20:59]$ Backup wird erstellt …
[cmd 03.31. 20:59]$ tomedo Update herunterladen …
[cmd 03.31. 20:59]$ Download gestartet: /updates/auto/tomedo.app.v1.69.0.7.tar.gz
[cmd 03.31. 20:59]$ Download beendet: /updates/auto/tomedo.app.v1.69.0.7.tar.gz
[cmd 03.31. 20:59]$ Download gestartet: /updates/auto/tomedo_live.v1.69.war
[cmd 03.31. 20:59]$ Download beendet: /updates/auto/tomedo_live.v1.69.war
[cmd 03.31. 20:59]$ Download gestartet: /updates/auto/tomedo_update.v1.68-v1.69.jar
[cmd 03.31. 20:59]$ Download beendet: /updates/auto/tomedo_update.v1.68-v1.69.jar
[cmd 03.31. 20:59]$ Download gestartet: /updates/auto/tomedo_files.v1.68-v1.69.tar.gz
[cmd 03.31. 20:59]$ Download beendet: /updates/auto/tomedo_files.v1.68-v1.69.tar.gz
[cmd 03.31. 21:01]$ Server wird gestoppt …
[cmd 03.31. 21:01]$ tomedo Server aktualisieren …
[cmd 03.31. 21:01]$ Update-Skript ausführen …
[cmd 03.31. 21:01]$ /Users/admin/tomedo_server/java/bin/java -Xmx4096m -cp .:tomedo_update.v1.68-v1.69.jar com.zollsoft.medeye.util.update.UpdateRunner
Start...
2019-03-31 21:01:26,497: (ConnectionProviderInitiator.java:219) WARN | HHH000022: c3p0 properties were encountered, but the c3p0 provider class was not found on the classpath; these properties are going to be ignored.
2019-03-31 21:01:26,504: (DriverManagerConnectionProviderImpl.java:71) WARN | HHH10001002: Using Hibernate built-in connection pool (not for production use!)
2019-03-31 21:01:49,058: (Slf4jLog.java:48) WARN | outOfOrder mode is active. Migration of schema "public" may not be reproducible.
Migration 1.68_26: konvertierungsskript KassenbuchEintrag
2019-03-31 21:01:49,132: (Slf4jLog.java:52) ERROR | Migration of schema "public" to version 1.68.26 - konvertierungsskript KassenbuchEintrag failed! Changes successfully rolled back.
Exception in thread "main" org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
Migration V1.68_26__konvertierungsskript_KassenbuchEintrag.sql failed
---------------------------------------------------------------------
SQL State : 22P02
Error Code : 0
Message : ERROR: invalid input syntax for integer: "(null)"
Location : com/zollsoft/medeye/update/flyway/V1.68_26__konvertierungsskript_KassenbuchEintrag.sql (/private/var/folders/y0/nn1wjdzx2cg18b3_0vr6rc300000gn/T/com.zollsoft.tomedo-ServerTools/69/file:/private/var/folders/y0/nn1wjdzx2cg18b3_0vr6rc300000gn/T/com.zollsoft.tomedo-ServerTools/69/tomedo_update.v1.68-v1.69.jar!/com/zollsoft/medeye/update/flyway/V1.68_26__konvertierungsskript_KassenbuchEintrag.sql)
Line : 3
Statement : CREATE TEMPORARY TABLE temp AS
SELECT kbe.ident,
(CASE
WHEN (kbe.info LIKE '%Re-Nr.%' AND kbe.info LIKE '%Pat.%')
THEN (SELECT SUBSTRING(kbe.info FROM 'Re-Nr. (.*?), Pat.'))
WHEN (kbe.info LIKE '%Rechnungsnr.%' AND kbe.info LIKE '%Patient:%')
THEN (SELECT SUBSTRING(kbe.info FROM 'Rechnungsnr. (.*?), Patient:'))
WHEN (kbe.info LIKE '%Re-Nr.%' AND kbe.info LIKE '%Pat-Nr.%')
THEN (SELECT SUBSTRING(kbe.info FROM 'Re-Nr. (.*?), Pat-Nr.'))
WHEN (kbe.info LIKE '%Rechnungsnr.%' AND kbe.info LIKE '%Patientennummer:%')
THEN (SELECT SUBSTRING(kbe.info FROM 'Rechnungsnr. (.*?), Patientennummer:'))
ELSE ''
END) AS rechnungsNummer,
(CASE
WHEN (kbe.info LIKE '%Pat.%' AND kbe.info LIKE '%LE:%')
THEN (SELECT SUBSTRING(kbe.info FROM 'Pat. (.*?), LE:'))
WHEN (kbe.info LIKE '%Patient:%' AND kbe.info LIKE '%Leistungserbringer:%')
THEN (SELECT SUBSTRING(kbe.info FROM 'Patient: (.*?), Leistungserbringer:'))
WHEN (kbe.info LIKE '%Pat-Nr.%' AND kbe.info LIKE '%LE:%')
THEN (SELECT
COALESCE(TRIM(p1.titel)||' ', '') || COALESCE(TRIM(p1.vorname)||' ', '') || COALESCE(TRIM(pd1.namensZusatz)||' ', '') || COALESCE(TRIM(p1.nachname)||' ', '')
FROM patient p1
LEFT JOIN patientendetails pd1 ON p1.patientendetails_ident = pd1.ident
WHERE p1.ident = (SELECT SUBSTRING(kbe.info FROM 'Pat-Nr. (.*?), LE:'))::INT
LIMIT 1)
WHEN (kbe.info LIKE '%Patientennummer:%' AND kbe.info LIKE '%Leistungserbringer:%')
THEN (SELECT
COALESCE(TRIM(p1.titel)||' ', '') || COALESCE(TRIM(p1.vorname)||' ', '') || COALESCE(TRIM(pd1.namensZusatz)||' ', '') || COALESCE(TRIM(p1.nachname)||' ', '')
FROM patient p1
LEFT JOIN patientendetails pd1 ON p1.patientendetails_ident = pd1.ident
WHERE p1.ident = (SELECT SUBSTRING(kbe.info FROM 'Patientennummer: (.*?), Leistungserbringer:'))::INT
LIMIT 1)
ELSE ''
END) AS patientenVollname
FROM kassenbucheintrag kbe
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:145)
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:76)
at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java:324)
at org.flywaydb.core.internal.command.DbMigrate.access$900(DbMigrate.java:49)
at org.flywaydb.core.internal.command.DbMigrate$4.call(DbMigrate.java:280)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:75)
at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:277)
at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:49)
at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:201)
at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:142)
at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:68)
at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLDbSupport.lock(PostgreSQLDbSupport.java:159)
at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.lock(MetaDataTableImpl.java:174)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:142)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:969)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:930)
at org.flywaydb.core.Flyway.execute(Flyway.java:1413)
at org.flywaydb.core.Flyway.migrate(Flyway.java:930)
at com.zollsoft.medeye.util.update.UpdateRunner.updateWithFlyway(UpdateRunner.java:197)
at com.zollsoft.medeye.util.update.UpdateRunner.main(UpdateRunner.java:54)
Caused by: org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: "(null)"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:262)
at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:267)
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:142)
... 19 more