Known issue:
Some customer reported Gateway Reconciliation job is stuck in processing and never ends.
From the above screenshot, we can see the Gateway Reconciliation job GR-00000576 is in pending status and it processed the file wx1.000000706020160627.010212.xml.gz. Later job GR-00000578 processed the same file and it is executed on 07/06/2016 03:45:02 PDT which is not the scheduled execution time to start the GR job.
Root cause of the problem:
The prior job stuck at 'processing' status is caused by Zuora server instance got restarted while doing product deployment.
Status:
Engineer team is planning to enhance the logging and framework of the gateway reconciliation jobs to generate more log for analysis and prevent GR jobs is impacted by the product deployment.
So if any two GR jobs processing the same file, first job is in processing status and second one is in completed status, we can consider the jobs are processed successfully and all objects in the file were processed. Since every GR job is processing the file completely instead of partially .
Reference Number: PAY-7721
Should you find the Payment Gateway Reconciliation job stuck in Processing status for a prolonged period without retry, please follow below steps -
1.Take the Reconciliation job ID as below
2.Enter below URL in a new window
https://www.zuora.com/apps/Reconciliation.do?method=ajaxChangeJobStatus&id={insert your own job id}
3.Replace with the job ID taken from Step 1
4.Enter
5.This resets the job status to failed
6.Retry the failed job again
