What uid is the Tomcat Server running as? What uid are you running at the command prompt? You might try an su to the uid of the Tomcat server and see if the script runs. You might have to change ownership or chmod the directories. If that doesn't work, I'm... uh ... sort of out of ideas.

The question is probably best asked on a forum dedicated to http servers and not a CGI forum dedicated to CGI scripts.

Thanks for replying..
I actually get stuck when I try to run Esscmd script from with a perl-cgi script as follows

system ("E:\\Hyperion\\essbase\\bin\\esscmd.exe", "E1_test.cmd")
Or
system ("esscmd.exe", "E1_test.cmd")

Both give the following error:

"Essbase Command Mode Interface - Release 9.3.1 (ESB9.3.1.0.0B181) Copyright (c) 1991, 2007, Oracle and/or its affiliates. All rights reserved. U.S. Patent Number 5,359,724 U.S. Patent Number 6,317,750 Failed in GCInit(). Return code 10 ARBORPATH variable isn't set, using default value You should always set ARBORPATH variable Using ARBORPATH [\ARBOR] ARBORPATH dump: \(5c) A(41) R(52) B(42) O(4f) R(52) \(5c) Path to locale files passed to GCInit() was ESSLANG variable isn't set Could not find the locale files at specified location".

Esscmd command runs fine from windows command promt. Env. ARBORPATH is set to "E:\Hyperion\Essbase" and PATH is set to "E:\HYperion\essbase\bin".

Esscmd.exe is present in "E:\Hyperion\Essbase\bin" and "E:\Hyperion\AnalyticAdministrationServices\server\bin".

I understand that perl-cgi script is unable to locate esscmd because it looks in it's default cgi-bin folder somewhere in C:\Program files\Apache Group\Apache\cgi-bin.

Will the problem be solved if I set ARBORPATH to "E:\HYperion\essbase\bin" along with "E:\Hyperion\Essbase". Will this have any other implications?

IS there any other way I can get rid of this issue.

Any pointers will be appreciated.

Thanks in Advance!!
Gaurav

Issue Solved.

I had to set up the environment variables related to essbase in apache config file.

THE environment variables for Apache CGI are different from that of the operating system and have to be set in the Apache httpd.confg file.

Thanks for the replies though.

Gaurav