Loader Worker With Direct Load Option Failing With Error - MSCSLD : Error in main 103 : table_name_str 21 (Doc ID 1643883.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2 version, Memory Based Planner

When attempting to launch ASCP plan loader worker is failing with:

ERROR
MSCSLD : Error in main 103 : table_name_str 21
APP-FND-01630: Cannot open file /apps/applmgr/r122/fs2/inst/apps/eraps6d_cl0662/appltmp/OFxo05sj.t for reading

Action: Verify that the filename is correct and that the environment variables controlling that filename are correct.

KEY POINTER IS IN TRACE FILE

=====================
PARSE ERROR #140736758592896:len=201 dep=2 uid=80 oct=1 lid=80
tim=1389179221796655 err=903
CREATE TABLE 21 TABLESPACE APPS_TS_TX_DATA STORAGE( INITIAL 102400 NEXT
10485760 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0) PCTFREE 10
INITRANS 10 MAXTRANS 255 AS SELECT * FROM  WHERE NULL=NULL              <<<< TABLE NAME MISSING CAUSES ORA-00903 i.e. ERR=903
EXEC
#139659226350040:c=0,e=283,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=0,tim=1389179221796769
ERROR #139659226350040:err=903 tim=1389179221796788
CLOSE #139659226350040:c=0,e=8,dep=1,type=0,tim=1389179221796826
EXEC
#139659226106024:c=11998,e=11657,p=0,cr=238,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1389179221796899
ERROR #139659226106024:err=903 tim=1389179221796930


STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility : Advanced supply chain planner
2. Navigation : Supply chain planning > Launch
3. Loader worker fails with error

BUSINESS IMPACT
The issue has the following business impact:
Unable to complete the ASCP plan

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms