Database error, AlertCacheItem

[Mgiacome]

Hi all

suddenly my Wincc OA project cannot start cause some errors

This one is from the Database Manager
SEVERE, 69, Database error, AlertCacheItem, loadText, Code :0

This one from NextGen Archiver
PVSS00<manager> (0), 2012.05.31 14:22:11.667, SYS, SEVERE, 39, Connection lost, Send buffer limit exceeded, closing connection to (SYS: 1 Driver -num 1 CONN: 1) @ PVSSRDB1, [PeerItcIOHandler::sendCall]

I'v tried this

https://www.winccoa.com/knowledge-base/ ... e1084bf872

But still cannot make it work

[Mgiacome]

Update:

after 10 minutes and 3/4 restarts, the project did start succesfully with all managers green, BUT in the log console there are many errors and warnings as

Code: Select all

(Type: 325 Sys: 1 Dp: 19017 El: 17 : _alert_hdl.._partner_alert_id) AlertTime: 2024.12.11;07:12:53:172 Count: 0, has more than 500 matching alerts 

and

Code: Select all

WCCILdata    (0), 2024.12.11 08:21:32.744, SYS,  SEVERE,     69, Database error, AlertCacheItem, flush, Code :101

[Mgiacome]

UPDATE2: sometimes the following error shows up:

Code: Select all

WCCILdata - SYS/SEVERE - Database error, DataManTask, dbError, RAIMA Database Error *** Code:-909 file record limit exceeded

I'm trying to handle it with the following instructions

https://www.winccoa.com/knowledge-base ... 9e6efe2ccf

[leoknipp]

When looking at the the log message you always must have a look which manager is writing the log entry.
E.g. the entry "(Type: 325 Sys: 1 Dp: 19017 El: 17 : _alert_hdl.._partner_alert_id) AlertTime: 2024.12.11;07:12:53:172 Count: 0, has more than 500 matching alerts" is written by the Event Manager.
Please check why there are so many pending alerts for a single DP element. Possibly you are using multi instance alerts and there is no functionality implemented in your project which deletes old alerts.

In the Knowledge Base you will find additional information for this log message.

Best Regards
Leopold Knipp
Senior Support Specialist