Benachrichtigungen

Alles entfernen

Konvertierung in neuste Version unter Mac

Hilfe bei Installation und Bedienung

Letzter Beitrag von rheydenr vor 2 Jahren

11 Beiträge

2 Benutzer

0 Reactions

536 Aufrufe

RSS

c.Pressler

(@c-pressler)

Active Member

Beigetreten: vor 2 Jahren

Beiträge: 6

Topic starter 3. Dezember 2024 23:52 [#4274]

Hallo ich möchte die Datenbank von Fakturama 2.05 auf die 2.13c bringen

Die Datenbank lief vorher unter Catalina.

Inzwischen habe ich Sonoma auf einem Rechner mit OpenJDK21U-jdk_x64_mac_hotspot_21.0.5_11 als Java Umgebung

Beim öffnen der Datenbank gebe ich die Verzeichnisse an. Die alten Datenbank wird auch erkannt.

Aber es wird lediglich eine neue Datenbank angelegt.

Ich habe es inzwischen auch mit unterschiedlichen Betriebssystemen, Versionen von Fakturama und Javaumgebungen probiert.

Auch den Database Ordner habe ich schon versucht zu ersetzen.

Mit den Tipps im Forum bin ich nicht weiter gekommen.

Ich hoffe dass mir Jemand Helfen kann.

Abei die Logs

Vielen Dank Christoph

Spoiler

Migration info log

Migration info log file for the conversion of old Fakturama data.

Start:

2024-12-03709:13:33.39106

* Workspace path:

/Users/xadmin/Documents/Neu

* Old workspace path:

/Users/xadmin/Documents/Alt

ori

Start converting Steuersätze (Vats)

Start converting Versandarten (Shippings)

Start converting Zahlungsbedingungen (Payments)

Start

converting

Einstellungen (Properties)

Start converting

Texte (Texts)

Start

converting

Listen (Lists)

Start

converting Ausgabebelege (Expenditures)

Start

converting

Einnahmebelege (Receiptvouchers)

Start converting Kontakte (Contacts)

Start

converting

Produkte (Products)

Start converting

Dokumente (Documents)

* End:

2024-12-03T09:13

60110

Spoiler

Logfile

!SESSION 2024-12-03 09:13:11.182 -----------------------------------------------

eclipse.buildId=2.1.3.202304210827

java.version=21.0.5

java.vendor=Eclipse Adoptium

BootLoader constants: OS=macosx, ARCH=x86_64, WS=cocoa, NL=de_DE

Framework arguments: -keyring entfernter Link

Command-line arguments: -os macosx -ws cocoa -arch x86_64 -keyring entfernter Link

!ENTRY com.sebulli.fakturama.common 4 0 2024-12-03 09:13:33.851

!MESSAGE error while migrating Vats; Message: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: VATS in statement [SELECT COUNT(ID) FROM Vats]

Error Code: -5501

Call: SELECT COUNT(ID) FROM Vats

Query: ReportQuery(referenceClass=OldVats sql="SELECT COUNT(ID) FROM Vats")

!STACK 0

javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: VATS in statement [SELECT COUNT(ID) FROM Vats]

Error Code: -5501

Call: SELECT COUNT(ID) FROM Vats

Query: ReportQuery(referenceClass=OldVats sql="SELECT COUNT(ID) FROM Vats")

at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:391)

at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:264)

at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:530)

at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:404)

at com.sebulli.fakturama.migration.olddao.OldEntitiesDAO.countAllVats(OldEntitiesDAO.java:160)

at com.sebulli.fakturama.migration.MigrationManager.runMigrateVatsSubTask(MigrationManager.java:1321)

at com.sebulli.fakturama.migration.MigrationManager.runMigration(MigrationManager.java:445)

at com.sebulli.fakturama.migration.MigrationManager$1.run(MigrationManager.java:345)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: VATS in statement [SELECT COUNT(ID) FROM Vats]

Error Code: -5501

Call: SELECT COUNT(ID) FROM Vats

Query: ReportQuery(referenceClass=OldVats sql="SELECT COUNT(ID) FROM Vats")

at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342)

at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:691)

at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)

at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2105)

at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:603)

at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:277)

at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:263)

at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:334)

at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:746)

at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2776)

at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2713)

at org.eclipse.persistence.queries.ReportQuery.executeDatabaseQuery(ReportQuery.java:894)

at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911)

at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1191)

at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:485)

at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:3367)

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1898)

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1880)

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845)

at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262)

... 7 more

Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: VATS in statement [SELECT COUNT(ID) FROM Vats]

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:1600)

at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1549)

at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:806)

at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:628)

... 25 more

Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: VATS

at org.hsqldb.error.Error.error(Unknown Source)

at org.hsqldb.ParserDQL.readTableName(Unknown Source)

at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)

at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)

at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)

at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)

at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)

at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)

at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)

at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)

at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)

at org.hsqldb.ParserDQL.XreadQueryExpression(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 com.sebulli.fakturama.common 4 0 2024-12-03 09:13:33.858

!MESSAGE error while migrating Shippings; Message: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: SHIPPINGS in statement [SELECT COUNT(ID) FROM Shippings]

Error Code: -5501

Call: SELECT COUNT(ID) FROM Shippings

Query: ReportQuery(referenceClass=OldShippings sql="SELECT COUNT(ID) FROM Shippings")

!STACK 0

javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: SHIPPINGS in statement [SELECT COUNT(ID) FROM Shippings]

Error Code: -5501

Call: SELECT COUNT(ID) FROM Shippings

Query: ReportQuery(referenceClass=OldShippings sql="SELECT COUNT(ID) FROM Shippings")

at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:391)

at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:264)

at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:530)

at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:404)

at com.sebulli.fakturama.migration.olddao.OldEntitiesDAO.countAllShippings(OldEntitiesDAO.java:135)

at com.sebulli.fakturama.migration.MigrationManager.runMigrateShippingsSubTask(MigrationManager.java:1359)

at com.sebulli.fakturama.migration.MigrationManager.runMigration(MigrationManager.java:442)