SCA stuck 'In Process' while archiving even if it is responding. (4301111)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SCA stuck 'In Process' while archiving even if it is responding.
Description

Sometimes even the SCA started and responding, but the archive stuck 'In Process'. The server.log shows repeated errors like below:
- [0] object(s), is client done writing = [N]
Cause

Some processes were pending and not able to be processed.
Resolution

Solution:
1. SELECT * FROM merc_psobj_event WHERE SD_CD = '<Service Domain>'
2. From a sqlplus or Toad version, do the following update:
update MERC_PSOBJ_EVENT set DONE_WRITING_EVENT = 'Y' where SD_CD = '<Service Domain>'
UPDATE MERC_PSOBJ_EVENT SET PROCESS_STATUS=2
WHERE PROCESS_STATUS <> 2 AND SD_CD = '<Service Domain>' AND CSR_ID = <CSR#>;
update merc_ps_swat_event set process_status = 2 where process_status <> 2 and SD_CD = '<Service Domain>' AND CSR_ID = <CSR#>;
3. Bounce the SCA after deleting the cache directories (data, log, and tmp).
4. Try to create the CSR from the Web again to reproduce the error. If yes, upload a new server.log

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title