search

ibmwtx / Excel

The Excel Adapter allows customers to read and write Excel Documents
1 stars 0 forks source link

BIP7050E: Failed to locate Java class com.ibm.websphere.dtx.m4excel #1

Open tony2nd opened 8 years ago

tony2nd commented 8 years ago

While trying to create an Excel file using WTX 8.3.0.6 I am having the following error:

Mar 14 13:51:15 wil-xxxxxxxxxx01 user:info WebSphere Broker v7005[23265482]: (FTMBROKER1.Generic_WTX)[8997]BIP7050E: Failed to locate Java class com.ibm.websphere.dtx.m4excel. : FTMBROKER1.00a69ae2-4901-0000-0080-f606755da126: /build/S700_P/src/DataFlowEngine/NativeTrace/ImbNativeTrace.cpp: 698: getClasses: :

It works in Windows 2008 R2 where I have the Design Studio and Runtime.

It gives this error in an AIX box that has only the Runtime.

I have changed the CLASSPATH to have: /opt/ibm/wsdtx/libs/m4excel.jar: but it didn't help.

From "env": CLASSPATH=/opt/fxhv200/run/classes:/opt/fxhv200/run/classes/*:/opt/ibm/wsdtx/libs/m4excel.jar:/db2home/icetqa/sqllib/java/db2java.zip:/db2home/icetqa/sqllib/function:/db2home/icetqa/sqllib/java/db2jcc_license_cu.jar:/db2home/icetqa/sqllib/tools/clpplus.jar:/db2home/icetqa/sqllib/tools/antlr-3.2.jar:/db2home/icetqa/sqllib/tools/jline-0.9.93.jar:/db2home/icetqa/sqllib/java/db2jcc.jar:.

Thank you for your help, Tony

ibmwtx commented 8 years ago

Hi Tony, Did you add all the Apache POI version 3.13 jars ( commons-codec-xx.jar, commons-logging-xx.jar, log4j-xx.jar, poi.jar, poi-excelant.jar, poi-ooxml.jar, poi-ooxml-schemas.jar, xmlbeans-2.6.0.jar) to the class path ?

tony2nd commented 8 years ago

Hello,

I have added the 3.13 jars to the CLASSPATH but I am still having the errors on the log.

Note: The output file was created and the wtx map ended OK.

The same error happened four times: Mar 15 10:01:56 wil-pictdb2qas01 user:info WebSphere Broker v7005[12255296]: (FTMBROKER1.Generic_WTX)[8997]BIP7050E: Failed to locate Java class com.ibm.websphere.dtx.m4excel. : FTMBROKER1.00a69ae2-4901-0000-0080-f606755da126: /build/S700_P/src/DataFlowEngine/NativeTrace/ImbNativeTrace.cpp: 698: getClasses: : Mar 15 10:01:56 wil-pictdb2qas01 user:info WebSphere Broker v7005[12255296]: (FTMBROKER1.Generic_WTX)[11310]BIP7050E: Mar 15 10:02:15 wil-pictdb2qas01 user:info WebSphere Broker v7005[12255296]: (FTMBROKER1.Generic_WTX)[8997]BIP7050E: Mar 15 10:02:15 wil-pictdb2qas01 user:info WebSphere Broker v7005[12255296]: (FTMBROKER1.Generic_WTX)[11567]BIP7050E:

The changed CLASSPATH: CLASSPATH=/opt/IBM/mqsi/7.0/classes/ConfigManagerProxy.jar:/opt/IBM/mqsi/7.0/classes/brokerutil.jar:/usr/mqm/java/lib/com.ibm.mq.commonservices.jar:/usr/mqm/java/lib/com.ibm.mq.headers.jar:/usr/mqm/java/lib/com.ibm.mq.jar:/usr/mqm/java/lib/com.ibm.mq.jmqi.jar:/usr/mqm/java/lib/com.ibm.mq.pcf.jar:/usr/mqm/java/lib/connector.jar:/usr/mqm/java/lib/com.ibm.mqjms.jar:/opt/IBM/mqsi/7.0/messages:/var/mqsi/common/wsrr:/opt/fxhv200/run/classes:/opt/fxhv200/run/classes/*:/opt/ibm/wsdtx/libs/m4excel.jar:/opt/ibm/wsdtx/libs/commons-codec-1.9.jar:/opt/ibm/wsdtx/libs/commons-logging-1.1.3.jar:/opt/ibm/wsdtx/libs/log4j-1.2.17.jar:/opt/ibm/wsdtx/libs/poi-3.13-20150929.jar:/opt/ibm/wsdtx/libs/poi-excelant-3.13-20150929.jar:/opt/ibm/wsdtx/libs/poi-ooxml-3.13-20150929.jar:/opt/ibm/wsdtx/libs/poi-ooxml-schemas-3.13-20150929.jar:/opt/ibm/wsdtx/libs/xmlbeans-2.6.0.jar:/opt/ibm/wsdtx/wmqi/dtxwmqi.jar:/opt/ibm/wsdtx/libs/dtxpi.jar:/db2home/icetqa/sqllib/java/db2java.zip:/db2home/icetqa/sqllib/function:/db2home/icetqa/sqllib/java/db2

Tony

tony2nd commented 8 years ago

I have added a trace:

<12255296-8997-Tue Mar 15 10:36:13 2016>: FileName | BN-xxxxxxx-WTX.xlsx <12255296-8997-Tue Mar 15 10:36:13 2016>: Worksheet | Sheet1 <12255296-8997-Tue Mar 15 10:36:13 2016>: Template | Facility_xxx_xxx_XLS.xlsx <12255296-8997-Tue Mar 15 10:36:13 2016>: Trace file | m4excel.mtr <12255296-8997-Tue Mar 15 10:36:13 2016>: Trace append | false <12255296-8997-Tue Mar 15 10:36:13 2016>: Trace error | false <12255296-11567-Tue Mar 15 10:36:13 2016>: [compareConnection] <12255296-11567-Tue Mar 15 10:36:13 2016>: [compareConnection](rc = -2) * ERROR * <12255296-11310-Tue Mar 15 10:36:13 2016>: [compareConnection] <12255296-11310-Tue Mar 15 10:36:13 2016>: [compareConnection](rc = -2) * ERROR * <12255296-11053-Tue Mar 15 10:36:13 2016>: [compareConnection] <12255296-11053-Tue Mar 15 10:36:13 2016>: [compareConnection](rc = -2) * ERROR * <12255296-10796-Tue Mar 15 10:36:13 2016>: [compareConnection] <12255296-10796-Tue Mar 15 10:36:13 2016>: [compareConnection](rc = -2) * ERROR * <12255296-11824-Tue Mar 15 10:36:13 2016>: [onNotify] <12255296-11824-Tue Mar 15 10:36:13 2016>: | OnNotify called for PUTSTART <12255296-11824-Tue Mar 15 10:36:13 2016>: [onNotify](rc = 0) OK <12255296-11824-Tue Mar 15 10:36:13 2016>: [beginTransaction] <12255296-11824-Tue Mar 15 10:36:13 2016>: | Starting transaction <12255296-11824-Tue Mar 15 10:36:13 2016>: [beginTransaction](rc = 0) OK <12255296-11824-Tue Mar 15 10:36:13 2016>: [put] <12255296-11824-Tue Mar 15 10:36:13 2016>: | DATA = ... <12255296-11824-Tue Mar 15 10:36:16 2016>: [put](rc = 0) OK <12255296-11824-Tue Mar 15 10:36:16 2016>: [endTransaction] <12255296-11824-Tue Mar 15 10:36:16 2016>: [endTransaction](rc = 0) OK <12255296-11824-Tue Mar 15 10:36:16 2016>: [onNotify] <12255296-11824-Tue Mar 15 10:36:16 2016>: | OnNotify called for PUTSTOP <12255296-11824-Tue Mar 15 10:36:16 2016>: | Closing trace file and exiting function <12255296-11824-Tue Mar 15 10:36:16 2016>: [onNotify](rc = 0) OK