Page 1 of 1

orchadmin errors

Posted: Mon Jun 09, 2008 11:21 am
by jreddy
Hi,

I am trying to execute 'orchadmin rm *.ds' from the directories where the datasets are created through parallel jobs.
I was able to do that on the developement server, but when i moved to the integration server (that has the exact same directory structure), i am no longer able to do that.

Here's the error message i get:

dsadm:/apps/intg/SDS/> orchadmin rm *
##E TFPA 000021 $APT_CONFIG_FILE was not set, and config.apt was not found in the working directory or in $APT_ORCHHOME/etc.
##F TFCF 000009 Fatal Error: Cannot continue without a configuration file.



I checked to make sure $PATH is exactly the same and also $LD_LIBRARY_PATH etc are all set.

What have i missed setting? I am also not able to run my sequencers right in integration. Getting a -99 (General repository error) error on most jobs. So started comparing devl and intg servers to see what is different when i realised about this orchadmin not working.

Please advise
Thanks in advance

Posted: Mon Jun 09, 2008 11:28 am
by Minhajuddin
A few parameters have to be setup properly before you can use orchadmin.

set your $APT_CONFIG_FILE to the absolute path of your configuration file and $APT_ORCHHOME to the PXEngine directory of Datastage and try this command again.

Posted: Mon Jun 09, 2008 11:31 am
by Madhavan VM
Hello,

It is looking for a configuration file, config.apt, under $APT_ORCHHOME/etc. Place the configuration file with which you created the datasets under this folder and then try to dump the dataset successfully before deleting them.

If anyone has a different opinion, let us know.

Posted: Mon Jun 09, 2008 11:36 am
by jreddy
Configuration file with which these datasets were created is sitting in the Configurations directory.

$APT_ORCHHOME is set to the PXEngine directory via administrator and also in dsenv.

$APT_CONFIG_FILE is different for different jobs and hence the default one is defined at project level in administrator, but the jobs use different ones by calling this environment variable as a run time parameter in the job.

Posted: Mon Jun 09, 2008 11:47 am
by jreddy
OK - the config.apt file was missing from the /etc directory - thanks Madhavan. I brought it over from devl and now i am able to execute orchadmin rm *.ds from the dataset directories

thanks