DSXchange

Hi,

In my job i need to convert the columns as rows. I have used the PIVOT stage for that. Job is working fine in my development environment and producing the report as required.

If i import the same job in System test server and run the job, the job getting aborted at PIVOT stage and producing the Errors as below.

main_program: Fatal Error: Fatal: Shared library (pivotenu.so) failed to load: errno = ( 8 ), system message = (rtld: 0712-001 Symbol DSPIMallocStageName was referenced

from module /Ascential/Ascential/DataStage/DSEngine/lib/pivotenu.so(), but a runtime definition

of the symbol was not found.

rtld: 0712-001 Symbol DSCRegisterActive was referenced

from module /Ascential/Ascential/DataStage/DSEngine/lib/pivotenu.so(), but a runtime definition

of the symbol was not found.

rtld: 0712-001 Symbol ds_writelog was referenced

from module /Ascential/Ascential/DataStage/DSEngine/lib/pivotenu.so(), but a runtime definition

of the symbol was not found.

rtld: 0712-001 Symbol DSCLoadResourceEx was referenced

from module /Ascential/Ascential/DataStage/DSEngine/lib/pivotenu.so(), but a runtime definition

of the symbol was not found.

rtld: 0712-001 Symbol DSCDeclareProperty was referenced

from module /Ascential/Ascential/DataStage/DSEngine/lib/pivotenu.so(), but a runtime definition

of the symbol was not found.

rtld: 0712-001 Symbol DSCPropDefaultFromLong was referenced

from module /Ascential/Ascential/DataStage/DSEngine/lib/pivotenu.so(), but a runtime definition

of the symbol was not found.

rtld: 0712-001 Symbol DSCPropDefaultFromStr was referenced

from module /Ascential/Ascential/DataStage/DSEngine/lib/pivotenu.so(), but a runtime definition

of the symbol was not found.

0509-021 Additional errors occurred but are not reported.)



Please suggest me to resolve this one.

Your library paths are not correctly set up in the system test environment. Compare the settings for LIB or LIBPATH on DEV and the system test and I am fairly certani you will having one or more missing directories.

We have removed the PIVOT stage from the job and implemented the same functionality using the Transformer and Funnel.

But the performance is not as expected.

You could always change your expectations.

Or you could address the issue of the Pivot stage's library, rather than ignoring it.

I'm having the same problem and wondering what the problem is.
My LIBPATH:
/.dslibs:/opt/dstage/Ascential/DataStage/branded_odbc/lib:/opt/dstage/Ascential/DataStage/DSEngine/lib:/opt/dstage/Ascential/DataStage/DSEngine/uvdlls:/opt/dstage/Ascential/DataStage/DSEngine/java/jre/bin/classic:/opt/dstage/Ascential/DataStage/DSEngine/java/jre/bin:/opt/dstage/Ascential/DataStage/PXEngine/lib:/usr/opt/db2_08_01/lib:/home/db2smpd1/sqllib/lib
croydon:/opt/dstage/Ascential/DataStage/DSEngine

A bit redundant, but it works, otherwise.
Permissions on privot.sa dn pivotenu.so are 755
DSEngine/lib permissions are 755
every other entry in DSEngine/lib is 755 except links

Any ideas?

thanks,

Ande