My Oracle Support Banner

SQL Loader Worker Of Memory Based Planner Aborting - Showing SQL*Loader-2026 (Doc ID 2335820.1)

Last updated on DECEMBER 05, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

12.2.5
with patch 26976609 - Cum patch #13

PROBLEM
-------------
In first plan run since upgrade to 12.2.5 with Cum patch #13 -- we are seeing error in loader worker

MSCPLD: Loader Worker With Direct Load Option
Parent Program Name: MSONWL64
This IS part of a Plan run.
Check the revised columns in MSC.MSC_DEMANDS:
  order_number#1 order_number
Selecting REVISED COULMNS 1 0:00
Username:SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
....
One or more indexes on table MSC.DEMANDS1472 are invalid. Please check the SQL*loader error and take corrective action.

STEPS
--------
Run ASCP plan after upgrade

BUSINESS IMPACT
----------------------
cannot continue testing ASCP plans after upgrade

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


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