IMPORTANT ANNOUNCEMENT

These forums will be permanently set to read-only mode on July 18, 2022. From that day on, no new posting or comment will be allowed on the site, but the historical content will remain intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#58174 - 10/20/21 09:39 PM W3610: Error opening database:Catastrophic failure
Andy1974 Offline
OL Guru

Registered: 03/26/08
Posts: 126
Loc: Hong Kong
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

Top
#58175 - 10/21/21 12:07 PM Re: W3610: Error opening database:Catastrophic failure [Re: Andy1974]
MartinS Offline
OL Guru

Registered: 08/06/12
Posts: 142
Loc: Munich
seems the database connection is crashing.
What database you're connecting to?

Top
#58176 - 10/22/21 12:30 AM Re: W3610: Error opening database:Catastrophic failure [Re: Andy1974]
Andy1974 Offline
OL Guru

Registered: 03/26/08
Posts: 126
Loc: Hong Kong
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

Top
#58177 - 10/22/21 04:23 AM Re: W3610: Error opening database:Catastrophic failure [Re: Andy1974]
MartinS Offline
OL Guru

Registered: 08/06/12
Posts: 142
Loc: Munich
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.

Top
#58178 - 10/25/21 04:13 AM Re: W3610: Error opening database:Catastrophic failure [Re: MartinS]
Andy1974 Offline
OL Guru

Registered: 03/26/08
Posts: 126
Loc: Hong Kong
Hi Martin,

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

Regard,
Andy

Top