IM message log shows only Audits, process events are no longer available. Pls check log " Event message lost"
After many tries, creating new MsgLogs and delete the old ones, just to correct the configuration that was not acc. the manuals and also verifying the Oracle DataBase free spaces.I deleted the Data Base using the hsDBmaint and create again.
But we always get the same result. The process events is not present. Does not mather if we use the Browser or the excel.
In the log file we get an alarm: (Note the last message "event message lost' that repeates again and again ...)
AEClient.cpp @ 1298 2020/07/24-18:04:59Z| PID=3420 Added 1 to Registry TimeStamp. FromHighDateTime = 30826980 ; FromLowDateTime = 1567393921 AEClient.cpp @ 1383 2020/07/24-18:04:59Z| PID=3420 From time. FromHighDateTime = 30826980 ; FromLowDateTime = 1567393921 AEClient.cpp @ 1386 2020/07/24-18:04:59Z| PID=3420 To time. ToHighDateTime = 30826980 ; ToLowDateTime = 3161925170 AEClient.cpp @ 325 2020/07/24-18:05:01Z| PID=3420 Connect to AE server completed successfully. hsEventLogCollector.cpp @ 463 2020/07/24-18:05:01Z| PID=3420 MAIN_CONNECT_MSG_APP completed successfully. hsEventLogCollector.cpp @ 565 2020/07/24-18:05:01Z| PID=3420 START SUBSCRIPTION_MSG_APP command started. AEClient.cpp @ 2005 2020/07/24-18:05:01Z| PID=3420 MSG API returned Status Error Code = 9 ; event msg lost. hsEventLogCollector.cpp @ 587 2020/07/24-18:05:01Z| PID=3420 Subscription set to active. RevisedBufferTime = 10000 RevisedMaxSize = 0 hsEventLogCollector.cpp @ 607 2020/07/24-18:05:01Z| PID=3420 START_SUBSCRIPTION_MSG_APP command done. AEClient.cpp @ 2005 2020/07/24-18:05:01Z| PID=3420 MSG API returned Status Error Code = 9 ; event msg lost. AEClient.cpp @ 2005 2020/07/24-18:05:01Z| PID=3420 MSG API returned Status Error Code = 9 ; event msg lost. AEClient.cpp @ 2005 2020/07/24-18:05:01Z| PID=3420 MSG API returned Status Error Code = 9 ; event msg lost.
See atched files.
ps.: It is pulp and paper industry with 3 complete Systems 800xA with AC400 Connect, 2 systems version 3.1 and 1 sytem version 6. All of then has the same problem.
Voted best answer
Firstly, the Events are collected from an AE server, not Basic History. Basic History collects numeric (trend) data only.
The Message Log has 12 million entries and because Audit Logging exists in the system, the INFORM_HS_RUNTIME tablespece is filling up fast. I suggest that for a 12 million entries log you may need maybe 40 Gbyte for this tablespace and a bit less for the HS_INDEXES tablespace. Since you can only up to a size of 32 Gbyte in each file implementing a tablespace (or part of a tablespace), you will need to create a second file using hsDBMaint or the Oracle Wizard.
I am still not sure why subscriptions to e.g. Process Events don’t work and there may indeed be configuration errors somewhere. Following to manual to 100% is essential to get IM to work. These errors may point to this:
“hsSysMonitor.c @ 175 | ORAERR  An OCI function call was made with an invalid
hsSysMonitor.c @ 175 | stmt = ''
hsSysMonitor.c @ 175 | OPER WARN #8 (0 0 'An OCI function call was made with an
invalid handle.' '')
hsError.c @ 482 | BS SYSTEM MESSAGE SERVICE IS NOT ACTIVE. SS = 2
hsSysMonitor.c @ 603 | There was an error checking DB Block Buffers.”
This may indicate that History and/or Oracle is not really well.
What system version are the log files from?
AEClient.cpp @ 981 2020/07/24-14:41:08Z| PID=4024 Category 12 = Soft Alarms
...suggest that the data (event) collection does not work for all categories. Audit events do look like they are successfully subscribed to, which would be why the show up in the Message Log. Maybe restart the Event and Alarm servers that the IM collects from?