Problem with ORCHADMIN

shiva459 · Post by **shiva459** » Sat Jun 21, 2008 3:50 am

I am trying to delete datasets using ORCHADMIN utility but running into issues. When I give orchadmin rm file.ds from $APT_ORCHHOME/bin, I get a message saying 'The environment variable APT_ORCHHOME cannot be empty'. Thie path is set in ENV variable for APT_ORCHHOME. Also, APT_CONFIG_FILE value is also set. Additionally I have set the PATH variable value to $APT_ORCHHOME/bin. But still I get the same mesage.

Any inputs?

Thanks

ArndW · Post by **ArndW** » Sat Jun 21, 2008 4:23 am

Could you output the result of "env | grep ORCH"?

ray.wurlod · Post by **ray.wurlod** » Sat Jun 21, 2008 4:50 am

The error message suggest that for the executing user APT_ORCHHOME is empty. As Arnd suggests, include an echo command in the script to verify whether or not this diagnosis is correct.

shiva459 · Post by **shiva459** » Sat Jun 21, 2008 6:45 am

Ray and ArndW

I tried echo $APT_ORCHHOME and I do not get anything. I did ENV and see bunvh of variables but do not see APT_ORCHHOME. However the value is set when I check from ADMIN tool in ENV variables.

Thanks

shiva459 · Post by **shiva459** » Sat Jun 21, 2008 6:52 am

Infact when I say echo $APT_ORCHHOME, I get a blank line as response.

ArndW · Post by **ArndW** » Sat Jun 21, 2008 7:10 am

Drop the "$" sign from the echo command.

keshav0307 · Post by **keshav0307** » Sat Jun 21, 2008 7:45 am

did tou source the dsenv file before giving orchadmin command

shiva459 · Post by **shiva459** » Sat Jun 21, 2008 7:51 am

Below is the output from echo command
echo APT_ORCHHOME
APT_ORCHHOME

chulett · Post by **chulett** » Sat Jun 21, 2008 8:24 am

Of course.

Dropping the dollar sign makes no sense (sorry Arnd) as that just echos back the string as typed. Some flavors of UNIX echo back an empty line when a value is not set, others specifically tell you it isn't set.

ArndW · Post by **ArndW** » Sat Jun 21, 2008 8:34 am

ROFL - how right you are, Craig

- I was thinking of him assigning the value, not displaying. That's what I get for working 13 days solid

chulett · Post by **chulett** » Sat Jun 21, 2008 9:15 am

I was wondering. That's what you get for being a triskaidekaworkaholic.

You definitely don't want to use the $ when assigning the value.

It is not set in the current environment. So, one would need (as noted earlier) to 'source' their dsenv file first, if that is where those are set. If they are defined only in the Administrator, then they will be set when a job runs and accessible from the job's run-time environment, not all the time.

shiva459 · Post by **shiva459** » Sat Jun 21, 2008 9:18 am

I tried this :

APT_ORCHHOME="D:\IBM\InformationServer\Server\PXEngine"
export APT_ORCHHOME

Now
echo $APT_ORCHHOME
D:\IBM\InformationServer\Server\PXEngine

cd bin
pwd
D:\IBM\InformationServer\Server\PXEngine\bin

orchadmin rm testfile.ds
orchadmin: not found

Not sure if there is any setting that needs to be changed.

shiva459 · Post by **shiva459** » Sat Jun 21, 2008 9:52 am

I'm not able to find dsenv file on my machine. Is something new in version 8?

chulett · Post by **chulett** » Sat Jun 21, 2008 9:59 am

No, that's only applicable for a UNIX server, didn't realize you were running Windows. Ignore that bit of advice in your case.

What happens if you fully path your command?

Code: Select all

$ORCHHOME\bin\orchadmin rm testfile.ds

Have you checked in your bin directory to confirm that command is (or isn't) actually there? Any chance it is "orchadmin.exe" on a Windows box? I neither know nor can check, hence the questions.

shiva459 · Post by **shiva459** » Sat Jun 21, 2008 10:23 am

Craig,

Yes, it is orchadmin.exe in windows.

$ cd D:\IBM\InformationServer\Server\PXEngine\bin
$orchadmin.exe rm testfile.ds
orchadmin.exe : not found

If I try the same thing from windows prompt
D:\IBM\InformationServer\Server\PXEngine\bin>orchadmin.exe rm testfile.ds
The environment variable APT_ORCHHOME cannot be empty