Generate Master Plan process fails during export

1. Open a command prompt
2. Type: sqlldr to test if it works
3. Check $Oracle_home\bin to see, if sqlldr and relevant .dll files are present
4. Add a new sqlldr file if missing or corrupted

Error captured in the node log:

ERROR [PLANARRIV] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for PLANARRIV with exitcode: 255 [run:197 {}] 
ERROR [CUSTORDERSTATUS] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for CUSTORDERSTATUS with exitcode: 255 [run:197 {}] 
ERROR [INVENTORY] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for INVENTORY with exitcode: 255 [run:197 {}] 
ERROR [STOCKORDER] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for STOCKORDER with exitcode: 255 [run:197 {}] 
ERROR [PLANORDER] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for PLANORDER with exitcode: 255 [run:197 {}] 
ERROR [EXCEPTIONORDERRELATION] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for EXCEPTIONORDERRELATION with exitcode: 255 [run:197 {}] 
ERROR [SKUEXCEPTION] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for SKUEXCEPTION with exitcode: 255 [run:197 {}] 
ERROR [FCSTORDERSTATUS] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for FCSTORDERSTATUS with exitcode: 255 [run:197 {}] 
ERROR [DEPDMDSTATIC] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for DEPDMDSTATIC with exitcode: 255 [run:197 {}] 
ERROR [PLANPURCH] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for PLANPURCH with exitcode: 255 [run:197 {}] 
ERROR [ORDERLINK] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for ORDERLINK with exitcode: 255 [run:197 {}] 
ERROR [RESEXCEPTION] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for RESEXCEPTION with exitcode: 255 [run:197 {}] 
ERROR [PLANPROXYINVENTORY] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for PLANPROXYINVENTORY with exitcode: 255 [run:197 {}] 
ERROR [RESLOADINDDMDLINK] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for RESLOADINDDMDLINK with exitcode: 255 [run:197 {}] 
ERROR [RESLOADDETAIL] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for RESLOADDETAIL with exitcode: 255 [run:197 {}] 
ERROR [INDDMDLINK] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for INDDMDLINK with exitcode: 255 [run:197 {}] 
ERROR [STOCKORDERSTATUS] com.manu.scpoweb.esp.masterplan.publisher.Publisher Publishing failed for STOCKORDERSTATUS with exitcode: 255 [run:197 {}] 
ERROR [main] com.manu.scpoweb.esp.masterplan.publisher.Publisher Error occured while publishing [publish:101 {}] 
ERROR [main] com.manu.scpoweb.esp.masterplan.process.MasterPlanProcess error:  [publish:1917 {}] 
com.manu.webservices.common.ManuRuntimeException: Error occured while publishing
    at com.manu.scpoweb.esp.masterplan.publisher.Publisher.publish(Publisher.java:102) ~[esp.jar:?]
    at com.manu.scpoweb.esp.masterplan.process.MasterPlanProcess.publish(MasterPlanProcess.java:1910) [esp.jar:?]
    at com.manu.scpoweb.esp.masterplan.process.MasterPlanProcess.run(MasterPlanProcess.java:361) [esp.jar:?]
    at com.manu.scpoweb.esp.masterplan.process.MasterPlanNode.processAction(MasterPlanNode.java:231) [esp.jar:?]
    at com.manu.webservices.sre.nodes.Node.run(Node.java:301) [webworks.jar:?]
    at com.manu.webservices.sre.nodes.NodeDaemon.main(NodeDaemon.java:225) [webworks.jar:?]
ERROR [main] com.manu.webservices.sre.nodes.Node Caught unexpected exception [traceException:439 {}] 
com.manu.webservices.common.ManuRuntimeException: Error occured while publishing

 

sqlldr is missing from the server or it is corrupted

When ESP starts publishing / loading the data to database,  it needs to call sqlldr to load flat files