Error Opening table: Microsoft Access Database Engine: System resource exceeded

Having trouble with desktop scheduler reading the .accdb files. Below error comes up. When I run the workflow manually through the designer, it works fine. I have the Microsoft Access Database Engine 2010 installed as well and hence it works fine when running through the designer.

Error Opening Table: Microsoft Access Database Engine: System resource exceeded.\3035 = -66192371

The access databases (.acdb files) are mostly 800 MB in size.

Tested the workflow in two systems. Seeing the error in both the systems. Below are the configurations of the systems.

System 1:

Intel Xenon E5@2.5GHZ (2 processors)

32.0 GB RAM

64 Bit windows

System 2

Intel Core I7 @ 1.9GHZ

32.0 GB RAM

64 Bit windows

Appreciate the help.

Schedule

Server

Scheduler

Accepted answers

All comments

patrick_mcauliffe

@pen_aa if your "Run As" user configured with your own credentials?
https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Run-As-Settings/ta-p/17830
Edit: this article references Alteryx Server, but is is the same process for Designer if you're using the scheduling function.

pen_aa

Thanks @patrick_mcauliffe for the reply.

I think it's not related to credentials as the scheduled workflow works fine in some weeks without any error.

This workflow is a weekly schedule and the .accdb files get generated weekly and hence differs in size from week to week. Last week the workflow gave that memory error whereas this week it's running fine.

Any other suggestions you might have for me?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703