APAR status
Closed as program error.
Error description
During a DSA replication, if many actions are replicated, the insertion into the related DB tables can take a very long time and get always interrupted, thus making the replication always fail. The most common symptom of this problem is a sequence of multiple log entries, in the FillDB verbose log, starting with the following sequence of strings: merge into ACTIONS as a using (values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) merge into ACTION_PARAMETERS as ap using (values(?,?,?)) merge into ACTION_TARGET_STATIC as ats using (values(?,?)) followed by a log entry like: Replication was interrupted to process local server database insertions This means that the replication of the actions was taking too much time and was thus interrupted to process new reports sent by the end points. Because the replication of the actions restarts every time from the beginning, very likely it will beinterrupted at every run, thus never completing.
Local fix
na
Problem summary
Fixed in IBM BigFix 9.5 (fixpack 13) General availability end of Q2 2019 (release schedule subject to change).
Problem conclusion
This is resolved in: IBM BigFix 9.5 (fixpack 13)
Temporary fix
Comments
APAR Information
APAR number
IJ05097
Reported component name
TIV EP MG PLTFM
Reported component ID
5725C43PO
Reported release
95W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-03-21
Closed date
2019-04-16
Last modified date
2019-04-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TIV EP MGR SERV
Fixed component ID
5725C43SV
Applicable component levels
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SSBQVS","label":"Tivoli Endpoint Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"95W","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
16 April 2019