Datenübernahme nach...
 
Benachrichtigungen
Alles entfernen

Datenübernahme nach 2.0 hat nicht funktioniert

40 Beiträge
6 Benutzer
0 Reactions
3,769 Aufrufe
(@rheydenr)
Forum-Admin Registered
Beigetreten: vor 14 Jahren
Beiträge: 4911
 

Hallo lakaro,
hast Du beim Wiederherstellen der alten Version mal probiert, ob es damit noch funktioniert?

Bitte versuche dann nochmal die Installation in ein neues Arbeitsverzeichnis. Wenn die alten Daten nicht lesbar sind von der Anwendung kann es sein, daß nichts importiert wird.


Viele Grüße
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?


   
AntwortZitat
(@lakaro)
Active Member
Beigetreten: vor 9 Jahren
Beiträge: 10
 

Die alte Version funktioniert noch 1.6.9!

Habe jetzt fakturama 2 deinstalliert und neu installiert mit 2.0.1

Leider wieder ohne Erfolg

was mir auffällt ist das nach der Migration im neuen Arbeitsverzeichnis keine Dokumente sind!

!SESSION 2018-03-08 17:15:39.489 -----------------------------------------------
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-03-08 17:16:28.770
!MESSAGE create Document list part
!SESSION 2018-03-08 17:16:31.510 -----------------------------------------------
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-03-08 17:16:57.271
!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:270)
	at com.sebulli.fakturama.migration.MigrationManager.runMigratePaymentsSubTask(MigrationManager.java:1220)
	at com.sebulli.fakturama.migration.MigrationManager.runMigration(MigrationManager.java:454)
	at com.sebulli.fakturama.migration.MigrationManager.access$1(MigrationManager.java:424)
	at com.sebulli.fakturama.migration.MigrationManager$1.run(MigrationManager.java:337)
	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-03-08 17:16:57.284
!MESSAGE propertiesFile: C:UsersspeDocumentsFinanz_Neufakturamaviews.properties

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-03-08 17:16:57.333
!MESSAGE {fakturama.views.vatTable.BODY.columnWidth.sizes=0:39,1:33,2:12,3:16}

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-03-08 17:16:57.334
!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-03-08 17:16:57.335
!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-03-08 17:16:57.336
!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-03-08 17:16:57.337
!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-03-08 17:16:57.339
!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-03-08 17:16:57.340
!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-03-08 17:16:57.341
!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-03-08 17:16:57.342
!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-03-08 17:16:57.343
!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-03-08 17:16:57.345
!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-03-08 17:16:57.350
!MESSAGE --- old data end ----

!ENTRY org.eclipse.e4.ui.workbench 4 0 2018-03-08 17:16:59.509
!MESSAGE error while migrating Properties; Message: null
!STACK 0
java.lang.NullPointerException
	at com.sebulli.fakturama.migration.MigrationManager.runMigratePropertiesSubTask(MigrationManager.java:1403)
	at com.sebulli.fakturama.migration.MigrationManager.runMigration(MigrationManager.java:431)
	at com.sebulli.fakturama.migration.MigrationManager.access$1(MigrationManager.java:424)
	at com.sebulli.fakturama.migration.MigrationManager$1.run(MigrationManager.java:337)
	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

!ENTRY org.eclipse.e4.ui.workbench 4 0 2018-03-08 17:17:00.477
!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.getSingleResult(QueryImpl.java:528)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:402)
	at com.sebulli.fakturama.migration.olddao.OldEntitiesDAO.findAllContacts(OldEntitiesDAO.java:73)
	at com.sebulli.fakturama.migration.MigrationManager.runMigrateContactsSubTask(MigrationManager.java:890)
	at com.sebulli.fakturama.migration.MigrationManager.runMigration(MigrationManager.java:448)
	at com.sebulli.fakturama.migration.MigrationManager.access$1(MigrationManager.java:424)
	at com.sebulli.fakturama.migration.MigrationManager$1.run(MigrationManager.java:337)
	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.cursorSelectAllRows(DatasourceCallQueryMechanism.java:112)
	at org.eclipse.persistence.queries.CursoredStreamPolicy.execute(CursoredStreamPolicy.java:64)
	at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:480)
	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)
	... 8 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)
	... 25 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)
	... 31 more

