My Oracle Support Banner

Saexpdw Batch In ReSA Is Updating Program_status In Restart Table With "ready for start" Instead Expected "completed" (Doc ID 2699373.1)

Last updated on AUGUST 14, 2020

Applies to:

Oracle Retail Sales Audit - Version 15.0.3 and later
Information in this document applies to any platform.

Goal

Why when running saexpdw batch it is updating wrong program status?

In general if execute any batch then if it completes successfully then it updates program_status to "completed" in Restart_program_status table. whereas for saexpdw batch it is updating it to "ready for start" after successful completion which is causing the batch to abort in 3rd party batch scheduler (Automic) with the error as "Abnormal restart statuses".

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.