Error while connected to an AccessDB -> UcanaccessSQLException

Five Stars

Error while connected to an AccessDB -> UcanaccessSQLException

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

 

Tags (1)
Moderator

Re: Error while connected to an AccessDB -> UcanaccessSQLException

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Error while connected to an AccessDB -> UcanaccessSQLException

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)

at

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

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

 

[statistics] disconnected

 

It's a simple tAccessConnection component, where I try to fetch the Access db from a talend Server.

 

Thank you in forward

Five Stars

Re: Error while connected to an AccessDB -> UcanaccessSQLException

is anybody there, who can answer this question?