Hi,
I got a job, read data from a sql server table, output to transfomer, then XML output, then WebSphere MQ. But the job failed to run with the error message below:
main_program: Fatal Error: Fatal: Shared library (mqs.DLL) failed to load: errno = (-126), system message = (The specified module could not be found. )
I look into the datastage server's environment, the path points to the mqs.dll is there.
This is windows OS.
What seems to be wrong?
Please help!
Thanks,
HoaN
MQS.DLL FAILED TO LOAD
Moderators: chulett, rschirm, roy
Look at the log file of your job and see if the ENVironment variables are actually set correctly during runtime for that job.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 6
- Joined: Wed Jun 10, 2009 12:38 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 6
- Joined: Wed Jun 10, 2009 12:38 pm
Hi Sainath,
I searched the DSXchange's knowledge base and found one but it's Unix environment. I am on Windows.
Below is the environment settings from a datastage job. You could please point me as to where I can add the path if it's not already there
Thanks,
Hoa
Environment variable settings:
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APT_COMPILEOPT=-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t-
APT_COMPILER=cxx
APT_CONFIG_FILE=C:/IBM/InformationServer/Server/Configurations/default.apt
APT_DUMP_SCORE=1
APT_ERROR_CONFIGURATION=severity, !vseverity, !jobid, moduleid, errorIndex, timestamp, !ipaddr, !nodeplayer, !nodename, opid, message
APT_LINKER=cxx
APT_LINKOPT=-s -W/dll -W/base:0x50000000 -W/Zc:wchar_t-
APT_MONITOR_MINTIME=10
APT_NO_ONE_NODE_COMBINING_OPTIMIZATION=1
APT_OPERATOR_REGISTRY_PATH=C:\IBM\InformationServer\Server\Projects\ETL_Dev\buildop
APT_ORCHHOME=C:/IBM/InformationServer/Server/PXEngine
APT_RECORD_COUNTS=1
APT_USE_CRLF=1
BELL=^G
CLASSPATH=C:\Program Files\IBM\WebSphere MQ\Java\lib\providerutil.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mqjms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\ldap.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jta.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jndi.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\connector.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\fscontext.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mq.jar
ClusterLog=C:\WINDOWS\Cluster\cluster.log
COMPUTERNAME=KTMSDBDV01
CommonProgramFiles=C:\Program Files\Common Files
ComSpec=C:\WINDOWS\system32\cmd.exe
DISPLAY=:0.0
DS_ENABLE_RESERVED_CHAR_CONVERT=0
DS_OPERATOR_BUILDOP_DIR=buildop
DS_OPERATOR_WRAPPED_DIR=wrapped
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
DS_USERNO=-2854
DSIPC_OPEN_TIMEOUT=30
FLAVOR=-1
FP_NO_HOST_CHECK=NO
INCLUDE=C:\Program Files\Microsoft SDKs\Windows\v6.0A\Include;C:\Program Files\IBM\WebSphere MQ\tools\c\include;C:\Program Files\IBM\WebSphere MQ\tools\cplus\include
LIB=C:\Program Files\Microsoft SDKs\Windows\v6.0A\Lib;C:\Program Files\IBM\WebSphere MQ\tools\lib
MAN_CHM_INDEX=C:/PROGRA~1/MKSTOO~1/etc/chm/tkutil.idx;C:/PROGRA~1/MKSTOO~1/etc/chm/tkapi.idx;C:/PROGRA~1/MKSTOO~1/etc/chm/tcltk.idx;C:/PROGRA~1/MKSTOO~1/etc/chm/tkcurses.idx
MAN_HTM_PATHS=C:/PROGRA~1/MKSTOO~1/etc/htm/perl;C:/PROGRA~1/MKSTOO~1/etc/htm/perl/pod;C:/PROGRA~1/MKSTOO~1/etc/htm/perl/ext;C:/PROGRA~1/MKSTOO~1/etc/htm/perl/lib
MAN_TXT_INDEX=C:/PROGRA~1/MKSTOO~1/etc/tkutil.idx;C:/PROGRA~1/MKSTOO~1/etc/tkapi.idx;C:/PROGRA~1/MKSTOO~1/etc/tcltk.idx;C:/PROGRA~1/MKSTOO~1/etc/tkcurses.idx
MQ_JAVA_DATA_PATH=C:\Program Files\IBM\WebSphere MQ
MQ_JAVA_INSTALL_PATH=C:\Program Files\IBM\WebSphere MQ\Java
MQ_JAVA_LIB_PATH=C:\Program Files\IBM\WebSphere MQ\Java\lib
MSTR_CLASSPATH=C:\Program Files\Common Files\MicroStrategy
MSTR_WEB_PATH=C:\Program Files\MicroStrategy\Web ASPx
MSTR_WEBSERVICES_PATH=C:\Program Files\MicroStrategy\Web Services
NUMBER_OF_PROCESSORS=8
NUTCROOT=C:\PROGRA~1\MKSTOO~1
NZ_DIR=C:\Program Files\Netezza\
OS=Windows_NT
OSH_STDOUT_MSG=1
PATH=C:\IBM\InformationServer\Server\PXEngine\bin;C:\IBM\InformationServer\Server\PXEngine\osh_wrappers;C:\IBM\InformationServer\Server\PXEngine\user_osh_wrappers;C:\IBM\InformationServer\Server\PXEngine\user_osh_wrappers;C:\IBM\InformationServer\Server\DSComponents\bin;C:\IBM\InformationServer\Server\DSParallel;C:\IBM\InformationServer\Server\Projects\ETL_Dev\RT_BP1186.O;C:\IBM\InformationServer\Server\DSEngine\bin;C:\IBM\InformationServer\Server\Projects\ETL_Dev\buildop;C:\IBM\InformationServer\Server\Projects\ETL_Dev\wrapped;C:\Program Files\IBM\WebSphere MQ\Java\lib;C:\PROGRA~1\MKSTOO~1\bin;C:\PROGRA~1\MKSTOO~1\bin\X11;C:\IBM\InformationServer\ASBNode\apps\jre\bin\classic;C:\IBM\InformationServer\ASBNode\lib\cpp;C:\IBM\InformationServer\ASBNode\apps\proxy\cpp\vc60\MT_dll\bin;C:\PROGRA~1\MKSTOO~1\mksnt;C:\Program Files\EMC\PowerPath\;C:\Program Files\EMC\RSA\CST\lib\;C:\Program Files\EMC\RSA\Rkm_Client\lib\;D:\Program Files\Business Objects\common\3.5\bin\NOTES\;D:\Program Files\Business Objects\common\3.5\bin\NOTES\DATA\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files\EMC\Navisphere CLI;C:\Program Files\Netezza\Bin;C:\Program Files\Windows Imaging\;C:\Program Files\IBM\WebSphere MQ\bin;C:\Program Files\IBM\WebSphere MQ\tools\c\samples\bin;C:\Program Files\Common Files\MicroStrategy;C:\Program Files\MicroStrategy\Administrator\Command Manager;C:\Program Files\MicroStrategy\Administrator\Enterprise Manager;C:\Program Files\MicroStrategy\Desktop;C:\Program Files\MicroStrategy\Narrowcast Server\Delivery Engine;$PATH:C:\Program Files\Netezza\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.sh;.ksh;.csh;.sed;.awk;.pl
PIDTOK=38572
Powmig Path=C:\Program Files\EMC\PowerPath\
PP_SHOW_VERSION_STYLE=VERBOSE
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 11, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f0b
ProgramFiles=C:\Program Files
PWD=C:\IBM\InformationServer\Server\Projects\ETL_Dev
PX_DBCONNECTHOME=C:/IBM/InformationServer/Server/DSComponents
pDatasetFileDir=C:\Ascential
pDSN4CENTS_ERROR=CENTS_ERROR
pDSN4CENTS_ITEM=CENTS_ITEM
pDSN4CENTS_UT=CENTS_UT
pDSN4CentStg=CENTS_STG_LACT
pDSN4staging_EDW_SQL2005=staging_EDW_SQL2005
pDSNetl_staging=etl_staging
pDSNKTCTCENTS_SSO=CENTS_SSO
pPWD4CENTS_ERROR=LDH@8JVHM9;<0FDI4IJ5AKH4B5LIMAQ4A
pPWD4CENTS_ITEM=LDH@8JVHM9;<0FDI4IJ5AKH4B5LIMAQ4A
pPWD4CENTS_UT=LDH@8JVHM9;<0FDI4IJ5AKH4B5LIMAQ4A
pPWD4staging_EDW_SQL2005=LD;@9;R@=9:<0FDI<;J<CKAD
pPWDetl_staging=LD;@9;R@=9:<0FDI<;J<CKAD
pPWDKTCTCENTS_SSO=L58@0:VA=9:<0GFI<KJ52OI7B<NIM0U<@UB=kF9dFBQ?BPOJ
pPwd4KTCTDBDR01=LDH@8JVHM9;<0FDI4IJ5AKH4B5LIMAQ4A
pSurKey=C:\Ascential
pUID4CENTS_ERROR=cendiuser
pUID4CENTS_ITEM=cendiuser
pUID4CENTS_UT=cendiuser
pUID4staging_EDW_SQL2005=bouser
pUIDetl_staging=bouser
pUIDKTCTCENTS_SSO=DOMAIN99\S_ETL_PROCESS
pUId4KTCTDBDR01=cendiuser
ROOTDIR=C:/PROGRA~1/MKSTOO~1
SHELL=C:/PROGRA~1/MKSTOO~1/mksnt/sh.exe
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\WINDOWS\TEMP
TERM=console
TERMCAP=C:\PROGRA~1\MKSTOO~1\etc\termcap
TERMINFO=C:\PROGRA~1\MKSTOO~1\usr\lib\terminfo
TMP=C:\WINDOWS\TEMP
UATDATA=C:\WINDOWS\system32\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
UNIVERSE_CONTROLLING_TERM=1
UNIVERSE_PARENT_PROCESS=38572
USER=DOMAIN99\S_ETL_PROCESS
USERPROFILE=C:\Documents and Settings\Default User
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
WHO=ETL_Dev
windir=C:\WINDOWS
I searched the DSXchange's knowledge base and found one but it's Unix environment. I am on Windows.
Below is the environment settings from a datastage job. You could please point me as to where I can add the path if it's not already there
Thanks,
Hoa
Environment variable settings:
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APT_COMPILEOPT=-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t-
APT_COMPILER=cxx
APT_CONFIG_FILE=C:/IBM/InformationServer/Server/Configurations/default.apt
APT_DUMP_SCORE=1
APT_ERROR_CONFIGURATION=severity, !vseverity, !jobid, moduleid, errorIndex, timestamp, !ipaddr, !nodeplayer, !nodename, opid, message
APT_LINKER=cxx
APT_LINKOPT=-s -W/dll -W/base:0x50000000 -W/Zc:wchar_t-
APT_MONITOR_MINTIME=10
APT_NO_ONE_NODE_COMBINING_OPTIMIZATION=1
APT_OPERATOR_REGISTRY_PATH=C:\IBM\InformationServer\Server\Projects\ETL_Dev\buildop
APT_ORCHHOME=C:/IBM/InformationServer/Server/PXEngine
APT_RECORD_COUNTS=1
APT_USE_CRLF=1
BELL=^G
CLASSPATH=C:\Program Files\IBM\WebSphere MQ\Java\lib\providerutil.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mqjms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\ldap.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jta.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jndi.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\jms.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\connector.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\fscontext.jar;C:\Program Files\IBM\WebSphere MQ\Java\lib\com.ibm.mq.jar
ClusterLog=C:\WINDOWS\Cluster\cluster.log
COMPUTERNAME=KTMSDBDV01
CommonProgramFiles=C:\Program Files\Common Files
ComSpec=C:\WINDOWS\system32\cmd.exe
DISPLAY=:0.0
DS_ENABLE_RESERVED_CHAR_CONVERT=0
DS_OPERATOR_BUILDOP_DIR=buildop
DS_OPERATOR_WRAPPED_DIR=wrapped
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
DS_USERNO=-2854
DSIPC_OPEN_TIMEOUT=30
FLAVOR=-1
FP_NO_HOST_CHECK=NO
INCLUDE=C:\Program Files\Microsoft SDKs\Windows\v6.0A\Include;C:\Program Files\IBM\WebSphere MQ\tools\c\include;C:\Program Files\IBM\WebSphere MQ\tools\cplus\include
LIB=C:\Program Files\Microsoft SDKs\Windows\v6.0A\Lib;C:\Program Files\IBM\WebSphere MQ\tools\lib
MAN_CHM_INDEX=C:/PROGRA~1/MKSTOO~1/etc/chm/tkutil.idx;C:/PROGRA~1/MKSTOO~1/etc/chm/tkapi.idx;C:/PROGRA~1/MKSTOO~1/etc/chm/tcltk.idx;C:/PROGRA~1/MKSTOO~1/etc/chm/tkcurses.idx
MAN_HTM_PATHS=C:/PROGRA~1/MKSTOO~1/etc/htm/perl;C:/PROGRA~1/MKSTOO~1/etc/htm/perl/pod;C:/PROGRA~1/MKSTOO~1/etc/htm/perl/ext;C:/PROGRA~1/MKSTOO~1/etc/htm/perl/lib
MAN_TXT_INDEX=C:/PROGRA~1/MKSTOO~1/etc/tkutil.idx;C:/PROGRA~1/MKSTOO~1/etc/tkapi.idx;C:/PROGRA~1/MKSTOO~1/etc/tcltk.idx;C:/PROGRA~1/MKSTOO~1/etc/tkcurses.idx
MQ_JAVA_DATA_PATH=C:\Program Files\IBM\WebSphere MQ
MQ_JAVA_INSTALL_PATH=C:\Program Files\IBM\WebSphere MQ\Java
MQ_JAVA_LIB_PATH=C:\Program Files\IBM\WebSphere MQ\Java\lib
MSTR_CLASSPATH=C:\Program Files\Common Files\MicroStrategy
MSTR_WEB_PATH=C:\Program Files\MicroStrategy\Web ASPx
MSTR_WEBSERVICES_PATH=C:\Program Files\MicroStrategy\Web Services
NUMBER_OF_PROCESSORS=8
NUTCROOT=C:\PROGRA~1\MKSTOO~1
NZ_DIR=C:\Program Files\Netezza\
OS=Windows_NT
OSH_STDOUT_MSG=1
PATH=C:\IBM\InformationServer\Server\PXEngine\bin;C:\IBM\InformationServer\Server\PXEngine\osh_wrappers;C:\IBM\InformationServer\Server\PXEngine\user_osh_wrappers;C:\IBM\InformationServer\Server\PXEngine\user_osh_wrappers;C:\IBM\InformationServer\Server\DSComponents\bin;C:\IBM\InformationServer\Server\DSParallel;C:\IBM\InformationServer\Server\Projects\ETL_Dev\RT_BP1186.O;C:\IBM\InformationServer\Server\DSEngine\bin;C:\IBM\InformationServer\Server\Projects\ETL_Dev\buildop;C:\IBM\InformationServer\Server\Projects\ETL_Dev\wrapped;C:\Program Files\IBM\WebSphere MQ\Java\lib;C:\PROGRA~1\MKSTOO~1\bin;C:\PROGRA~1\MKSTOO~1\bin\X11;C:\IBM\InformationServer\ASBNode\apps\jre\bin\classic;C:\IBM\InformationServer\ASBNode\lib\cpp;C:\IBM\InformationServer\ASBNode\apps\proxy\cpp\vc60\MT_dll\bin;C:\PROGRA~1\MKSTOO~1\mksnt;C:\Program Files\EMC\PowerPath\;C:\Program Files\EMC\RSA\CST\lib\;C:\Program Files\EMC\RSA\Rkm_Client\lib\;D:\Program Files\Business Objects\common\3.5\bin\NOTES\;D:\Program Files\Business Objects\common\3.5\bin\NOTES\DATA\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files\EMC\Navisphere CLI;C:\Program Files\Netezza\Bin;C:\Program Files\Windows Imaging\;C:\Program Files\IBM\WebSphere MQ\bin;C:\Program Files\IBM\WebSphere MQ\tools\c\samples\bin;C:\Program Files\Common Files\MicroStrategy;C:\Program Files\MicroStrategy\Administrator\Command Manager;C:\Program Files\MicroStrategy\Administrator\Enterprise Manager;C:\Program Files\MicroStrategy\Desktop;C:\Program Files\MicroStrategy\Narrowcast Server\Delivery Engine;$PATH:C:\Program Files\Netezza\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.sh;.ksh;.csh;.sed;.awk;.pl
PIDTOK=38572
Powmig Path=C:\Program Files\EMC\PowerPath\
PP_SHOW_VERSION_STYLE=VERBOSE
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 11, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f0b
ProgramFiles=C:\Program Files
PWD=C:\IBM\InformationServer\Server\Projects\ETL_Dev
PX_DBCONNECTHOME=C:/IBM/InformationServer/Server/DSComponents
pDatasetFileDir=C:\Ascential
pDSN4CENTS_ERROR=CENTS_ERROR
pDSN4CENTS_ITEM=CENTS_ITEM
pDSN4CENTS_UT=CENTS_UT
pDSN4CentStg=CENTS_STG_LACT
pDSN4staging_EDW_SQL2005=staging_EDW_SQL2005
pDSNetl_staging=etl_staging
pDSNKTCTCENTS_SSO=CENTS_SSO
pPWD4CENTS_ERROR=LDH@8JVHM9;<0FDI4IJ5AKH4B5LIMAQ4A
pPWD4CENTS_ITEM=LDH@8JVHM9;<0FDI4IJ5AKH4B5LIMAQ4A
pPWD4CENTS_UT=LDH@8JVHM9;<0FDI4IJ5AKH4B5LIMAQ4A
pPWD4staging_EDW_SQL2005=LD;@9;R@=9:<0FDI<;J<CKAD
pPWDetl_staging=LD;@9;R@=9:<0FDI<;J<CKAD
pPWDKTCTCENTS_SSO=L58@0:VA=9:<0GFI<KJ52OI7B<NIM0U<@UB=kF9dFBQ?BPOJ
pPwd4KTCTDBDR01=LDH@8JVHM9;<0FDI4IJ5AKH4B5LIMAQ4A
pSurKey=C:\Ascential
pUID4CENTS_ERROR=cendiuser
pUID4CENTS_ITEM=cendiuser
pUID4CENTS_UT=cendiuser
pUID4staging_EDW_SQL2005=bouser
pUIDetl_staging=bouser
pUIDKTCTCENTS_SSO=DOMAIN99\S_ETL_PROCESS
pUId4KTCTDBDR01=cendiuser
ROOTDIR=C:/PROGRA~1/MKSTOO~1
SHELL=C:/PROGRA~1/MKSTOO~1/mksnt/sh.exe
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\WINDOWS\TEMP
TERM=console
TERMCAP=C:\PROGRA~1\MKSTOO~1\etc\termcap
TERMINFO=C:\PROGRA~1\MKSTOO~1\usr\lib\terminfo
TMP=C:\WINDOWS\TEMP
UATDATA=C:\WINDOWS\system32\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
UNIVERSE_CONTROLLING_TERM=1
UNIVERSE_PARENT_PROCESS=38572
USER=DOMAIN99\S_ETL_PROCESS
USERPROFILE=C:\Documents and Settings\Default User
VS90COMNTOOLS=C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
WHO=ETL_Dev
windir=C:\WINDOWS
In which directory is this dll on Windows?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 6
- Joined: Wed Jun 10, 2009 12:38 pm
None of those three directories are in the runtime "LIB" path, which explains your error message. Now you need to figure out why your LIB variable is so small. I don't have a Windows installation, but perhaps someone here who does could post their LIB environment value.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>