Topic
1 reply Latest Post - ‏2013-03-31T19:41:24Z by R_Simons
SystemAdmin
SystemAdmin
8523 Posts
ACCEPTED ANSWER

Pinned topic WSMQ FTE - Can't make Database JEE Database logger to work

‏2013-03-28T15:40:33Z |
Hi!
My software config is:
OS: Win 2008 R2, SOFT: WebSphere MQ 7.0.1.3 + FTE 7.0.4.2
OS: Win 2008 R2, SOFT: Oracle 11g
OS: CentOS 6.3 x64, SOFT: WebSphere Application Server CE 3.0.0.3
No Active Directory or LDAP used.

What I'm trying to do - is to configure FTE Database JEE Logger.
According to this manual: http://publib.boulder.ibm.com/infocenter/wmqfte/v7r0/index.jsp?topic=%2Fcom.ibm.wmqfte.doc%2Fdl_install_jee_was7.htm
With that manual I couldn't even deploy logger components.
I've started to configure all this stuff.

1) Create user "FTELOG" (with all required permissions) and execute SQL script to create required database objects in Oracle for the logger - check.
2) Take "ojdbc5.jar" and deployed to WAS CE as:
2.1) go to "Resorces/Repository" in WAS CE admin console
2.2) Group: jdbc
Artifact: oracle
Version: 5.00
Type: jar
2.3) click "Install" - success
3) Same for "com.ibm.mqetclient.jar" which is required for "wmq.jmsra.rar" (there's nothing about that in manual, I've find out that bu WAS CE logs)
2.1) go to "Resorces/Repository" in WAS CE admin console
2.2) Group: mq
Artifact: com.ibm.mqetclient
Version: 1.00
Type: jar
2.3) click "Install" - success
4) Create datasource for Oracle database:
4.1) go to Resources/Datasources and "Using the WebSphere CE database pool wizard"
4.2) Database pool name: jdbc/wmqfte-database
Database Type: Oracle Thin
Driver JAR: jdbc/oracle/5.00/jar
DB User Name: FTELOG
DB Password: ***
Host: <my_oracle_IP>
SID: <my_sid>
Port: 1521
but when I specify "Transaction Type: XA" - WAS CE dosen't let me to save the datasource, only LOCAL is supported.
Well, fine, execute "select 1 from dual" - success. Moving next.
5) Deploy "wmq.jmsra.rar" to WAS CE with following deployment plan file:
<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector">

<dep:environment xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">

<!--BTW there's nothing said about "moduleId" in manual,
and without it connector registers with name other than required by logger JEE application (com.ibm.wmqfte.databaselogger.jee.oracle.ear)
as well as about "com.ibm.mqetclient" dependency-->

<moduleId>
<groupId></groupId>
<artifactId>wmq.jmsra.rar</artifactId>
<version></version>
<type>rar</type>
</moduleId>
<dep:dependencies>
<dep:dependency>
<dep:groupId>mq</dep:groupId>
<dep:artifactId>com.ibm.mqetclient</dep:artifactId>
<dep:version>1.0</dep:version>
<dep:type>jar</dep:type>
</dep:dependency>
</dep:dependencies>
</dep:environment>

<resourceadapter>
<resourceadapter-instance>
<resourceadapter-name>WMQ</resourceadapter-name>

<!-- tracing is also not works, log says, that "System.out" is invalid "traceDestination" -->

<!--config-property-setting name="traceEnabled">true</config-property-setting>
<config-property-setting name="traceLevel">1</config-property-setting>
<config-property-setting name="traceDestination">System.out</config-property-setting-->
<workmanager>
<gbean-link>DefaultWorkManager</gbean-link>
</workmanager>
</resourceadapter-instance>
<outbound-resourceadapter>
<connection-definition>
<connectionfactory-interface>javax.jms.ConnectionFactory</connectionfactory-interface>
<connectiondefinition-instance>
<name>jms/WMQFTEJEEDBLoggerRejectQueueCF</name>
<config-property-setting name="queueManager">my_coordinator_qm</config-property-setting>
<config-property-setting name="transportType">CLIENT</config-property-setting>
<config-property-setting name="channel">SYSTEM.DEF.SVRCONN</config-property-setting>
<config-property-setting name="hostName">my_coordinator_qm_IP</config-property-setting>
<config-property-setting name="port">1414</config-property-setting>
<connectionmanager>
<xa-transaction>
<transaction-caching/>
</xa-transaction>
<single-pool>
<max-size>10</max-size>
<min-size>1</min-size>
<blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
<idle-timeout-minutes>2</idle-timeout-minutes>
<match-all />
</single-pool>
</connectionmanager>
</connectiondefinition-instance>
</connection-definition>
</outbound-resourceadapter>
</resourceadapter>
<adminobject>
<adminobject-interface>javax.jms.Queue</adminobject-interface>
<adminobject-class>com.ibm.mq.connector.outbound.MQQueueProxy</adminobject-class>
<adminobject-instance>
<message-destination-name>jms/WMQFTEJEEDBLoggerRejectQueue</message-destination-name>
<config-property-setting name="baseQueueManagerName">my_coordinator_qm</config-property-setting>
<config-property-setting name="baseQueueName">SYSTEM.FTE.DATABASELOGGER.REJECT</config-property-setting>
</adminobject-instance>
</adminobject>
</connector>
So, OK connector is deployed but not yet started.
6) In WAS CE go to "Applications\User Assets\Installed Java EE Connectors" and start "default/wmq.jmsra.rar/1364485042095/rar"
Got "Lifecycle operation failed".
Here's Server Log:

27108: 2013-03-28 17:37:38,718 ERROR GBeanInstanceState Error while starting; GBean is now in the FAILED state: abstractName="default/wmq.jmsra.rar/1364485042095/rar?J2EEApplication=null,JCAConnectionFactory=jms/WMQFTEJEEDBLoggerRejectQueueCF,JCAManagedConnectionFactory=jms/WMQFTEJEEDBLoggerRejectQueueCF,JCAResource=wmq.jmsra,ResourceAdapter=wmq.jmsra,ResourceAdapterModule=default/wmq.jmsra.rar/1364485042095/rar,j2eeType=JCAConnectionManager,name=jms/WMQFTEJEEDBLoggerRejectQueueCF"
27210: 2013-03-28 17:37:38,813 ERROR GBeanInstanceState Error while starting; GBean is now in the FAILED state: abstractName="default/wmq.jmsra.rar/1364485042095/rar?J2EEApplication=null,JCAConnectionFactory=jms/WMQFTEJEEDBLoggerRejectQueueCF,JCAManagedConnectionFactory=jms/WMQFTEJEEDBLoggerRejectQueueCF,JCAResource=wmq.jmsra,ResourceAdapter=wmq.jmsra,ResourceAdapterModule=default/wmq.jmsra.rar/1364485042095/rar,j2eeType=JCAConnectionManager,name=jms/WMQFTEJEEDBLoggerRejectQueueCF"
27294: 2013-03-28 17:37:38,854 ERROR ConfigManagerPortlet Lifecycle operation failed

Got no clue what to do next. Please help!
Updated on 2013-03-31T19:41:24Z at 2013-03-31T19:41:24Z by R_Simons
  • R_Simons
    R_Simons
    4 Posts
    ACCEPTED ANSWER

    Re: WSMQ FTE - Can't make Database JEE Database logger to work

    ‏2013-03-31T19:41:24Z  in response to SystemAdmin
    You are in the wrong forum. Try posting your questions here: http://www.ibm.com/developerworks/forums/forum.jspa?forumID=1816&start=0