Menu

compatibility issue with recent windows update?

Help
ZenMasta
2020-07-23
2022-01-25
  • ZenMasta

    ZenMasta - 2020-07-23

    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>

     
  • ZenMasta

    ZenMasta - 2020-08-06

    Changing our app to use ucanaccess 5.0 resolved the issue.

     

Log in to post a comment.