Unser Update zur aktuellen Situation

Liebe tomedianer,

aus gegebenem Anlass möchten wir Ihnen versichern, dass wir alles dafür tun, um Ihnen in den kommenden Wochen auch weiterhin in gewohnter Art und Weise zur Verfügung zu stehen.

Gleichzeitig ist es unsere Priorität, die Gesundheit und das Wohlbefinden unserer Nutzer und Mitarbeiter zu schützen und unseren Teil zur Eindämmung der Verbreitung von COVID-19/Corona beizutragen. Aus diesem Grund haben auch wir ab sofort einige technische und organisatorische Maßnahmen getroffen, sodass u.a. ein Großteil unserer Mitarbeiter inkl. unserem Supportteam von zu Hause aus arbeiten kann. Wir bitten um Ihr Verständnis, falls es dadurch evt. zu längeren Wartezeiten an der Hotline bzw. bei der Beantwortung von E-Mail und/oder Forumsanfragen kommt.

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

 

Gefragt von (490 Punkte)
0 Punkte

1 Antwort

[cmd 03.31. 21:01]$ tomedo-Update wurde NICHT erfolgreich abgeschlossen. Fehler: Java Update Skript konnte nicht ausgeführt werden. Fehler: Befehl wurde nicht erfolgreich ausgeführt. Fehlercode: 1. Output: 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

 

Beantwortet von (490 Punkte)
0 Punkte
5,473 Beiträge
9,665 Antworten
12,403 Kommentare
2,227 Nutzer