Hi everyone, I have some Access databases to read on KNIME locally, but the node just keeps on loading without even beginning to execute for an indefinite amount of time. I tried changing the location of the .accdb and also converting it to a .mdb but there’s the same issue. I also tried creating a new empty .accdb but still got the same issue. I am using the KNIME AP 5.3.0, is there any bug related to that or maybe I am missing something for the configuration. I have everything on default. Also nothing interesting pops out in the logs even at debug level, here are the only logs I am getting : 2024-10-18 15:43:31,824 : DEBUG : comm-pool-thread-11 : : NodeContainer : : : Microsoft Access Connector 4:1 has new state: CONFIGURED_MARKEDFOREXEC 2024-10-18 15:43:31,825 : DEBUG : comm-pool-thread-11 : : NodeContainer : : : Microsoft Access Connector 4:1 has new state: CONFIGURED_QUEUED 2024-10-18 15:43:31,825 : DEBUG : comm-pool-thread-11 : : NodeContainer : : : 04 - Effets MR 4 has new state: EXECUTING 2024-10-18 15:43:31,829 : DEBUG : KNIME-Worker-2-Microsoft Access Connector 4:1 : : WorkflowManager : Microsoft Access Connector : 4:1 : Microsoft Access Connector 4:1 doBeforePreExecution 2024-10-18 15:43:31,830 : DEBUG : KNIME-Worker-2-Microsoft Access Connector 4:1 : : NodeContainer : Microsoft Access Connector : 4:1 : Microsoft Access Connector 4:1 has new state: PREEXECUTE 2024-10-18 15:43:31,831 : DEBUG : KNIME-Worker-2-Microsoft Access Connector 4:1 : : WorkflowDataRepository : Microsoft Access Connector : 4:1 : Adding handler 5a8b0f2b-a034-4b2a-8cf1-dd61a12446c7 (Microsoft Access Connector 4:1: <no directory>) - 1 in total 2024-10-18 15:43:31,831 : DEBUG : KNIME-Worker-2-Microsoft Access Connector 4:1 : : WorkflowManager : Microsoft Access Connector : 4:1 : Microsoft Access Connector 4:1 doBeforeExecution 2024-10-18 15:43:31,831 : DEBUG : KNIME-Worker-2-Microsoft Access Connector 4:1 : : NodeContainer : Microsoft Access Connector : 4:1 : Microsoft Access Connector 4:1 has new state: EXECUTING 2024-10-18 15:43:31,831 : DEBUG : KNIME-Worker-2-Microsoft Access Connector 4:1 : : LocalNodeExecutionJob : Microsoft Access Connector : 4:1 : Microsoft Access Connector 4:1 Start execute 2024-10-18 15:43:31,832 : DEBUG : KNIME-Worker-2-Microsoft Access Connector 4:1 : : DBSessionCache : Microsoft Access Connector : 4:1 : New database session: DefaultDBSessionInformation(id=7f7b64a5-c386-4c20-bcad-8a8ec3c066e6, dbType=DBType(id=msaccess, name=Microsoft Access, description=null), driverDefinition=DBDriverDefinition(id=built-in-msaccess-5.0.1, name=Driver for Microsoft Access v.5.0.1, version=0.0.0, driverClass=net.ucanaccess.jdbc.UcanaccessDriver, dbType=DBType(id=msaccess, name=Microsoft Access, description=null), description=, origin=EXTENSION, deprecated=false), connectionController=org.knime.database.extension.msaccess.node.connector.MSAccessDBConnectionController=(url=jdbc:ucanaccess://C:\Users\9942991\Downloads\04 - Analyse_PCH.mdb, authenticationType=NONE), dialectId=msaccess, attributeValues={knime.db.connection.metadata.configure.enabled=false}) Thanks for anyone willing to help! Cheers, Cristian

Hello @rastasanu , the driver KNIME uses requires a lot of memory and time to open large Access files (e.g. 25 min for a 900MB file) since it copies all the data into memory during startup as described here . Can you please try to increase the memory of your Analytics Platform and move the file to a local hard drive instead of a shared drive and give the node some time to execute. Another alternative would be to reduce the size of the database file or export the data you need to a file. Regarding the stopping problem, KNIME aborts the connection process but it seems that the driver still loads the database in the background which is why the node just accepts any path and runs forever. Bye Tobias

Micrrcosoft Access Connector doesn't stop loading

KNIME Analytics Platform

izaychik63 October 22, 2024, 8:00pm 5

See if this can help you

1 Like