xml stage: ds_loadlibrary: error in dlopen

[xmw2000]

I met this library load error when executing one XML stage job. I found from forum that it maybe caused by LIBPATH mis-order. But i use the same LIBPATH in another machine, it works well. And i use root use, i think there is no privilege issue.

The error is :
Other=21 ds_loadlibrary: error in dlopen
....
info XML_input1: using NLS map UTF8
warning XML_input1: C stage plugin function "Run" required
fatal XML_input1: |-100|

I would like to know whether i can re-install this XML stage package? Is there any affect for other components of Stage?

any advice would be appricated. Thanks ahead of time

[chulett]

Just to bring people up to speed, we 'chatted' about this problem over in the developerWorks forums. I pointed them to this post by Daddy Doma which seemed to have a solution to their problem:

viewtopic.php?t=102247

This was the OP's LIBPATH that was posted. Note I'm adding returns to it to keep the post from going wide:

Code: Select all

LIBPATH=/datastage/Ascential/DataStage/branded_odbc/lib
:/datastage/Ascential/DataStage/DSEngine/lib
:/home/db2inst1/sqllib/lib
:/usr/lib:/lib
:/ctm/oracle/product/817/lib
:/usr/mqm/lib

I'm still wondering if there are more LIBPATH statements in your dsenv file, as that one seems incomplete. For example, mine from an HP-UX system specifically includes the Java paths:

Code: Select all

SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib
:$DSHOME/lib:$DSHOME/uvdlls
:$DSHOME/java/jre/lib/PA_RISC2.0
:$DSHOME/java/jre/lib/PA_RISC2.0/hotspot
:$DSHOME/java/jre/lib/PA_RISC
:$ORACLE_HOME/lib32:$ORACLE_HOME/lib
:$SYBASE/lib:$SHLIB_PATH

Obviously, these are specific to an HP machine, but thinking that something similar should be in yours somewhere.

[xmw2000]

Thanks Craig,

Sorry, i pasted the wrong LIBPATH. the following are latest LIBPATH, the same error. I have re-installed that XML package, but still doesn't work.

LIBPATH=/datastage/Ascential/DataStage/branded_odbc/lib
:/datastage/Ascential/DataStage/DSEngine/lib
:/datastage/Ascential/DataStage/DSEngine/java/jre/bin/classic
:/datastage/Ascential/DataStage/DSEngine/java/jre/bin
:/usr/mqm/lib
:/usr/lib

The env is: DS server edition v7.0.1, AIX 51006.

[xmw2000]

The above code is result of 'env $LIBPATH', the LIBPATH definition in dsenv file is:

Code: Select all

LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH

Thanks!

[xmw2000]

solved it with IBM support.

Because there are one migration from v4(or v5) to v7, some XMl pack libraries don't match. The key points is un-register these 3 XML plugin at Manager, then register them.

[ray.wurlod]

That's useful to know, thanks for posting it.

Obvious in hindsight but, then, what isn't?