orchdbutil fails

eph · Post by **eph** » Wed Feb 16, 2011 11:33 am

This topic is not resolved, at least not directly. I will handle all intermediate query using shell scripts even if it's not the way I want it.

================================================================================================

Hi all,

I'm looking around some DS tools' features like orchadmin and orchdbutil, but it seems that some of them have not much documentation and I can't find no tip on the net.

For instance, I've launched

Code: Select all

orchdbutil check -table TABLE -dbtype oracle -server SERVER -dboptions "{user=USER, password=PWD}"

But I got this message :

Code: Select all

##I IIS-DSEE-TFCN-00006 18:14:46(001) <main_program> conductor uname: -s=Linux; -r=2.6.18-128.el5; -v=#1 SMP Wed Dec 17 11:41:38 EST 2008; -n=XXXXXXX; -m=x86_64
##I IIS-DSEE-TCDU-00040 18:14:46(002) <main_program> Checking: -table TABLE.
##I IIS-DSEE-TCDU-00009 18:14:46(003) <main_program> Database connect options: dbname= <unspecified>, server='SERVER', dboptions='{user=USER, password=PWD}'.
##I IIS-DSEE-TCDB-00002 18:14:46(004) <main_program> Database connect options: dbname= <unspecified>, server='SERVER', dboptions='{user=USER, password=PWD}'Library orchoracle is loaded.
Resource bundle corresponding to message key  not found! Check that DSHOME or APT_RESPATH is set.
##I IIS-XXXX-XXXX-00000 18:14:46(005) <main_program> ??

I've checked this : Check that DSHOME or APT_RESPATH is set

Code: Select all

$ env | grep DSHOME
DSHOME=/products/IBM/InformationServer/Server/DSEngine

I can't figure out why the command doesn't work, and it's the same when I'm trying a orchdbutil check -query.

I would be pleased if someone got a hint for this problem.
I'm also looking for an example of usage of orchdbutil exec.

Thanks in advance
eph

ray.wurlod · Post by **ray.wurlod** » Wed Feb 16, 2011 2:44 pm

Check also that APT_CONFIG_FILE and APT_ORCHHOME are set.

eph · Post by **eph** » Thu Feb 17, 2011 4:01 am

Hi Ray,
Thanks for such a quick answer!

I've checked that all env variable are set :

Code: Select all

$ env | grep APT_ORCHHOME
APT_ORCHHOME=/products/IBM/InformationServer/Server/PXEngine
$ env | grep APT_CONFIG_FILE
APT_CONFIG_FILE=<PATH>/apt_config_file_2_nodes.apt

The only one that I can't get is the APT_RESPATH

Code: Select all

$ env | grep APT_RESPATH

I've looked at this page from IBM support but I wasn't able to find any clue on what's this APT_RESPATH :

Local fix
Manually define APT_RESPATH to a list of (semi-)colon delimited
paths defining the various locations of all the message bundles.

This topic on dsxchange gave me some clues, but I'm sure that this table is not empty and I can get the table schema using orchdbutil show.

According to this one, I've set this :

Code: Select all

$ export APT_RESPATH=/products/IBM/InformationServer/Server/DSComponents/res/DSEE
$ env | grep APT_RESPATH
APT_RESPATH=/products/IBM/InformationServer/Server/DSComponents/res/DSEE

But I still get the same error. I don't think that it's a db (oracle 10g) bug so I don't get how I can solve this.

Regards
eph

eph · Post by **eph** » Tue Feb 22, 2011 7:33 am

Hi all,

Does anyone have any idea on how I could handle this problem?
My concern is that I'd like to run a SQL query within DS without using an external script.

Maybe no one is using this utility tool?

Thanks in advance

Regards,
eph

eph · Post by **eph** » Thu Feb 24, 2011 5:32 am

Is that so no one is using this command line tool out there for something else than orchestrate schema import?
It seems strange since it could be a powerfull help.

I still search for any tip but I guess there's nothing...

eph

chulett · Post by **chulett** » Thu Feb 24, 2011 7:57 am

I personally have no idea and probably like the majority of people here have only (in the past) used it to import metadata. Do you not have any kind of support for your installation? Could you not ask them?

eph · Post by **eph** » Thu Feb 24, 2011 11:30 am

Thanks Craig,

As I thought, I was a little too happy to think that I could get rid of some hugly shell scripts and manage all database queries by datastage.

Still, I'd love to see those tools get improved by the time...

eph

eph · Post by **eph** » Tue Sep 18, 2012 3:30 am

Update on this thread :

I've opened up a PMR at IBM, which reference is JR42593.
They have produced a patch for v8.1 which fix the error even if I still don't get any result from the "check -table" and "check -query" command.

I will update again this thread when I will have IBM answer.

I also have used an osh script as workaround, to avoid using external scripts.