Retail Merchandising System (MOSC)

MOSC Banner

saexpdw unique constraint error due to multiple run

Hi,

We have saexpdw scheduled in nightly batch run and it executes successfully.

But due to some other batch issue one day the saexpdw was not executed in the nightly schedule , So we executed the same in next day morning.Then it processed the previous day's record as well as the partial records of that very day.

For example : The batch was not executed on 30-Jul-2018

So we executed the same on 31-Jul-2018 morning.Then it processed records of 30th and partial records of 31st July.

Now in SA_EXPORT_LOG table we have one record for 31st July with status 'E' and another record with 'R' for system_code ='RA'.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center