W3610: Error opening database:Catastrophic failure

Posted by: Andy1974

W3610: Error opening database:Catastrophic failure - 10/20/21 09:39 PM

Hello everyone,

Does anyone know why the following error occurs in my workflow?

ERROR: W3610 : Error opening database: Catastrophic failure
ERROR: PlanetPress Database: W1603 : Plugin failed

This error occurs irregularly. When this error occurs, the email database cannot be read and the workflow will stop.

Now my temporary solution is to restart the server. After the server restarts, run this workflow again, and no error will occur at this time.

However, after somehow, this error may happen again.

My planetpress runs under VM, and the operating system is windows server 2016 64bit. Planetpress version is 7.6.2.9999

Can anyone give me advice or suggestions to solve my problem?

My working flow
===============
Folder Capture
|
Change Emulation(ASCII)
|
Set Job Infos and Variables
|
|-----------|
| Planetpress Database
| |
| Change Emulation(Database)
| |
| Set Job Infos and Variables
| |
| Delete
|
|-----------|
| |
| Change Emulation(ASCII)
| |
| Digital Action
| |
| Send Email
|
Delete


Many thanks.

Regards,
Andy
Posted by: MartinS

Re: W3610: Error opening database:Catastrophic failure - 10/21/21 12:07 PM

seems the database connection is crashing.
What database you're connecting to?
Posted by: Andy1974

Re: W3610: Error opening database:Catastrophic failure - 10/22/21 12:30 AM

Hello Martins,

My database is created by Microsoft Access, this access database is already started to use in few years ago.

There is a ODBC system DSN to connect this access database.

This "Error opening database:Catastrophic failure" happen irregularly.

Now, when this error occur, my temporary solution is restarted the server.

However, I really want to know why this error
"Error opening database:Catastrophic failure" occur and how can I solve this problem.

Any idea of my problem ?

Many thanks!

Regards,
Andy
Posted by: MartinS

Re: W3610: Error opening database:Catastrophic failure - 10/22/21 04:23 AM

there's not enough information about this error yet to get to the source of the issue.

It may be just an instability of the database driver, which crashes when called too often in a short time.
You should check the Windows event log if there are corresponding messages.

You may also analyse the watch and messenger logs (best after you've increased the logs to the highest level), and try to find out if there's any rule behind that (e.g. big data, calling the database very frequently, …).

And as it may be an issue with the database driver itself, it could be worth to consider an update of the driver.
Posted by: Andy1974

Re: W3610: Error opening database:Catastrophic failure - 10/25/21 04:13 AM

Hi Martin,

Many thanks your reply. I'll try to do it.

Regard,
Andy