Retail Point-of-Service Solutions (MOSC)

MOSC Banner

SQL Exception while Purging Xcenter

edited Apr 25, 2022 5:25PM in Retail Point-of-Service Solutions (MOSC) 2 commentsAnswered

Hi,

We're on Xcenter v17.0.1, when we are run datapurger.bat in dataloader folder of the Xcenter AppServer, we are receiving below mentioned error in the log in-between purging the tables. The purge gets resumed after the error and all the configured purge tables are getting purged successfully, but what is the cause of this error in the logs?

The purge is only enabled for INV tables and the error in the log is from table ctl_service_retry_queue of REPQUEUE database. Why is purge even touching the REPQUEUE database?


INFO 2022-04-19 07:07:58,842      [1 @ 97 ms]: purge sucessful [10::inv_count_sheet_lineitm <inv_count.child>] 

Tagged:

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center