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?
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
Hallo,
hast Du in das alte Arbeitsverzeichnis installiert?
Viele Grüße
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?
Hallo
nein in ein neues
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?
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
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?
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 ?!
Software lebt halt... 😉
Viele Grüße
Ralf.
Wichtige Infos zum Posten im Forum.
Fehler gefunden?
Hallo,
habe leider das selbe Problem. Fakturama 2 kommt absolut jungfäulich daher.