This discussion is archived
1 Reply Latest reply: Aug 23, 2012 6:20 AM by 559207 RSS

OWB - Workflow- Cannot run program "/usr/bin/perl": CreateProcess error=2,

871361 Newbie
Currently Being Moderated
Hi All,

I am using OWB 11gR2 and I am getting "perl" location error after start workflow for any dimension or fact.

*Cannot run program "/usr/bin/perl": CreateProcess error=2, The system cannot find the file specified

The log is below. I am using Windows 2008 R2 OS and 11gR2 DB. The perl path is set in the environment variables and I can run the perl.exe from command line.

Why OWB is looking for the Unix base path "/usr/bin/perl": is a question for me.

If anybody knows the issue please guide me.

Thanks


OUBIWF_D_DEVICE_ACTIVITY_TYPE                                        2012-07-04 16:57:37.0     4
Parameters                                             
OUBIWF_D_DEVICE_ACTIVITY_TYPE:FILEMGR_PRE                              1          2012-07-04 16:57:38.0     2
Parameters                                             
RPE-02229: The following debug information was collected:                                             
RPE-02230: Debug Information: os.name = Windows Server 2008 R2                                             
RPE-02230: Debug Information: os.version = 6.1                                             
RPE-02230: Debug Information: os.arch = amd64                                             
RPE-02230: Debug Information: user.name = INT-A-MDM-01$                                             
RPE-02230: Debug Information: user.dir = C:\product\11.2.0\dbhome_3\owb\bin\win32                                             
RPE-02230: Debug Information: argv.arg0 = /usr/bin/perl                                             
RPE-02230: Debug Information: argv.arg1 = /spl/intbase/DB/tools/filemgr/splfilemgr.plx                                             
RPE-02230: Debug Information: argv.arg2 = -l                                             
RPE-02230: Debug Information: argv.arg3 = /spl/BIDevelopment/bi2400db                                             
RPE-02230: Debug Information: argv.arg4 = -n                                             
RPE-02230: Debug Information: argv.arg5 = D_DEVICE_ACTIVITY_TYPE_EXT.DAT                                             
RPE-02230: Debug Information: argv.arg6 = -p                                             
RPE-02230: Debug Information: argv.arg7 = 1                                             
RPE-02230: Debug Information: argv.arg8 = -s                                             
RPE-02230: Debug Information: argv.arg9 = S                                             
RPE-02230: Debug Information: argv.stdin =                                             
RPE-02230: Debug Information: USERPROFILE = C:\Windows\system32\config\systemprofile                                             
RPE-02230: Debug Information: JAVAPATH = C:\product\11.2.0\dbhome_3\jdk6                                             
RPE-02230: Debug Information: NODEID = 1                                             
RPE-02230: Debug Information: IAS_HOME = C:\product\11.2.0\dbhome_3                                             
RPE-02230: Debug Information: SystemDrive = C:                                             
RPE-02230: Debug Information: RTHOME = C:\product\11.2.0\dbhome_3                                             
RPE-02230: Debug Information: Path = C:\product\11.2.0\dbhome_3\bin;C:\product\11.2.0\dbhome_3\jdk6\jre\bin\client;C:\product\11.2.0\dbhome_3\jdk6\jre\bin;C:\product\11.2.0\dbhome_3\owb\bin\admin;C:\Windows\system32                                             
RPE-02230: Debug Information: CONNECT_SPEC = 10.34.32.136:1521:MDM                                             
RPE-02230: Debug Information: PROCESSOR_REVISION = 1a05                                             
RPE-02230: Debug Information: OCM_ORACLE_HOME = C:\product\11.2.0\dbhome_3                                             
RPE-02230: Debug Information: USERDOMAIN = WORKGROUP                                             
RPE-02230: Debug Information: ALLUSERSPROFILE = C:\ProgramData                                             
RPE-02230: Debug Information: TMP = C:\Windows\TEMP                                             
RPE-02230: Debug Information: CommonProgramFiles = C:\Program Files\Common Files                                             
RPE-02230: Debug Information: PROMPT = $P$G                                             
RPE-02230: Debug Information: PROCESSOR_LEVEL = 6                                             
RPE-02230: Debug Information: JVM_OPTIONS = -Xmx768M                                             
RPE-02230: Debug Information: LOCALAPPDATA = C:\Windows\system32\config\systemprofile\AppData\Local                                             
RPE-02230: Debug Information: COMPUTERNAME = INT-A-MDM-01                                             
RPE-02230: Debug Information: SystemRoot = C:\Windows                                             
RPE-02230: Debug Information: ORA_HOME = C:\product\11.2.0\dbhome_3                                             
RPE-02230: Debug Information: USERNAME = INT-A-MDM-01$                                             
RPE-02230: Debug Information: APPDATA = C:\Windows\system32\config\systemprofile\AppData\Roaming                                             
RPE-02230: Debug Information: ProgramData = C:\ProgramData                                             
RPE-02230: Debug Information: PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC                                             
RPE-02230: Debug Information: ORACLE_HOME = C:\product\11.2.0\dbhome_3                                             
RPE-02230: Debug Information: RTUSER = OWBSYS                                             
RPE-02230: Debug Information: ProgramFiles(x86) = C:\Program Files (x86)                                             
RPE-02230: Debug Information: TEMP = C:\Windows\TEMP                                             
RPE-02230: Debug Information: OEM_HOME = C:\product\11.2.0\dbhome_3                                             
RPE-02230: Debug Information: ProgramFiles = C:\Program Files                                             
RPE-02230: Debug Information: JDK_HOME = C:\product\11.2.0\dbhome_3\jdk6                                             
RPE-02230: Debug Information: OCM_HOME = C:\product\11.2.0\dbhome_3                                             
RPE-02230: Debug Information: ProgramW6432 = C:\Program Files                                             
RPE-02230: Debug Information: PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 26 Stepping 5, GenuineIntel                                             
RPE-02230: Debug Information: STARTUP_TYPE = -manual                                             
RPE-02230: Debug Information: PROCESSOR_ARCHITECTURE = AMD64                                             
RPE-02230: Debug Information: OS = Windows_NT                                             
RPE-02230: Debug Information: FP_NO_HOST_CHECK = NO                                             
RPE-02230: Debug Information: CommonProgramW6432 = C:\Program Files\Common Files                                             
RPE-02230: Debug Information: ORACLE_SID = mdm                                             
RPE-02230: Debug Information: DISCOVERER_ALLOW_DB_CONNECT_STRING = YES                                             
RPE-02230: Debug Information: OWB_HOME = C:\product\11.2.0\dbhome_3                                             
RPE-02230: Debug Information: NUMBER_OF_PROCESSORS = 2                                             
RPE-02230: Debug Information: PUBLIC = C:\Users\Public                                             
RPE-02230: Debug Information: PSModulePath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\                                             
RPE-02230: Debug Information: CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files                                             
RPE-02230: Debug Information: ComSpec = C:\Windows\system32\cmd.exe                                             
RPE-02235: The operating system has reported that it cannot execute the requested command. This may be because the command or the parameters are invalid, or that the command is shell command. Any result code return is specific to the operating system. Debug information has been produced.                                             
Cannot run program "/usr/bin/perl": CreateProcess error=2, The system cannot find the file specified                                             
OUBIWF_D_DEVICE_ACTIVITY_TYPE:EMAIL_FILEMGR                              1          2012-07-04 16:57:40.0Parameters                                             
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at line 8

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points