I have an app that uses ucanaccess and it has been running great for some
time now. As recently as July 14th without any issue, then the other day I
tried to use it again and I got some errors and the only thing I can think
of is a recent windows update has caused some incompatibility. I typically
only use this app on a weekly basis.
I am just an end user so I am not able to provide anymore detail.
This happens when I press a button in my app to try and view available
tables in the mdb.
============================
openjdk version "11.0.4" 2019-07-16
OpenJDK Runtime Environment AdoptOpenJDK (build 11.0.4+11)
OpenJDK 64-Bit Server VM AdoptOpenJDK (build 11.0.4+11, mixed mode)
LOGGER LOADED
Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException:
net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.x.x Looking for
usage map at page 30003, but page type is 1
at com.zenmasta.etl.db.BacDB.connect(BacDB.java:31)
at com.zenmasta.ui.BacWindow.onBrowseTableClick(BacWindow.java:375)
at com.zenmasta.ui.BacWindow$5.actionPerformed(BacWindow.java:249)
at
java.desktop/javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at
java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(Unknown
Source)
at
java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(Unknown
Source)
at java.desktop/javax.swing.DefaultButtonModel.setPressed(Unknown
Source)
at
java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown
Source)
at java.desktop/java.awt.Component.processMouseEvent(Unknown Source)
at java.desktop/javax.swing.JComponent.processMouseEvent(Unknown
Source)
at java.desktop/java.awt.Component.processEvent(Unknown Source)
at java.desktop/java.awt.Container.processEvent(Unknown Source)
at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
at
java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Unknown
Source)
at
java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Unknown
Source)
at
java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Window.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown
Source)
at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Native
Method)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown
Source)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown
Source)
at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Native
Method)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown
Source)
at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
at
java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source)
at
java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source)
at
java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown
Source)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown
Source)
at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
Caused by: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.x.x
Looking for usage map at page 30003, but page type is 1
at
net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:231)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at
com.zenmasta.util.db.DbAccessViaUCanAccess.getConnection(DbAccessViaUCanAccess.java:25)
at com.zenmasta.etl.db.BacDB.connect(BacDB.java:15)
... 37 more
Caused by: java.io.IOException: Looking for usage map at page 30003, but
page type is 1
at
com.healthmarketscience.jackcess.impl.UsageMap$ReferenceHandler.<init>(UsageMap.java:735)
at
com.healthmarketscience.jackcess.impl.UsageMap$ReferenceHandler.<init>(UsageMap.java:709)
at
com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:147)
at
com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:136)
at
com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:107)
at
com.healthmarketscience.jackcess.impl.TableImpl.<init>(TableImpl.java:253)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.readTable(DatabaseImpl.java:1676)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.readSystemCatalog(DatabaseImpl.java:857)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:534)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:401)
at
com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:252)
at
net.ucanaccess.jdbc.DefaultJackcessOpener.open(DefaultJackcessOpener.java:35)
at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:169)
at
net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:51)
at
net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:90)
... 41 more
============================</init></init></init></init></init>
This happens when I try to "import" using the last used table.
============================
2020-07-22 09:51:01 [SEVERE] Failed to import data
java.lang.RuntimeException: net.ucanaccess.jdbc.UcanaccessSQLException:
UCAExc:::4.x.x Looking for usage map at page 30003, but page type is 1
at com.zenmasta.etl.db.BacDB.connect(BacDB.java:31)
at com.zenmasta.etl.db.BacDbWriter.importData(BacDbWriter.java:32)
at com.zenmasta.ui.BacWindow$8$1.run(BacWindow.java:304)
Caused by: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.x.x
Looking for usage map at page 30003, but page type is 1
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:231)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at
com.zenmasta.util.db.DbAccessViaUCanAccess.getConnection(DbAccessViaUCanAccess.java:25)
at com.zenmasta.etl.db.BacDB.connect(BacDB.java:15)
... 2 more
Caused by: java.io.IOException: Looking for usage map at page 30003, but
page type is 1
at
com.healthmarketscience.jackcess.impl.UsageMap$ReferenceHandler.<init>(UsageMap.java:735)
at
com.healthmarketscience.jackcess.impl.UsageMap$ReferenceHandler.<init>(UsageMap.java:709)
at
com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:147)
at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:136)
at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:107)
at
com.healthmarketscience.jackcess.impl.TableImpl.<init>(TableImpl.java:253)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.readTable(DatabaseImpl.java:1676)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.readSystemCatalog(DatabaseImpl.java:857)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:534)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:401)
at
com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:252)
at
net.ucanaccess.jdbc.DefaultJackcessOpener.open(DefaultJackcessOpener.java:35)
at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:169)
at
net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:51)
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:90)
============================</init></init></init></init></init>
I have an app that uses ucanaccess and it has been running great for some
time now. As recently as July 14th without any issue, then the other day I
tried to use it again and I got some errors and the only thing I can think
of is a recent windows update has caused some incompatibility. I typically
only use this app on a weekly basis.
I am just an end user so I am not able to provide anymore detail.
This happens when I press a button in my app to try and view available
tables in the mdb.
============================
openjdk version "11.0.4" 2019-07-16
OpenJDK Runtime Environment AdoptOpenJDK (build 11.0.4+11)
OpenJDK 64-Bit Server VM AdoptOpenJDK (build 11.0.4+11, mixed mode)
LOGGER LOADED
Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException:
net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.x.x Looking for
usage map at page 30003, but page type is 1
at com.zenmasta.etl.db.BacDB.connect(BacDB.java:31)
at com.zenmasta.ui.BacWindow.onBrowseTableClick(BacWindow.java:375)
at com.zenmasta.ui.BacWindow$5.actionPerformed(BacWindow.java:249)
at
java.desktop/javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at
java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(Unknown
Source)
at
java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(Unknown
Source)
at java.desktop/javax.swing.DefaultButtonModel.setPressed(Unknown
Source)
at
java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown
Source)
at java.desktop/java.awt.Component.processMouseEvent(Unknown Source)
at java.desktop/javax.swing.JComponent.processMouseEvent(Unknown
Source)
at java.desktop/java.awt.Component.processEvent(Unknown Source)
at java.desktop/java.awt.Container.processEvent(Unknown Source)
at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
at
java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Unknown
Source)
at
java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Unknown
Source)
at
java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Window.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown
Source)
at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Native
Method)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown
Source)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown
Source)
at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Native
Method)
at
java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown
Source)
at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
at
java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source)
at
java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source)
at
java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown
Source)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown
Source)
at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
Caused by: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.x.x
Looking for usage map at page 30003, but page type is 1
at
net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:231)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at
com.zenmasta.util.db.DbAccessViaUCanAccess.getConnection(DbAccessViaUCanAccess.java:25)
at com.zenmasta.etl.db.BacDB.connect(BacDB.java:15)
... 37 more
Caused by: java.io.IOException: Looking for usage map at page 30003, but
page type is 1
at
com.healthmarketscience.jackcess.impl.UsageMap$ReferenceHandler.<init>(UsageMap.java:735)
at
com.healthmarketscience.jackcess.impl.UsageMap$ReferenceHandler.<init>(UsageMap.java:709)
at
com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:147)
at
com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:136)
at
com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:107)
at
com.healthmarketscience.jackcess.impl.TableImpl.<init>(TableImpl.java:253)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.readTable(DatabaseImpl.java:1676)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.readSystemCatalog(DatabaseImpl.java:857)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:534)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:401)
at
com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:252)
at
net.ucanaccess.jdbc.DefaultJackcessOpener.open(DefaultJackcessOpener.java:35)
at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:169)
at
net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:51)
at
net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:90)
... 41 more
============================</init></init></init></init></init>
This happens when I try to "import" using the last used table.
============================
2020-07-22 09:51:01 [SEVERE] Failed to import data
java.lang.RuntimeException: net.ucanaccess.jdbc.UcanaccessSQLException:
UCAExc:::4.x.x Looking for usage map at page 30003, but page type is 1
at com.zenmasta.etl.db.BacDB.connect(BacDB.java:31)
at com.zenmasta.etl.db.BacDbWriter.importData(BacDbWriter.java:32)
at com.zenmasta.ui.BacWindow$8$1.run(BacWindow.java:304)
Caused by: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.x.x
Looking for usage map at page 30003, but page type is 1
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:231)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at
com.zenmasta.util.db.DbAccessViaUCanAccess.getConnection(DbAccessViaUCanAccess.java:25)
at com.zenmasta.etl.db.BacDB.connect(BacDB.java:15)
... 2 more
Caused by: java.io.IOException: Looking for usage map at page 30003, but
page type is 1
at
com.healthmarketscience.jackcess.impl.UsageMap$ReferenceHandler.<init>(UsageMap.java:735)
at
com.healthmarketscience.jackcess.impl.UsageMap$ReferenceHandler.<init>(UsageMap.java:709)
at
com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:147)
at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:136)
at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:107)
at
com.healthmarketscience.jackcess.impl.TableImpl.<init>(TableImpl.java:253)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.readTable(DatabaseImpl.java:1676)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.readSystemCatalog(DatabaseImpl.java:857)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:534)
at
com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:401)
at
com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:252)
at
net.ucanaccess.jdbc.DefaultJackcessOpener.open(DefaultJackcessOpener.java:35)
at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:169)
at
net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:51)
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:90)
============================</init></init></init></init></init>
Changing our app to use ucanaccess 5.0 resolved the issue.