Problems with plugin shared libraries in 4.11b on HP-UX 11.0

undertone · Post by **undertone** » Mon Feb 02, 2004 4:44 am

Hi,

We are using DataStage 4.1.1B on HPUX 11.00. Following a hardware upgrade on our production server, when trying to access an OCI stage, I received the following message:
ds_loadlibrary: error in dlopen - Dynamic Error.

While working with Ascential support, we unregistered, deleted and re-installed the ORAOCI8 plug-in. We also relinked the shared libraries and confirmed our dsenv was configured correctly.

We have now discovered that the problem isnt just with our OCI plugins, but all plugins that we have installed. The error messages being returned when we try to execute jobs suggest that the application is unable to locate the shared libraries. The shared libraries are present, and permissions are set to read,write,execute for all.

We did install some Unix patches as part of the hardware upgrade, which may have caused the problem, but removing those patches is not an option

Does anyone have any ideas?

Thanks,

Liam

ogmios · Post by **ogmios** » Mon Feb 02, 2004 7:06 am

Look whether you have a link called .dslibs in the / on your system, it should be there.

This should point to the /"..."/Ascential/DataStage/branded_odbc/lib directory where "..." is wherever you installed DataStage to. It should not point to a dummy directory.

Regards,
Ogmios

undertone · Post by **undertone** » Mon Feb 02, 2004 8:23 am

Hi ogmios

Unfortunately no file by the name of " .dslibs " in / , however there is a " .uvlibs " file pointing to the ../branded_odbc/lib directory.

Regards,
Liam

chulett · Post by **chulett** » Mon Feb 02, 2004 9:02 am

That would be correct for your version. It was changed in later versions (5.x?) from 'uv' to 'ds' when the underlying engine changed from straight Universe to the 'DataStage Engine'.

undertone · Post by **undertone** » Mon Feb 02, 2004 12:56 pm

We found the problem!

For our hardward upgrade, a bundle of patches were installed.

HP-UX patch PHCO_24148 and PHCO_23770 (libc cumulative patch), wich was part of this bundle, crashes DS

Director will not run a job, and the Oracle OCI fails to
work in designer. Selecting the 'view data' resulted in: ds_loadlibrary:
error in dlopen - Dynamic Error.

Resolution: HP patch PHCO_24148 and PHCO_23770 (libc cumulative patch) for HP_UX 11 will only work with DataStage 4.2.1 or above. PHCO_24148 superceeds PHCO_23770. PHCO_23770 was release by HP to replace the recalled patch

We simply removed the patch and all is back to normal again.

Rgds,

Liam

jacal · Post by **jacal** » Mon Aug 23, 2004 4:39 am

Hello,

I've some problems that is familiar with this one.
How can I see what patches were installed in the DataStage Server?

All of the executions of the jobs aborts when I have the OCI stage.
How can I solve this?

Best regards,
Rui Moito

chulett · Post by **chulett** » Mon Aug 23, 2004 7:10 am

jacal wrote:How can I see what patches were installed in the DataStage Server?

The patches mentioned above are Operating System patches, nothing to do with DataStage other than their effect on it. Check with your System Administrators, they can give you details about patch levels.

All of the executions of the jobs aborts when I have the OCI stage. How can I solve this?

Post the details! What error messages do you receive? Did these jobs work before or is this the first time you've tried to use an OCI stage? When you reset the jobs do you get any entries in their logs labelled 'From previous run...'? What version of DataStage? What O/S?

jacal · Post by **jacal** » Mon Aug 23, 2004 7:39 am

Hy,

OK, I forgot to put these requirements.
I have 2 Environments: Production and Development Projects (these projects are in different machines with HP-UX 11.0). All DataStage projects are in version 7.1.

This weekend, the UNIX machines have some techincal operations (memory and processor upgrade). When that operations finished, the machines start working, however the execution of my jobs didn't work.

The logs extracted from DataStage Director are like these:

Project:PROJDS_ODS_MTB_PRD (sddwprd)
Job name:LTIPAGRCART
Event #:71
Timestamp:22-08-2004 17:18:22
Event type:Other=21
User:dwprd
Message:
ds_loadlibrary: error in dlopen - Dynamic Error

Project:PROJDS_ODS_MTB_PRD (sddwprd)
Job name:LTIPAGRCART
Event #:72
Timestamp:22-08-2004 17:18:22
Event type:Info
User:dwprd
Message:
LTIPAGRCART..TR_EBCDIC_TOASCII: DSD.StageRun Active stage starting, tracemode = 0.

(...)

Project:PROJDS_ODS_MTB_PRD (sddwprd)
Job name:LTIPAGRCART
Event #:96
Timestamp:22-08-2004 17:18:26
Event type:Warning
User:dwprd
Message:
LTIPAGRCART..InsertUpdate: C Stage PlugIn function "GetByKey" required

Project:PROJDS_ODS_MTB_PRD (sddwprd)
Job name:LTIPAGRCART
Event #:97
Timestamp:22-08-2004 17:18:26
Event type:Warning
User:dwprd
Message:
LTIPAGRCART..InsertUpdate: C Stage PlugIn function "Put" required

(...)

When I reset a job, the logs extracted is like these:

Project:PROJDS_ODS_MTB_PRD (sddwprd)
Job name:LTIPAGRCART
Event #:145
Timestamp:23-08-2004 14:38:20
Event type:Warning
User:dwprd
Message:
DataStage Job 1460 Phantom 4245
/usr/lib/dld.sl: Can't find path for shared library: libclntsh.sl.9.0
/usr/lib/dld.sl: No such file or directory
DataStage Phantom Finished

Any ideas?

Rui Moito

jacal · Post by **jacal** » Mon Aug 23, 2004 2:30 pm

OK folks,

I solved my problem.
My dsenv file hadn't the configuration necessary to link the libraries to Oracle. I added these lines in "dsenv" and restarted the DS Server:

(...)
export ORACLE_BASE=/opt/software/oracle/9i
export ORACLE_HOME=$ORACLE_BASE/9.2.0
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
(...)
SHLIB_PATH=$ORACLE_HOME/lib32:/usr/lib:$SHLIB_PATH; export SHLIB_PATH
(...)

Thanks for the ideas.
This case is colsed.

Rui Moito

DSXchange

Problems with plugin shared libraries in 4.11b on HP-UX 11.0

Problems with plugin shared libraries in 4.11b on HP-UX 11.0

Re: Problems with plugin shared libraries in 4.11b on HP-UX

Problem Solved!!