Hallo,

ich wollte heute mal meine 2.0.4 auf 2.1.0e updaten. Nach dem Update startete Fakturama und bliebt lange bei checking databases stehen und schloss sich dann einfach wieder. Beim 2. Start bleibt es einfach hängen, keine weiteren Logausgaben (Datenbank gesperrt?)

(Log Datei hab ich angehängt, erste Zeile ist:
20201128 15:36:02.695 | ERROR | LOG | Change Set /changelog/db.changelog-2.1.xml::20190915-051::rheydenr failed. Error: data exception: string data, right truncation [Failed SQL: (-3401) INSERT INTO TMP_CONTACTS_WITH_ADDRESSES)

Damit ich weiter arbeiten konnte, bin ich dann zurück auf eine 2.0.5 und hab die Datenbank aus dem Backup geholt.

PS: Da ich keine Datei anhängen darf, hier die Zeile:

Spoiler
error.log
20201128 15:34:02.471 | DEBUG | c.s.f.LifecycleManager.postWindowClose:386 | Storing preferences in database

20201128 15:34:02.623 | DEBUG | c.s.f.LifecycleManager.postWindowClose:397 | save dialog settings

20201128 15:34:03.064 | WARN | com.sebulli.fakturama.common [ OSGI_BUNDLE ] | TEST

20201128 15:34:03.116 | INFO | com.sebulli.fakturama.common [ OSGI_BUNDLE ] | create Database backup in E:\DATEN\Fakturama2\Backup\Backup_20201128_153410.zip

20201128 15:36:02.695 | ERROR | LOG | Change Set /changelog/db.changelog-2.1.xml::20190915-051::rheydenr failed. Error: data exception: string data, right truncation [Failed SQL: (-3401) INSERT INTO TMP_CONTACTS_WITH_ADDRESSES

( BILLING_ADDRESS_ID,

BILLING_ADDRESS_CITY,

BILLING_ADDRESS_CITYADDON,

BILLING_ADDRESS_COUNTRYCODE,

BILLING_ADDRESS_DATEADDED,

BILLING_ADDRESS_DELETED,

BILLING_ADDRESS_MANUALADDRESS,

BILLING_ADDRESS_MODIFIED,

BILLING_ADDRESS_MODIFIEDBY,

BILLING_ADDRESS_NAME,

BILLING_ADDRESS_STREET,

BILLING_ADDRESS_VALIDFROM,

BILLING_ADDRESS_VALIDTO,

BILLING_ADDRESS_ZIP,

BILLING_CONTACT_ID,

BILLING_CONTACT_DTYPE,

BILLING_CONTACT_BIRTHDAY,

BILLING_CONTACT_COMPANY,

BILLING_CONTACT_CONTACTTYPE,

BILLING_CONTACT_CUSTOMERNUMBER,

BILLING_CONTACT_DATEADDED,

BILLING_CONTACT_DELETED,

BILLING_CONTACT_DISCOUNT,

BILLING_CONTACT_EMAIL,

BILLING_CONTACT_FAX,

BILLING_CONTACT_FIRSTNAME,

BILLING_CONTACT_GENDER,

BILLING_CONTACT_GLN,

BILLING_CONTACT_MANDATEREFERENCE,

BILLING_CONTACT_MOBILE,

BILLING_CONTACT_MODIFIED,

BILLING_CONTACT_MODIFIEDBY,

BILLING_CONTACT_NAME,

BILLING_CONTACT_NOTE,

BILLING_CONTACT_PHONE,

BILLING_CONTACT_RELIABILITY,

BILLING_CONTACT_SUPPLIERNUMBER,

BILLING_CONTACT_TITLE,

BILLING_CONTACT_USENETGROSS,

BILLING_CONTACT_USESALESEQUALIZATIONTAX,

BILLING_CONTACT_VALIDFROM,

BILLING_CONTACT_VALIDTO,

BILLING_CONTACT_VATNUMBER,

BILLING_CONTACT_VATNUMBERVALID,

BILLING_CONTACT_WEBSHOPNAME,

BILLING_CONTACT_WEBSITE,

BILLING_CONTACT_FK_ADDRESS,

BILLING_CONTACT_FK_ALTERNATECONTACT,

BILLING_CONTACT_FK_BANKACCOUNT,

BILLING_CONTACT_FK_CATEGORY,

BILLING_CONTACT_FK_PAYMENT

)

SELECT

a1.ID,

a1.CITY,

a1.CITYADDON,

a1.COUNTRYCODE,

a1.DATEADDED,

a1.DELETED,

a1.MANUALADDRESS,

a1.MODIFIED,

a1.MODIFIEDBY,

a1.NAME,

a1.STREET,

a1.VALIDFROM,

a1.VALIDTO,

left(a1.ZIP, 16),

c1.id,

c1.DTYPE,

c1.BIRTHDAY,

c1.COMPANY,

c1.CONTACTTYPE,

left(c1.CUSTOMERNUMBER, 32),

c1.DATEADDED,

c1.DELETED,

c1.DISCOUNT,

c1.EMAIL,

c1.FAX,

c1.FIRSTNAME,

c1.GENDER,

c1.GLN,

c1.MANDATEREFERENCE,

c1.MOBILE,

c1.MODIFIED,

c1.MODIFIEDBY,

c1.NAME,

c1.NOTE,

c1.PHONE,

c1.RELIABILITY,

c1.SUPPLIERNUMBER,

c1.TITLE,

c1.USENETGROSS,

c1.USESALESEQUALIZATIONTAX,

c1.VALIDFROM,

c1.VALIDTO,

c1.VATNUMBER,

c1.VATNUMBERVALID,

c1.WEBSHOPNAME,

c1.WEBSITE,

c1.FK_ADDRESS,

c1.FK_ALTERNATECONTACT,

c1.FK_BANKACCOUNT,

c1.FK_CATEGORY,

c1.FK_PAYMENT

FROM FKT_CONTACT c1

LEFT JOIN FKT_ADDRESS a1

ON c1.fk_address = a1.id

WHERE c1.CONTACTTYPE = 0 

AND a1.id is not null /* Billing contacts */]

20201128 15:36:02.706 | ERROR | com.sebulli.fakturama.common [ OSGI_BUNDLE ] | Can't show the error message in Error View because no EventBroker is available!

20201128 15:36:02.706 | ERROR | c.s.f.LifecycleManager.checksBeforeStartup:161 | couldn't create or update database!