Datenübernahme nach 2.0 hat nicht funktioniert

geschrieben von Hertmond 
Willkommen! Anmelden Ein neues Profil erzeugen Suche
Re: Datenübernahme nach 2.0 hat nicht funktioniert
06. März 2018 21:47
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.
Re: Datenübernahme nach 2.0 hat nicht funktioniert
08. März 2018 17:21
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"winking smiley
!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"winking smiley
	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"winking smiley
	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.<init>(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:\Users\spe\Documents\Finanz_Neu\fakturamaviews.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"winking smiley
!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"winking smiley
	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"winking smiley
	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.<init>(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 = ?)"winking smiley
!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 = ?)"winking smiley
	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 = ?)"winking smiley
	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.<init>(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

Re: Datenübernahme nach 2.0 hat nicht funktioniert
08. März 2018 20:37
Hallo,
hast Du in das alte Arbeitsverzeichnis installiert?

Viele Grüße,
Ralf.
Re: Datenübernahme nach 2.0 hat nicht funktioniert
10. März 2018 08:43
Hallo
nein in ein neues
Re: Datenübernahme nach 2.0 hat nicht funktioniert
10. März 2018 18:28
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.
Re: Datenübernahme nach 2.0 hat nicht funktioniert
12. März 2018 13:12
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:\Users\spe\Documents\Finanz
Verzeichnis neu: C:\Users\spe\Documents\Finanz_Neu
Re: Datenübernahme nach 2.0 hat nicht funktioniert
15. März 2018 23:02
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.
Re: Datenübernahme nach 2.0 hat nicht funktioniert
17. März 2018 00:54
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 ?!
Re: Datenübernahme nach 2.0 hat nicht funktioniert
17. März 2018 20:37
Software lebt halt... ;-)

Viele Grüße,
Ralf.
Re: Datenübernahme nach 2.0 hat nicht funktioniert
21. März 2018 11:18
Hallo,
habe leider das selbe Problem. Fakturama 2 kommt absolut jungfäulich daher.
In diesem Forum dürfen leider nur registrierte Teilnehmer schreiben.

Klicke hier, um Dich einzuloggen