戻る
-
タイトル
SCA stuck 'In Process' while archiving even if it is responding. -
説明
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]
-
原因
Some processes were pending and not able to be processed. -
対策
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=2WHERE 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