KEINE Freigabe der macOS Version Sequoia für tomedo®
Alle Hinweise und Informationen finden Sie unter folgendem Link.

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 (1.9k 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 (1.9k Punkte)
0 Punkte
17,809 Beiträge
25,980 Antworten
46,438 Kommentare
23,085 Nutzer