Ich wollte jetzt mal die alte Version 1.6.4 installieren,
geht aber nicht, es passiert gar nichts, dann habe ich mal die 1.6.9 versucht,
die will Java SE6 haben. Hat jemand einen Tip?

Hallo André, die 1.6.9 funktioniert erst ab Java 7. Arbeitest Du auf MacOS?

Hallo Ralf,

ja, ich arbeite auf OS X10.12.6
Habe aber die 1.6.4 wieder ans laufen gebracht und habe die SE6 dazu installiert.

Ah, ok. Aber perspektivisch solltest Du wirklich auf Java 8 umsteigen.

Ja aber wenn ich nur 8er installiere, startet Fakturama 1.6.4 nicht mehr 🙁

Hm. Und warum nimmst Du dann nicht die 1.6.9? Damit müßte es doch gehen?

Hallo Sry hat ein bisschen gedauert bei mir bis ich jetzt wieder die Zeit gefunden habe!

hab jetzt den Import noch einmal versucht leider ohne Erfolg!

Anbei die .log file

!SESSION 2018-02-28 00:17:54.750 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.8.0_161
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=de_AT
Command-line arguments: -os win32 -ws win32 -arch x86_64

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:34.573
!MESSAGE create Document list part
!SESSION 2018-02-28 00:18:36.796 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.8.0_161
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=de_AT
Command-line arguments: -os win32 -ws win32 -arch x86_64

!ENTRY org.eclipse.e4.ui.workbench 4 0 2018-02-28 00:18:54.147
!MESSAGE error while migrating Payments; Message: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DEPOSITTEXT in statement [SELECT ID, CATEGORY, DEFAULTPAID, DELETED, DEPOSITTEXT, DESCRIPTION, DISCOUNTDAYS, DISCOUNTVALUE, NAME, NETDAYS, PAIDTEXT, UNPAIDTEXT FROM Payments]
Error Code: -5501
Call: SELECT ID, CATEGORY, DEFAULTPAID, DELETED, DEPOSITTEXT, DESCRIPTION, DISCOUNTDAYS, DISCOUNTVALUE, NAME, NETDAYS, PAIDTEXT, UNPAIDTEXT FROM Payments
Query: ReadAllQuery(referenceClass=OldPayments sql="SELECT ID, CATEGORY, DEFAULTPAID, DELETED, DEPOSITTEXT, DESCRIPTION, DISCOUNTDAYS, DISCOUNTVALUE, NAME, NETDAYS, PAIDTEXT, UNPAIDTEXT FROM Payments")
!STACK 0
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DEPOSITTEXT in statement [SELECT ID, CATEGORY, DEFAULTPAID, DELETED, DEPOSITTEXT, DESCRIPTION, DISCOUNTDAYS, DISCOUNTVALUE, NAME, NETDAYS, PAIDTEXT, UNPAIDTEXT FROM Payments]
Error Code: -5501
Call: SELECT ID, CATEGORY, DEFAULTPAID, DELETED, DEPOSITTEXT, DESCRIPTION, DISCOUNTDAYS, DISCOUNTVALUE, NAME, NETDAYS, PAIDTEXT, UNPAIDTEXT FROM Payments
Query: ReadAllQuery(referenceClass=OldPayments sql="SELECT ID, CATEGORY, DEFAULTPAID, DELETED, DEPOSITTEXT, DESCRIPTION, DISCOUNTDAYS, DISCOUNTVALUE, NAME, NETDAYS, PAIDTEXT, UNPAIDTEXT FROM Payments")
	at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:389)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262)
	at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:480)
	at com.sebulli.fakturama.migration.olddao.OldEntitiesDAO.findAllPayments(OldEntitiesDAO.java:280)
	at com.sebulli.fakturama.migration.MigrationManager.runMigratePaymentsSubTask(MigrationManager.java:1181)
	at com.sebulli.fakturama.migration.MigrationManager.runMigration(MigrationManager.java:453)
	at com.sebulli.fakturama.migration.MigrationManager.access$1(MigrationManager.java:423)
	at com.sebulli.fakturama.migration.MigrationManager$1.run(MigrationManager.java:336)
	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DEPOSITTEXT in statement [SELECT ID, CATEGORY, DEFAULTPAID, DELETED, DEPOSITTEXT, DESCRIPTION, DISCOUNTDAYS, DISCOUNTVALUE, NAME, NETDAYS, PAIDTEXT, UNPAIDTEXT FROM Payments]
