Error while connected to an AccessDB -> UcanaccessSQLException

Anonymous — Sat, 16 Nov 2024 07:59:14 GMT

Hello guys,

I have a problem while trying to connect via tAccessConnection: "Looking for usage map at page xxxxx, but page type is 0". It's not possible accessing the access db-tables.

what does it mean?

I'm using Talend Big Data 6.4

Thank you in forward

Re: Error while connected to an AccessDB -> UcanaccessSQLException

Anonymous — Mon, 09 Jul 2018 09:49:39 GMT

Hello,

If you don't mind, could you please post the full error stack traceon forum?

We will appreciate it a lot if you could upload your job design screenshots on forum.

Best regards

Sabrina

Re: Error while connected to an AccessDB -> UcanaccessSQLException

Anonymous — Mon, 09 Jul 2018 09:57:23 GMT

hello Sabrina,

thank you for your Response. Here is the full error stack:

net.ucanaccess.jdbc.UcanaccessSQLException: Looking for usage map at page 17152, but page type is 0

at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:247)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:208)

at tAccessConnection_1Process(xxx.java:3133)

Caused by: java.io.IOException: Looking for usage map at page 17152, but page type is 0

at com.healthmarketscience.jackcess.impl.UsageMap$ReferenceHandler.<init>(UsageMap.java:697)

at com.healthmarketscience.jackcess.impl.UsageMap$ReferenceHandler.<init>(UsageMap.java:673)

at com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:146)

at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:136)

at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:108)

at com.healthmarketscience.jackcess.impl.TableImpl.<init>(TableImpl.java:264)

at com.healthmarketscience.jackcess.impl.DatabaseImpl.readTable(DatabaseImpl.java:1491)

at com.healthmarketscience.jackcess.impl.DatabaseImpl.readSystemCatalog(DatabaseImpl.java:820)

at com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:514)

at com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:386)

at com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:248)

at org.talend.ucanaccess.encrypt.CryptCodecOpener.open(CryptCodecOpener.java:18)

at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:158)

at net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:57)

at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:103)

... 8 more

Exception in component tAccessConnection_1