Error deleting datasets

kumar11 · Post by **kumar11** » Tue Sep 20, 2016 9:36 am

Hi,
when trying to delete the datasets on the box getting the below error:

/opt/IBM/InformationServer/Server/PXEngine> in/orchadmin delete /mi/dev1/datastage/stage/xxxxx.ds <
Could not load program /opt/IBM/InformationServer/Server/PXEngine/bin/orchadmin:
Symbol resolution failed for /opt/IBM/InformationServer/Server/PXEngine/lib/liborchcoreaix64.so because:
Symbol __dl__Q2_6icu_507UMemoryFPv (number 160) is not exported from dependent
module /opt/IBM/TWA/TWS/bin/libicuuc.a[libicuuc.so].
Symbol u_errorName_50 (number 161) is not exported from dependent
module /opt/IBM/TWA/TWS/bin/libicuuc.a[libicuuc.so].
Symbol u_setDataDirectory_50 (number 162) is not exported from dependent
module /opt/IBM/TWA/TWS/bin/libicuuc.a[libicuuc.so].
Symbol u_strlen_50 (number 163) is not exported from dependent
module /opt/IBM/TWA/TWS/bin/libicuuc.a[libicuuc.so].

ArndW · Post by **ArndW** » Tue Sep 20, 2016 10:40 am

It looks like you have not sourced the "dsenv" file, or that the path to the orchadmin command is not part of your $PATH.

kumar11 · Post by **kumar11** » Tue Sep 20, 2016 12:01 pm

Tried sourcing dsenv and updating the $PATH. but still the below error persists.

/opt/IBM/InformationServer/Server/PXEngine/bin/orchadmin delete /mi/dev1/datastage/xxxxxx.ds
Could not load program /opt/IBM/InformationServer/Server/PXEngine/bin/orchadmin:
Dependent module liborchgeneralaix64.so could not be loaded.
Could not load module liborchgeneralaix64.so.

chulett · Post by **chulett** » Tue Sep 20, 2016 12:28 pm

Just for grins, can you confirm for us what your understanding of "sourcing dsenv" means?

kumar11 · Post by **kumar11** » Tue Sep 20, 2016 1:21 pm

./dsenv

chulett · Post by **chulett** » Tue Sep 20, 2016 1:33 pm

Actually:

Code: Select all

. ./dsenv

kumar11 · Post by **kumar11** » Tue Sep 20, 2016 1:41 pm

Thanks Chulett!!
now it gives a different error.

$ . ./dsenv
$ /opt/IBM/InformationServer/Server/PXEngine/bin/orchadmin delete /mi/dev1/datastage/stage/xxxxx.ds
##E IIS-DSEE-TFPA-00021 $APT_CONFIG_FILE was not set, and config.apt was not found in the working directory or in $APT_ORCHHOME/etc.
##F IIS-DSEE-TFCF-00009 Fatal Error: Cannot continue without a configuration file.

rkashyap · Post by **rkashyap** » Tue Sep 20, 2016 3:03 pm

This technote will help you.

You can also delete datasets by invoking Data Set Management utility in either DataStage Designer or Director client.

chulett · Post by **chulett** » Tue Sep 20, 2016 3:18 pm

I changed your initial post's subject to something more problem specific, not sure why you felt the need to edit it and change it back to something so... generic.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 20, 2016 7:45 pm

Both APT_CONFIG_FILE and APT_ORCHHOME need to be set. Verify that they are set in your dsenv script and that you are correctly sourcing that script.

kumar11 · Post by **kumar11** » Wed Sep 21, 2016 8:35 am

Thanks All !!!

Able to resolve the issue after adding the APT_CONFIG_FILE and APT_ORCHHOME in dsenv file.

PaulVL · Post by **PaulVL** » Wed Sep 21, 2016 9:22 am

If your environment is hosting multiple projects, you should not set APT_CONFIG_FILE in dsenv. maybe make a wrapper script for that project so as to target a specific config file.

On a delete, it really doesn't matter that a config file be of that project, any VALID config file will do since the delete process will use the imbedded apt file in the descriptor.

But... I would still avoid putting a default APT in the dsenv.

*drops two cents*

DSXchange

Error deleting datasets

Error deleting datasets

Thanks ArndW