Question

ODBC ERROR [HY001] in Workflow

Workflow Version 10

Updated January 8, 2018

asked on January 5, 2018

Hello,

I am trying to connect a via an ODBC data source in workflow that had previously worked. Nothing has changed to our knowledge but we are getting the following error when trying to test the connection.

Has anyone experienced this before?

Thanks!

ODBC Error.jpg (17.39 KB)

| Download

0 0

Replies

replied on January 8, 2018

I've seen that error before. It happened when another program or ODBC session had the text file open when Laserfiche tried to access the CSV. It was a process that originally worked, but as the customer got more business the workflow server and the accounting program that populated the CSV started 'butting heads' more and more frequently.

The only fix was to rework things so they worked from a SQL table instead of a CSV.

1 0

replied on January 8, 2018

It's not a Laserfiche error, so it's hard to say, but usually "resource exceeded" is the machine running out of memory or temp disk space. Are you trying to access a large file?

0 0

replied on January 8, 2018

Miruna,

It's only trying to access a .csv file that is not that large.

0 0

replied on January 8, 2018 • Show version history

The system CPU is spiking high to about 85-95% usage. This server hosts Workflow and the Laserfiche Server and we are only seeing Workflow services as main CPU usage. The memory usage is fine (about 35% usage)

0 0

You are not allowed to follow up in this post.

Question

Question

ODBC ERROR [HY001] in Workflow

Replies

Sign in to reply to this post.