Error Code: -5501
Call: SELECT ID, CATEGORY, DEFAULTPAID, DELETED, DEPOSITTEXT, DESCRIPTION, DISCOUNTDAYS, DISCOUNTVALUE, NAME, NETDAYS, PAIDTEXT, UNPAIDTEXT FROM Payments
Query: ReadAllQuery(referenceClass=OldPayments sql="SELECT ID, CATEGORY, DEFAULTPAID, DELETED, DEPOSITTEXT, DESCRIPTION, DISCOUNTDAYS, DISCOUNTVALUE, NAME, NETDAYS, PAIDTEXT, UNPAIDTEXT FROM Payments")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:688)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:564)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2093)
	at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:600)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:270)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:256)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:327)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:722)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693)
	at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:563)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1221)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1180)
	at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:464)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1268)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2979)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1892)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1874)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
	... 7 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DEPOSITTEXT in statement [SELECT ID, CATEGORY, DEFAULTPAID, DELETED, DEPOSITTEXT, DESCRIPTION, DISCOUNTDAYS, DISCOUNTVALUE, NAME, NETDAYS, PAIDTEXT, UNPAIDTEXT FROM Payments]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1590)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1539)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:804)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:625)
	... 27 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: DEPOSITTEXT
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source)
	at org.hsqldb.QueryExpression.resolve(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 33 more

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.152
!MESSAGE propertiesFile: C:UsersspeDocumentsFakturamafakturamaviews.properties

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.180
!MESSAGE {fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.181
!MESSAGE {fakturama.views.documentTable.BODY.columnWidth.sizes=0:12,1:14,2:3,3:33,4:10,5:16,6:12, fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.181
!MESSAGE {fakturama.views.paymentTable.BODY.columnWidth.sizes=0:32,1:12,2:9,3:25,4:12,5:10, fakturama.views.documentTable.BODY.columnWidth.sizes=0:12,1:14,2:3,3:33,4:10,5:16,6:12, fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.182
!MESSAGE {fakturama.views.contactTable.BODY.columnWidth.sizes=0:6,1:25,2:33,3:20,4:9,5:7, fakturama.views.paymentTable.BODY.columnWidth.sizes=0:32,1:12,2:9,3:25,4:12,5:10, fakturama.views.documentTable.BODY.columnWidth.sizes=0:12,1:14,2:3,3:33,4:10,5:16,6:12, fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.182
!MESSAGE {fakturama.views.contactTable.BODY.columnWidth.sizes=0:6,1:25,2:33,3:20,4:9,5:7, fakturama.views.paymentTable.BODY.columnWidth.sizes=0:32,1:12,2:9,3:25,4:12,5:10, fakturama.views.documentTable.BODY.columnWidth.sizes=0:12,1:14,2:3,3:33,4:10,5:16,6:12, PRODUCTS.BODY.columnWidth.sizes=0:24,1:11,2:25,3:16,4:16,5:8, fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.183
!MESSAGE {fakturama.views.contactTable.BODY.columnWidth.sizes=0:6,1:25,2:33,3:20,4:9,5:7, TEXTS.BODY.columnWidth.sizes=0:0,1:100, fakturama.views.paymentTable.BODY.columnWidth.sizes=0:32,1:12,2:9,3:25,4:12,5:10, fakturama.views.documentTable.BODY.columnWidth.sizes=0:12,1:14,2:3,3:33,4:10,5:16,6:12, PRODUCTS.BODY.columnWidth.sizes=0:24,1:11,2:25,3:16,4:16,5:8, fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.183
!MESSAGE {fakturama.document.itemTable.BODY.columnWidth.sizes=0:11,1:7,2:10,3:12,4:5,5:8,6:5,7:11,8:7,9:7,10:11,11:6, fakturama.views.contactTable.BODY.columnWidth.sizes=0:6,1:25,2:33,3:20,4:9,5:7, TEXTS.BODY.columnWidth.sizes=0:0,1:100, fakturama.views.paymentTable.BODY.columnWidth.sizes=0:32,1:12,2:9,3:25,4:12,5:10, fakturama.views.documentTable.BODY.columnWidth.sizes=0:12,1:14,2:3,3:33,4:10,5:16,6:12, PRODUCTS.BODY.columnWidth.sizes=0:24,1:11,2:25,3:16,4:16,5:8, fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.184
!MESSAGE {fakturama.document.itemTable.BODY.columnWidth.sizes=0:11,1:7,2:10,3:12,4:5,5:8,6:5,7:11,8:7,9:7,10:11,11:6, fakturama.views.contactTable.BODY.columnWidth.sizes=0:6,1:25,2:33,3:20,4:9,5:7, TEXTS.BODY.columnWidth.sizes=0:0,1:100, VOUCHERITEMS.BODY.columnWidth.sizes=0:23,1:14,2:14,3:33,4:16, fakturama.views.paymentTable.BODY.columnWidth.sizes=0:32,1:12,2:9,3:25,4:12,5:10, fakturama.views.documentTable.BODY.columnWidth.sizes=0:12,1:14,2:3,3:33,4:10,5:16,6:12, PRODUCTS.BODY.columnWidth.sizes=0:24,1:11,2:25,3:16,4:16,5:8, fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.185
!MESSAGE {VOUCHERS.BODY.columnWidth.sizes=0:9,1:25,2:3,3:33,4:14,5:16, fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16, fakturama.views.documentTable.BODY.columnWidth.sizes=0:12,1:14,2:3,3:33,4:10,5:16,6:12, fakturama.views.contactTable.BODY.columnWidth.sizes=0:6,1:25,2:33,3:20,4:9,5:7, fakturama.views.paymentTable.BODY.columnWidth.sizes=0:32,1:12,2:9,3:25,4:12,5:10, TEXTS.BODY.columnWidth.sizes=0:0,1:100, VOUCHERITEMS.BODY.columnWidth.sizes=0:23,1:14,2:14,3:33,4:16, PRODUCTS.BODY.columnWidth.sizes=0:24,1:11,2:25,3:16,4:16,5:8, fakturama.document.itemTable.BODY.columnWidth.sizes=0:11,1:7,2:10,3:12,4:5,5:8,6:5,7:11,8:7,9:7,10:11,11:6}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.185
!MESSAGE {VOUCHERS.BODY.columnWidth.sizes=0:9,1:25,2:3,3:33,4:14,5:16, fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16, fakturama.views.shippingTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16, fakturama.views.documentTable.BODY.columnWidth.sizes=0:12,1:14,2:3,3:33,4:10,5:16,6:12, fakturama.views.contactTable.BODY.columnWidth.sizes=0:6,1:25,2:33,3:20,4:9,5:7, fakturama.views.paymentTable.BODY.columnWidth.sizes=0:32,1:12,2:9,3:25,4:12,5:10, TEXTS.BODY.columnWidth.sizes=0:0,1:100, VOUCHERITEMS.BODY.columnWidth.sizes=0:23,1:14,2:14,3:33,4:16, PRODUCTS.BODY.columnWidth.sizes=0:24,1:11,2:25,3:16,4:16,5:8, fakturama.document.itemTable.BODY.columnWidth.sizes=0:11,1:7,2:10,3:12,4:5,5:8,6:5,7:11,8:7,9:7,10:11,11:6}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.186
!MESSAGE {VOUCHERS.BODY.columnWidth.sizes=0:9,1:25,2:3,3:33,4:14,5:16, fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16, LIST.BODY.columnWidth.sizes=0:50,1:50, fakturama.views.shippingTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16, fakturama.views.documentTable.BODY.columnWidth.sizes=0:12,1:14,2:3,3:33,4:10,5:16,6:12, fakturama.views.contactTable.BODY.columnWidth.sizes=0:6,1:25,2:33,3:20,4:9,5:7, fakturama.views.paymentTable.BODY.columnWidth.sizes=0:32,1:12,2:9,3:25,4:12,5:10, TEXTS.BODY.columnWidth.sizes=0:0,1:100, VOUCHERITEMS.BODY.columnWidth.sizes=0:23,1:14,2:14,3:33,4:16, PRODUCTS.BODY.columnWidth.sizes=0:24,1:11,2:25,3:16,4:16,5:8, fakturama.document.itemTable.BODY.columnWidth.sizes=0:11,1:7,2:10,3:12,4:5,5:8,6:5,7:11,8:7,9:7,10:11,11:6}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:54.189
!MESSAGE --- old data end ----

!ENTRY org.eclipse.e4.ui.workbench 4 0 2018-02-28 00:18:56.032
!MESSAGE error while migrating Properties; Message: null
!STACK 0
java.lang.NullPointerException
	at com.sebulli.fakturama.migration.MigrationManager.runMigratePropertiesSubTask(MigrationManager.java:1364)
	at com.sebulli.fakturama.migration.MigrationManager.runMigration(MigrationManager.java:430)
	at com.sebulli.fakturama.migration.MigrationManager.access$1(MigrationManager.java:423)
	at com.sebulli.fakturama.migration.MigrationManager$1.run(MigrationManager.java:336)
	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

!ENTRY org.eclipse.e4.ui.workbench 4 0 2018-02-28 00:18:56.866
!MESSAGE error while migrating Contacts; Message: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: MANDAT_REF in statement [SELECT ID, ACCOUNT, ACCOUNT_HOLDER, BANK_CODE, BANK_NAME, BIC, BIRTHDAY, CATEGORY, CITY, COMPANY, COUNTRY, DATE_ADDED, DELETED, DELIVERY_BIRTHDAY, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY, DELIVERY_FIRSTNAME, DELIVERY_GENDER, DELIVERY_NAME, DELIVERY_STREET, DELIVERY_TITLE, DELIVERY_ZIP, DISCOUNT, EMAIL, FAX, FIRSTNAME, GENDER, IBAN, MANDAT_REF, MOBILE, NAME, NOTE, NR, PAYMENT, PHONE, RELIABILITY, STREET, SUPPLIERNUMBER, TITLE, USE_NET_GROSS, VATNR, VATNRVALID, WEBSITE, ZIP FROM CONTACTS]
Error Code: -5501
Call: SELECT ID, ACCOUNT, ACCOUNT_HOLDER, BANK_CODE, BANK_NAME, BIC, BIRTHDAY, CATEGORY, CITY, COMPANY, COUNTRY, DATE_ADDED, DELETED, DELIVERY_BIRTHDAY, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY, DELIVERY_FIRSTNAME, DELIVERY_GENDER, DELIVERY_NAME, DELIVERY_STREET, DELIVERY_TITLE, DELIVERY_ZIP, DISCOUNT, EMAIL, FAX, FIRSTNAME, GENDER, IBAN, MANDAT_REF, MOBILE, NAME, NOTE, NR, PAYMENT, PHONE, RELIABILITY, STREET, SUPPLIERNUMBER, TITLE, USE_NET_GROSS, VATNR, VATNRVALID, WEBSITE, ZIP FROM CONTACTS
Query: ReadAllQuery(referenceClass=OldContacts sql="SELECT ID, ACCOUNT, ACCOUNT_HOLDER, BANK_CODE, BANK_NAME, BIC, BIRTHDAY, CATEGORY, CITY, COMPANY, COUNTRY, DATE_ADDED, DELETED, DELIVERY_BIRTHDAY, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY, DELIVERY_FIRSTNAME, DELIVERY_GENDER, DELIVERY_NAME, DELIVERY_STREET, DELIVERY_TITLE, DELIVERY_ZIP, DISCOUNT, EMAIL, FAX, FIRSTNAME, GENDER, IBAN, MANDAT_REF, MOBILE, NAME, NOTE, NR, PAYMENT, PHONE, RELIABILITY, STREET, SUPPLIERNUMBER, TITLE, USE_NET_GROSS, VATNR, VATNRVALID, WEBSITE, ZIP FROM CONTACTS")
!STACK 0
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: MANDAT_REF in statement [SELECT ID, ACCOUNT, ACCOUNT_HOLDER, BANK_CODE, BANK_NAME, BIC, BIRTHDAY, CATEGORY, CITY, COMPANY, COUNTRY, DATE_ADDED, DELETED, DELIVERY_BIRTHDAY, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY, DELIVERY_FIRSTNAME, DELIVERY_GENDER, DELIVERY_NAME, DELIVERY_STREET, DELIVERY_TITLE, DELIVERY_ZIP, DISCOUNT, EMAIL, FAX, FIRSTNAME, GENDER, IBAN, MANDAT_REF, MOBILE, NAME, NOTE, NR, PAYMENT, PHONE, RELIABILITY, STREET, SUPPLIERNUMBER, TITLE, USE_NET_GROSS, VATNR, VATNRVALID, WEBSITE, ZIP FROM CONTACTS]
Error Code: -5501
Call: SELECT ID, ACCOUNT, ACCOUNT_HOLDER, BANK_CODE, BANK_NAME, BIC, BIRTHDAY, CATEGORY, CITY, COMPANY, COUNTRY, DATE_ADDED, DELETED, DELIVERY_BIRTHDAY, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY, DELIVERY_FIRSTNAME, DELIVERY_GENDER, DELIVERY_NAME, DELIVERY_STREET, DELIVERY_TITLE, DELIVERY_ZIP, DISCOUNT, EMAIL, FAX, FIRSTNAME, GENDER, IBAN, MANDAT_REF, MOBILE, NAME, NOTE, NR, PAYMENT, PHONE, RELIABILITY, STREET, SUPPLIERNUMBER, TITLE, USE_NET_GROSS, VATNR, VATNRVALID, WEBSITE, ZIP FROM CONTACTS
Query: ReadAllQuery(referenceClass=OldContacts sql="SELECT ID, ACCOUNT, ACCOUNT_HOLDER, BANK_CODE, BANK_NAME, BIC, BIRTHDAY, CATEGORY, CITY, COMPANY, COUNTRY, DATE_ADDED, DELETED, DELIVERY_BIRTHDAY, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY, DELIVERY_FIRSTNAME, DELIVERY_GENDER, DELIVERY_NAME, DELIVERY_STREET, DELIVERY_TITLE, DELIVERY_ZIP, DISCOUNT, EMAIL, FAX, FIRSTNAME, GENDER, IBAN, MANDAT_REF, MOBILE, NAME, NOTE, NR, PAYMENT, PHONE, RELIABILITY, STREET, SUPPLIERNUMBER, TITLE, USE_NET_GROSS, VATNR, VATNRVALID, WEBSITE, ZIP FROM CONTACTS")
	at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:389)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262)
	at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:480)
	at com.sebulli.fakturama.migration.olddao.OldEntitiesDAO.findAllContacts(OldEntitiesDAO.java:70)
	at com.sebulli.fakturama.migration.MigrationManager.runMigrateContactsSubTask(MigrationManager.java:872)
	at com.sebulli.fakturama.migration.MigrationManager.runMigration(MigrationManager.java:447)
	at com.sebulli.fakturama.migration.MigrationManager.access$1(MigrationManager.java:423)
	at com.sebulli.fakturama.migration.MigrationManager$1.run(MigrationManager.java:336)
	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: MANDAT_REF in statement [SELECT ID, ACCOUNT, ACCOUNT_HOLDER, BANK_CODE, BANK_NAME, BIC, BIRTHDAY, CATEGORY, CITY, COMPANY, COUNTRY, DATE_ADDED, DELETED, DELIVERY_BIRTHDAY, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY, DELIVERY_FIRSTNAME, DELIVERY_GENDER, DELIVERY_NAME, DELIVERY_STREET, DELIVERY_TITLE, DELIVERY_ZIP, DISCOUNT, EMAIL, FAX, FIRSTNAME, GENDER, IBAN, MANDAT_REF, MOBILE, NAME, NOTE, NR, PAYMENT, PHONE, RELIABILITY, STREET, SUPPLIERNUMBER, TITLE, USE_NET_GROSS, VATNR, VATNRVALID, WEBSITE, ZIP FROM CONTACTS]
Error Code: -5501
Call: SELECT ID, ACCOUNT, ACCOUNT_HOLDER, BANK_CODE, BANK_NAME, BIC, BIRTHDAY, CATEGORY, CITY, COMPANY, COUNTRY, DATE_ADDED, DELETED, DELIVERY_BIRTHDAY, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY, DELIVERY_FIRSTNAME, DELIVERY_GENDER, DELIVERY_NAME, DELIVERY_STREET, DELIVERY_TITLE, DELIVERY_ZIP, DISCOUNT, EMAIL, FAX, FIRSTNAME, GENDER, IBAN, MANDAT_REF, MOBILE, NAME, NOTE, NR, PAYMENT, PHONE, RELIABILITY, STREET, SUPPLIERNUMBER, TITLE, USE_NET_GROSS, VATNR, VATNRVALID, WEBSITE, ZIP FROM CONTACTS
Query: ReadAllQuery(referenceClass=OldContacts sql="SELECT ID, ACCOUNT, ACCOUNT_HOLDER, BANK_CODE, BANK_NAME, BIC, BIRTHDAY, CATEGORY, CITY, COMPANY, COUNTRY, DATE_ADDED, DELETED, DELIVERY_BIRTHDAY, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY, DELIVERY_FIRSTNAME, DELIVERY_GENDER, DELIVERY_NAME, DELIVERY_STREET, DELIVERY_TITLE, DELIVERY_ZIP, DISCOUNT, EMAIL, FAX, FIRSTNAME, GENDER, IBAN, MANDAT_REF, MOBILE, NAME, NOTE, NR, PAYMENT, PHONE, RELIABILITY, STREET, SUPPLIERNUMBER, TITLE, USE_NET_GROSS, VATNR, VATNRVALID, WEBSITE, ZIP FROM CONTACTS")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:688)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:564)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2093)
	at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:600)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:270)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:256)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:327)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:722)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693)
	at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:563)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1221)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1180)
	at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:464)
	at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:3346)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1892)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1874)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
	... 7 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: MANDAT_REF in statement [SELECT ID, ACCOUNT, ACCOUNT_HOLDER, BANK_CODE, BANK_NAME, BIC, BIRTHDAY, CATEGORY, CITY, COMPANY, COUNTRY, DATE_ADDED, DELETED, DELIVERY_BIRTHDAY, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY, DELIVERY_FIRSTNAME, DELIVERY_GENDER, DELIVERY_NAME, DELIVERY_STREET, DELIVERY_TITLE, DELIVERY_ZIP, DISCOUNT, EMAIL, FAX, FIRSTNAME, GENDER, IBAN, MANDAT_REF, MOBILE, NAME, NOTE, NR, PAYMENT, PHONE, RELIABILITY, STREET, SUPPLIERNUMBER, TITLE, USE_NET_GROSS, VATNR, VATNRVALID, WEBSITE, ZIP FROM CONTACTS]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1590)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1539)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:804)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:625)
	... 26 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: MANDAT_REF
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source)
	at org.hsqldb.QueryExpression.resolve(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 32 more

!ENTRY org.eclipse.e4.ui.workbench 4 0 2018-02-28 00:18:57.177
!MESSAGE error while migrating Documents; Message: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DEPOSIT in statement [SELECT ID, ADDRESS, ADDRESSFIRSTLINE, ADDRESSID, CATEGORY, CONSULTANT, CUSTOMERREF, DATE, DELETED, DELIVERYADDRESS, DEPOSIT, DUEDAYS, DUNNINGLEVEL, INVOICEID, ISDEPOSIT, ITEMS, ITEMSDISCOUNT, MESSAGE, MESSAGE2, MESSAGE3, NAME, NETGROSS, NOVAT, NOVATDESCRIPTION, NOVATNAME, ODTPATH, ORDERDATE, PAID, PAYDATE, PAYMENTDESCRIPTION, PAYMENTID, PAYMENTNAME, PAYMENTTEXT, PAYVALUE, PDFPATH, PRINTED, PRINTEDTEMPLATE, PROGRESS, SERVICEDATE, SHIPPING, SHIPPINGAUTOVAT, SHIPPINGDESCRIPTION, SHIPPINGID, SHIPPINGNAME, SHIPPINGVAT, SHIPPINGVATDESCRIPTION, TOTAL, TRANSACTION, WEBSHOPDATE, WEBSHOPID FROM Documents WHERE (DELETED = ?)]
Error Code: -5501
Call: SELECT ID, ADDRESS, ADDRESSFIRSTLINE, ADDRESSID, CATEGORY, CONSULTANT, CUSTOMERREF, DATE, DELETED, DELIVERYADDRESS, DEPOSIT, DUEDAYS, DUNNINGLEVEL, INVOICEID, ISDEPOSIT, ITEMS, ITEMSDISCOUNT, MESSAGE, MESSAGE2, MESSAGE3, NAME, NETGROSS, NOVAT, NOVATDESCRIPTION, NOVATNAME, ODTPATH, ORDERDATE, PAID, PAYDATE, PAYMENTDESCRIPTION, PAYMENTID, PAYMENTNAME, PAYMENTTEXT, PAYVALUE, PDFPATH, PRINTED, PRINTEDTEMPLATE, PROGRESS, SERVICEDATE, SHIPPING, SHIPPINGAUTOVAT, SHIPPINGDESCRIPTION, SHIPPINGID, SHIPPINGNAME, SHIPPINGVAT, SHIPPINGVATDESCRIPTION, TOTAL, TRANSACTION, WEBSHOPDATE, WEBSHOPID FROM Documents WHERE (DELETED = ?)
	bind => [1 parameter bound]
Query: ReadAllQuery(referenceClass=OldDocuments sql="SELECT ID, ADDRESS, ADDRESSFIRSTLINE, ADDRESSID, CATEGORY, CONSULTANT, CUSTOMERREF, DATE, DELETED, DELIVERYADDRESS, DEPOSIT, DUEDAYS, DUNNINGLEVEL, INVOICEID, ISDEPOSIT, ITEMS, ITEMSDISCOUNT, MESSAGE, MESSAGE2, MESSAGE3, NAME, NETGROSS, NOVAT, NOVATDESCRIPTION, NOVATNAME, ODTPATH, ORDERDATE, PAID, PAYDATE, PAYMENTDESCRIPTION, PAYMENTID, PAYMENTNAME, PAYMENTTEXT, PAYVALUE, PDFPATH, PRINTED, PRINTEDTEMPLATE, PROGRESS, SERVICEDATE, SHIPPING, SHIPPINGAUTOVAT, SHIPPINGDESCRIPTION, SHIPPINGID, SHIPPINGNAME, SHIPPINGVAT, SHIPPINGVATDESCRIPTION, TOTAL, TRANSACTION, WEBSHOPDATE, WEBSHOPID FROM Documents WHERE (DELETED = ?)")
!STACK 0
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DEPOSIT in statement [SELECT ID, ADDRESS, ADDRESSFIRSTLINE, ADDRESSID, CATEGORY, CONSULTANT, CUSTOMERREF, DATE, DELETED, DELIVERYADDRESS, DEPOSIT, DUEDAYS, DUNNINGLEVEL, INVOICEID, ISDEPOSIT, ITEMS, ITEMSDISCOUNT, MESSAGE, MESSAGE2, MESSAGE3, NAME, NETGROSS, NOVAT, NOVATDESCRIPTION, NOVATNAME, ODTPATH, ORDERDATE, PAID, PAYDATE, PAYMENTDESCRIPTION, PAYMENTID, PAYMENTNAME, PAYMENTTEXT, PAYVALUE, PDFPATH, PRINTED, PRINTEDTEMPLATE, PROGRESS, SERVICEDATE, SHIPPING, SHIPPINGAUTOVAT, SHIPPINGDESCRIPTION, SHIPPINGID, SHIPPINGNAME, SHIPPINGVAT, SHIPPINGVATDESCRIPTION, TOTAL, TRANSACTION, WEBSHOPDATE, WEBSHOPID FROM Documents WHERE (DELETED = ?)]
Error Code: -5501
Call: SELECT ID, ADDRESS, ADDRESSFIRSTLINE, ADDRESSID, CATEGORY, CONSULTANT, CUSTOMERREF, DATE, DELETED, DELIVERYADDRESS, DEPOSIT, DUEDAYS, DUNNINGLEVEL, INVOICEID, ISDEPOSIT, ITEMS, ITEMSDISCOUNT, MESSAGE, MESSAGE2, MESSAGE3, NAME, NETGROSS, NOVAT, NOVATDESCRIPTION, NOVATNAME, ODTPATH, ORDERDATE, PAID, PAYDATE, PAYMENTDESCRIPTION, PAYMENTID, PAYMENTNAME, PAYMENTTEXT, PAYVALUE, PDFPATH, PRINTED, PRINTEDTEMPLATE, PROGRESS, SERVICEDATE, SHIPPING, SHIPPINGAUTOVAT, SHIPPINGDESCRIPTION, SHIPPINGID, SHIPPINGNAME, SHIPPINGVAT, SHIPPINGVATDESCRIPTION, TOTAL, TRANSACTION, WEBSHOPDATE, WEBSHOPID FROM Documents WHERE (DELETED = ?)
	bind => [1 parameter bound]
Query: ReadAllQuery(referenceClass=OldDocuments sql="SELECT ID, ADDRESS, ADDRESSFIRSTLINE, ADDRESSID, CATEGORY, CONSULTANT, CUSTOMERREF, DATE, DELETED, DELIVERYADDRESS, DEPOSIT, DUEDAYS, DUNNINGLEVEL, INVOICEID, ISDEPOSIT, ITEMS, ITEMSDISCOUNT, MESSAGE, MESSAGE2, MESSAGE3, NAME, NETGROSS, NOVAT, NOVATDESCRIPTION, NOVATNAME, ODTPATH, ORDERDATE, PAID, PAYDATE, PAYMENTDESCRIPTION, PAYMENTID, PAYMENTNAME, PAYMENTTEXT, PAYVALUE, PDFPATH, PRINTED, PRINTEDTEMPLATE, PROGRESS, SERVICEDATE, SHIPPING, SHIPPINGAUTOVAT, SHIPPINGDESCRIPTION, SHIPPINGID, SHIPPINGNAME, SHIPPINGVAT, SHIPPINGVATDESCRIPTION, TOTAL, TRANSACTION, WEBSHOPDATE, WEBSHOPID FROM Documents WHERE (DELETED = ?)")
	at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:389)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262)
	at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:480)
	at com.sebulli.fakturama.migration.olddao.OldEntitiesDAO.findAllDocuments(OldEntitiesDAO.java:235)
	at com.sebulli.fakturama.migration.MigrationManager.runMigrateDocumentsSubTask(MigrationManager.java:586)
	at com.sebulli.fakturama.migration.MigrationManager.runMigration(MigrationManager.java:450)
	at com.sebulli.fakturama.migration.MigrationManager.access$1(MigrationManager.java:423)
	at com.sebulli.fakturama.migration.MigrationManager$1.run(MigrationManager.java:336)
	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.0.v20170811-d680af5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DEPOSIT in statement [SELECT ID, ADDRESS, ADDRESSFIRSTLINE, ADDRESSID, CATEGORY, CONSULTANT, CUSTOMERREF, DATE, DELETED, DELIVERYADDRESS, DEPOSIT, DUEDAYS, DUNNINGLEVEL, INVOICEID, ISDEPOSIT, ITEMS, ITEMSDISCOUNT, MESSAGE, MESSAGE2, MESSAGE3, NAME, NETGROSS, NOVAT, NOVATDESCRIPTION, NOVATNAME, ODTPATH, ORDERDATE, PAID, PAYDATE, PAYMENTDESCRIPTION, PAYMENTID, PAYMENTNAME, PAYMENTTEXT, PAYVALUE, PDFPATH, PRINTED, PRINTEDTEMPLATE, PROGRESS, SERVICEDATE, SHIPPING, SHIPPINGAUTOVAT, SHIPPINGDESCRIPTION, SHIPPINGID, SHIPPINGNAME, SHIPPINGVAT, SHIPPINGVATDESCRIPTION, TOTAL, TRANSACTION, WEBSHOPDATE, WEBSHOPID FROM Documents WHERE (DELETED = ?)]
Error Code: -5501
Call: SELECT ID, ADDRESS, ADDRESSFIRSTLINE, ADDRESSID, CATEGORY, CONSULTANT, CUSTOMERREF, DATE, DELETED, DELIVERYADDRESS, DEPOSIT, DUEDAYS, DUNNINGLEVEL, INVOICEID, ISDEPOSIT, ITEMS, ITEMSDISCOUNT, MESSAGE, MESSAGE2, MESSAGE3, NAME, NETGROSS, NOVAT, NOVATDESCRIPTION, NOVATNAME, ODTPATH, ORDERDATE, PAID, PAYDATE, PAYMENTDESCRIPTION, PAYMENTID, PAYMENTNAME, PAYMENTTEXT, PAYVALUE, PDFPATH, PRINTED, PRINTEDTEMPLATE, PROGRESS, SERVICEDATE, SHIPPING, SHIPPINGAUTOVAT, SHIPPINGDESCRIPTION, SHIPPINGID, SHIPPINGNAME, SHIPPINGVAT, SHIPPINGVATDESCRIPTION, TOTAL, TRANSACTION, WEBSHOPDATE, WEBSHOPID FROM Documents WHERE (DELETED = ?)
	bind => [1 parameter bound]
Query: ReadAllQuery(referenceClass=OldDocuments sql="SELECT ID, ADDRESS, ADDRESSFIRSTLINE, ADDRESSID, CATEGORY, CONSULTANT, CUSTOMERREF, DATE, DELETED, DELIVERYADDRESS, DEPOSIT, DUEDAYS, DUNNINGLEVEL, INVOICEID, ISDEPOSIT, ITEMS, ITEMSDISCOUNT, MESSAGE, MESSAGE2, MESSAGE3, NAME, NETGROSS, NOVAT, NOVATDESCRIPTION, NOVATNAME, ODTPATH, ORDERDATE, PAID, PAYDATE, PAYMENTDESCRIPTION, PAYMENTID, PAYMENTNAME, PAYMENTTEXT, PAYVALUE, PDFPATH, PRINTED, PRINTEDTEMPLATE, PROGRESS, SERVICEDATE, SHIPPING, SHIPPINGAUTOVAT, SHIPPINGDESCRIPTION, SHIPPINGID, SHIPPINGNAME, SHIPPINGVAT, SHIPPINGVATDESCRIPTION, TOTAL, TRANSACTION, WEBSHOPDATE, WEBSHOPID FROM Documents WHERE (DELETED = ?)")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:688)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:564)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2093)
	at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:600)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:270)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:256)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:327)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:722)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693)
	at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:563)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1221)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1180)
	at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:464)
	at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:3346)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1892)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1874)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
	... 7 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DEPOSIT in statement [SELECT ID, ADDRESS, ADDRESSFIRSTLINE, ADDRESSID, CATEGORY, CONSULTANT, CUSTOMERREF, DATE, DELETED, DELIVERYADDRESS, DEPOSIT, DUEDAYS, DUNNINGLEVEL, INVOICEID, ISDEPOSIT, ITEMS, ITEMSDISCOUNT, MESSAGE, MESSAGE2, MESSAGE3, NAME, NETGROSS, NOVAT, NOVATDESCRIPTION, NOVATNAME, ODTPATH, ORDERDATE, PAID, PAYDATE, PAYMENTDESCRIPTION, PAYMENTID, PAYMENTNAME, PAYMENTTEXT, PAYVALUE, PDFPATH, PRINTED, PRINTEDTEMPLATE, PROGRESS, SERVICEDATE, SHIPPING, SHIPPINGAUTOVAT, SHIPPINGDESCRIPTION, SHIPPINGID, SHIPPINGNAME, SHIPPINGVAT, SHIPPINGVATDESCRIPTION, TOTAL, TRANSACTION, WEBSHOPDATE, WEBSHOPID FROM Documents WHERE (DELETED = ?)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1590)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1539)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:804)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:625)
	... 26 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: DEPOSIT
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source)
	at org.hsqldb.QueryExpression.resolve(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 32 more

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:18:57.233
!MESSAGE beendet

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:19:04.179
!MESSAGE create Document list part

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:19:12.652
!MESSAGE beendet

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:19:19.209
!MESSAGE create Contact list part

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:19:20.676
!MESSAGE create Contact list part

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:19:21.908
!MESSAGE create Payment list part

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:19:25.653
!MESSAGE Saving NatTable state to fakturamaviews.properties

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:19:25.665
!MESSAGE Saving NatTable state to fakturamaviews.properties

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:19:25.678
!MESSAGE Saving NatTable state to fakturamaviews.properties

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-02-28 00:19:25.698
!MESSAGE Saving NatTable state to fakturamaviews.properties

Hm, sieht so aus, als ob die Datenbank nicht komplett angelegt wurde. Da fehlen paar Felder. Installierst Du in das alte Arbeitsverzeichnis?

Hallo Ralf

habe das erste mal versucht in das alte Verzeichnis zu kopieren! Mehrfach dann auch in ein Neues leider beide Varianten kein Erfolg!

lg Peter

Wie ist das zu verstehen das Du Daten kopiert hast?

Habe eine Sicherung gemacht und dann beim installieren altes und neues Verzeichnis gleich gelassen

Zum Verständnis.

Du hast das Fakturama 2.0.0.1 in das Arbeitsverzeichnis von Fakturama 1.x installiert?

Hallo ja das erste mal

dann habe ich nochmal deinstalliert rückgesichert und dann neu installiert und ein neues Verzeichnis angelegt bei beiden installationsversuchen das selbe Ergebnis keine Kunden und keine Dokumente

lg Peter

Als Du neu installiert hast in ein neues Verzeichnis. Bekamst Du den Dialog um Daten zu migrieren?

Ja wie in der Anleitung jedoch werden die Dokumente und die Kunden nicht übernommen