BATCH_ARCHIVE_PURGE_HIST_JOB Failed in production
(Doc ID 2979435.1)
Last updated on OCTOBER 09, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]Information in this document applies to any platform.
Symptoms
BATCH_ARCHIVE_PURGE_HIST_JOB has failed on production.
ERROR
-----------------------
Command inside the korn script exceeds 4999 character limit for SQL buffer. Internally generates the error below which is not captured.
SP2-0027: Input is too long (> 4999 characters) - line ignored\nSP2-0103: Nothing in SQL buffer to run.'
Cause
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
Symptoms |
Cause |
Solution |
References |