Batch Engine Sqlldr Execution Fails In Non-Interactive User Logon Mode

(Doc ID 1308067.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version: 7.3.0 and later   [Release: 7.3.0 and later ]
Information in this document applies to any platform.

Goal

=== ODM Question ===
When the Demantra Analytical Engine executes in batch mode, the SQLLDR application does not successfully execute unless there is an interactive user logged onto the server where the analytical engine was installed.
Attempt to run the Demantra Analytical Engine in batch mode without an interactive user logged on, using Task Manager or a Windows Script File (Windows Management Instrumentation-based) to execute the Demantra Analytical Engine in the batch mode of operation. Both the script and Windows scheduled task solutions work in the MZBTEST (test) environment, whereas neither work in the MZBPRD (production) environment.
We have ensured that sqlldr is accessible from the cmd.exe application, but when an interactive user is logged onto the system, the system loads the user's shell environment, which includes loading of the environment variables (pathing information, etc). So, this isn't really a valid test of whether or not the application can locate SQLLDR.exe without an interactive user, but it does prove that the executable exists, is usable (we've tested that the application works by loading canned data into a temp table), and the application successfully loads data back into the Demantra schema while an interactive user is logged onto the server (executes the batch engine manually).

Error meesage in the EngineManager.log
06:01:29:869 Machine localhost (ID: 2) receiving branchID 3
06:07:17:898 <DMNENGS-2> 06:07:17:898 ERROR Failed to start the bulk loader process: sqlldr.exe, Error: 0x2 - The system cannot find the file specified.

How is the path to sqlldr.exe set?
Does Demantra use or can Demantra use the Windows registry to find sqlldr.exe? 

Solution

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