Planning ODS Load Takes A Long Time In MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT
Last updated on MAY 14, 2018
Applies to:Oracle Advanced Supply Chain Planning - Version 12.2.1 and later
Information in this document applies to any platform.
ODS load fails randomly.
ODS load log reports:
user defined exception.
ODS load worker logs report "timeout" as follows:
10-OCT 16:04:52 : Waiting for task to arrive
10-OCT 16:58:34 : IS_MONITOR_STATUS_RUNNING
10-OCT 16:58:34 : Concurrent Message : Timeout error.
10-OCT 16:58:34 : There is an Unknown Error in the Worker.
10-OCT 16:58:34 : Planning ODS Load process failed.
After we increased the timeout parameter for the ODS Load and resolved timeout error, we noticed that log file showed long time in MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT
There is not direct message but timestamps shows this taking over 45 mins to complete.
Main ODS Load Log file shows
20-OCT 23:42:47 : exchange part:-ALTER TABLE MSC_REGIONS EXCHANGE PARTITION REGIONS__1 WITH TABLE REGIONS_BEB INCLUDING INDEXES
20-OCT 23:42:50 : Calling Linking of Sales Order for 11i source ...
20-OCT 23:42:50 : Procedure MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT started.
21-OCT 00:33:24 : .. In procedure GET_START_END_OP ..
Procedure LOAD_SOURCING_HISTORY started.
,7 minutes elapsed.
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