!ENTRY org.eclipse.e4.ui.workbench 4 0 2018-03-08 17:17:00.852
!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.getSingleResult(QueryImpl.java:528)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:402)
	at com.sebulli.fakturama.migration.olddao.OldEntitiesDAO.findAllDocuments(OldEntitiesDAO.java:229)
	at com.sebulli.fakturama.migration.MigrationManager.runMigrateDocumentsSubTask(MigrationManager.java:595)
	at com.sebulli.fakturama.migration.MigrationManager.runMigration(MigrationManager.java:451)
	at com.sebulli.fakturama.migration.MigrationManager.access$1(MigrationManager.java:424)
	at com.sebulli.fakturama.migration.MigrationManager$1.run(MigrationManager.java:337)
	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.cursorSelectAllRows(DatasourceCallQueryMechanism.java:112)
	at org.eclipse.persistence.queries.CursoredStreamPolicy.execute(CursoredStreamPolicy.java:64)
	at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:480)
	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)
	... 8 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)
	... 25 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)
	... 31 more

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-03-08 17:17:00.965
!MESSAGE beendet

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-03-08 17:17:08.495
!MESSAGE create Document list part

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-03-08 17:17:13.128
!MESSAGE create Contact list part

!ENTRY org.eclipse.e4.ui.workbench 1 0 2018-03-08 17:17:14.279
!MESSAGE create Contact list part



   
AntwortZitat
(@rheydenr)
Forum-Admin Registered
Beigetreten: vor 14 Jahren
Beiträge: 4911
 

Hallo,
hast Du in das alte Arbeitsverzeichnis installiert?


Viele Grüße
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?


   
AntwortZitat
(@lakaro)
Active Member
Beigetreten: vor 9 Jahren
Beiträge: 10
 

Hallo
nein in ein neues



   
AntwortZitat
(@rheydenr)
Forum-Admin Registered
Beigetreten: vor 14 Jahren
Beiträge: 4911
 

Das Logfile beschwert sich aber über fehlende Tabellen aus der Version 1. Irgendwas paßt hier nicht zusammen. Gehst Du evtl. mit der alten Version auf das neue Arbeitsverzeichnis?


Viele Grüße
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?


   
AntwortZitat
(@lakaro)
Active Member
Beigetreten: vor 9 Jahren
Beiträge: 10
 

Hallo Nein das alte verweist auf das ursprüngliche Verzeichnis

habe jetzt auch nochmal ein Backup zurückgespielt wo version 2 noch nicht installiert war wieder mit dem selben Ergebnis

Verzeichnis alt : C:UsersspeDocumentsFinanz
Verzeichnis neu: C:UsersspeDocumentsFinanz_Neu



   
AntwortZitat
(@rheydenr)
Forum-Admin Registered
Beigetreten: vor 14 Jahren
Beiträge: 4911
 

Kannst Du bitte nochmal aus Deinem Beutzerverzeichnis das Verzeichnis .fakturama2 löschen und Fakturama2 nochmal starten? Vorher das neue(!) Arbeitsverzeichnis nochmal leeren.


Viele Grüße
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?


   
AntwortZitat
(@lakaro)
Active Member
Beigetreten: vor 9 Jahren
Beiträge: 10
 

So habe es jetzt nochmal versucht und siehe da es hat geklappt!

Habe das gleiche am Donnerstag Abend mehrfach versucht ohne Erfolg! habe dann ein paar Rechnungen erzeugt und heute sind alle da! Komisch

Danke für die Hilfe kann es mir jetzt aber trotzdem nicht erklären warum es jetzt geklappt hat und am Donnerstag nicht ?!



   
AntwortZitat
(@rheydenr)
Forum-Admin Registered
Beigetreten: vor 14 Jahren
Beiträge: 4911
 

Software lebt halt... 😉


Viele Grüße
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?


   
AntwortZitat
(@jbdrt)
New Member
Beigetreten: vor 13 Jahren
Beiträge: 1
 

Hallo,
habe leider das selbe Problem. Fakturama 2 kommt absolut jungfäulich daher.



   
AntwortZitat
Seite 3 / 3
Teilen: