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
Problems with plugin shared libraries in 4.11b on HP-UX 11.0
Moderators: chulett, rschirm, roy
Re: Problems with plugin shared libraries in 4.11b on HP-UX
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
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
Problem Solved!!
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
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
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.jacal wrote:How can I see what patches were installed in the DataStage Server?
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?All of the executions of the jobs aborts when I have the OCI stage. How can I solve this?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
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
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
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