Thursday, 25 February 2016

ERRORCODE=-4472, SQLSTATE=null WCS Instance Creation Error

ERROR : When WCS Instance Creation 

Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: db2jcct2 (/opt/IBM/db2/V9.7/lib32/libdb2jcct2.so: wrong ELF class: ELFCLASS32):  ERRORCODE=-4472, SQLSTATE=null

[2016.02.24 12:31:06]       [copy] Copying 1 file to /opt/IBM/WebSphere/CommerceServer70/schema/xml
[2016.02.24 12:31:07]   [Massload] Massloading /opt/IBM/WebSphere/CommerceServer70/schema/xml/wcs.keys.xml
[2016.02.24 12:31:07]   [Massload] -dbname NEWSITDB -dbuser Instance_Name -dbpwd ****** -infile /opt/IBM/WebSphere/CommerceServer70/schema/xml/wcs.keys.xml -method sqlimport -commitcount 1000 -maxerror 1 -customizer  -schemaname Instance_Name
com.ibm.db2.jcc.am.SqlException: [jcc][10389][12245][4.14.113] Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: db2jcct2 (/opt/IBM/db2/V9.7/lib32/libdb2jcct2.so: wrong ELF class: ELFCLASS32):  ERRORCODE=-4472, SQLSTATE=null

at com.ibm.db2.jcc.am.ed.a(ed.java:661)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:94)
at com.ibm.db2.jcc.t2.a.a(a.java:37)
at com.ibm.db2.jcc.t2.T2Configuration.<clinit>(T2Configuration.java:95)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
at com.ibm.db2.jcc.uw.UWAdministrator.c(UWAdministrator.java:89)

PROBLEM : DB2 Server and Client both 64 bit Products And WCS Product is 32 Bit Product, So JDBC Drivers are Type 2 and Type 4
WCS is not able to communicate with DB2 Server through DB2 Client

SOLUTION : 1. We need to Install 32 bit Client Product  OR
           2. We can set the LD_LIBRARY_PATH on Client System. Before set check the current LD_LIBRARY_PATH "echo $LD_LIBRARY_PATH"
  Output : /opt/IBM/db2/V9.7/lib32:/opt/IBM/WebSphere/CommerceServer70/bin:/home/rilsinst/sqllib/lib64:/home/rilsinst/sqllib/lib32
Then set the below path on Client System.
  LD_LIBRARY_PATH=/opt/IBM/WebSphere/CommerceServer70/bin:/home/rilsinst/sqllib/lib64:/home/rilsinst/sqllib/lib32

Refference : 

No comments:

Post a Comment