Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Maximo 7.5 Upgrade - Integration Stopped Working

From: dave.littley (2012-01-04 18:28)

We recently upgraded to Maximo 7.5.
Prior to the upgrade, we had the integration set up to use interface tables for the items, inventory, and meters. After the upgrade, it stopped working.
The tricky part is that it seems to run fine. The entries get put into the interface table and the queue table. Maximo processes the queue and the record is removed from the queue table. No errors get put into the message reprocessing log.
But unfortunately, nothing is changed in the data. I dug through the log files a bit and see where it attempted to change the data, but it gives a 'Data array returned without transformation. bidiFormat is null' message (error?). I've attached the portion of the log file below.
Has anyone had a similar problem, or have any ideas how to fix it? Any help would be greatly appreciated.
Dave Littley
Log File:
[1/4/12 9:39:33:273 PST] 00000035 SystemOut O 04 Jan 2012 09:39:33:273 [INFO] [MXServer] [CID-CRON-29654] cronAction start for Integration crontask JMSQSEQCONSUMER.SEQQOUT for queue=jms/maximo/int/queues/sqout with selector= for server MXServer
[1/4/12 9:39:33:273 PST] 00000035 SystemOut O 04 Jan 2012 09:39:33:273 [DEBUG] [MXServer] [CID-CRON-29654] Error reading ERRORQUEUE property - setting default value to false for cron JMSQSEQCONSUMER.SEQQOUT
[1/4/12 9:39:33:273 PST] 00000035 SystemOut O 04 Jan 2012 09:39:33:273 [DEBUG] [MXServer] [CID-CRON-29654] got consumer psdi.iface.jms.JMSQueueConsumer@1a0f1a0f for task JMSQSEQCONSUMER.SEQQOUT with queue name jms/maximo/int/queues/sqout with selector and processor psdi.iface.jms.QueueToDestManagerProcessor and error handler psdi.iface.jms.MessageErrorHandler@5e905e90 server name MXServer
[1/4/12 9:39:33:273 PST] 00000035 SystemOut O 04 Jan 2012 09:39:33:273 [INFO] [MXServer] [CID-CRON-29654] cronAction end for Integration crontask JMSQSEQCONSUMER.SEQQOUT for queue=jms/maximo/int/queues/sqout with selector= for server MXServer
[1/4/12 9:39:33:273 PST] 00000035 SystemOut O 04 Jan 2012 09:39:33:273 [INFO] [MXServer] [CID-CRON-29654] Correlated data: BEGIN InstanceName:SEQQOUT TaskName:JMSQSEQCONSUMER ElapsedTime:0 ms END
[1/4/12 9:39:33:273 PST] 00000050 SystemOut O 04 Jan 2012 09:39:33:273 [INFO] [MXServer] [CID-CRON-29655] Correlation started.
[1/4/12 9:39:33:273 PST] 00000050 SystemOut O 04 Jan 2012 09:39:33:273 [INFO] [MXServer] [CID-CRON-29655] cronAction start for Integration crontask JMSQSEQCONSUMER.SEQQIN for queue=jms/maximo/int/queues/sqin with selector= for server MXServer
[1/4/12 9:39:33:273 PST] 00000050 SystemOut O 04 Jan 2012 09:39:33:273 [DEBUG] [MXServer] [CID-CRON-29655] Error reading ERRORQUEUE property - setting default value to false for cron JMSQSEQCONSUMER.SEQQIN
[1/4/12 9:39:33:273 PST] 00000050 SystemOut O 04 Jan 2012 09:39:33:273 [DEBUG] [MXServer] [CID-CRON-29655] got consumer psdi.iface.jms.JMSQueueConsumer@6a526a52 for task JMSQSEQCONSUMER.SEQQIN with queue name jms/maximo/int/queues/sqin with selector and processor psdi.iface.jms.QueueToMaximoProcessor and error handler psdi.iface.jms.MessageErrorHandler@5e5e5e5e server name MXServer
[1/4/12 9:39:33:273 PST] 00000050 SystemOut O 04 Jan 2012 09:39:33:273 [INFO] [MXServer] [CID-CRON-29655] cronAction end for Integration crontask JMSQSEQCONSUMER.SEQQIN for queue=jms/maximo/int/queues/sqin with selector= for server MXServer
[1/4/12 9:39:33:273 PST] 00000050 SystemOut O 04 Jan 2012 09:39:33:273 [INFO] [MXServer] [CID-CRON-29655] Correlated data: BEGIN InstanceName:SEQQIN TaskName:JMSQSEQCONSUMER ElapsedTime:0 ms END
[1/4/12 9:39:34:617 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:617 [INFO] [MXServer] [CID-CRON-29656] Correlation started.
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] schemauseinclude==true
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] 1 openTagsList size 0
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] METERDATA closing open tags for parent count===0
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] Enter -> bidiTransformInboundData(String extSystemName: EXTSYS3, byte[] data: [Data detailed below...])
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] Enter -> getBidiFormat(String extSystemName: EXTSYS3)
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] ExtSystemInfo: psdi.iface.mic.ExtSystemInfo@51d451d4
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] bidiFormat: null
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] bidiFormat: null
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] Step-in -> Calling this.bidiTransformInboundData(data, bidiFormat)
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] Enter -> bidiTransformInboundData(byte[] data: <?xml version="1.0" encoding="UTF-8"?><SyncMXMETERDATA xmlns="http://www.ibm.com/maximo" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" creationDateTime="2012-01-04T09:39:34-08:00" baseLanguage="EN" messageID="132569877463269281"><MXMETERDATASet><METERDATA action="REPLACE"><ASSETMETERID>1001</ASSETMETERID><ASSETNUM>310-CR-0058</ASSETNUM><METERNAME>310CR0058</METERNAME><NEWREADING>1991.764</NEWREADING><NEWREADINGDATE>2012-01-04T02:00:47-08:00</NEWREADINGDATE><ORGID>CUMTN</ORGID><SITEID>COPMINE</SITEID></METERDATA></MXMETERDATASet></SyncMXMETERDATA>, String bidiFormat: null)
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] Data array returned without transformation. bidiFormat is null
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] queue name =jms/maximo/int/queues/cqin
[1/4/12 9:39:34:632 PST] 00000045 SystemOut O 04 Jan 2012 09:39:34:632 [DEBUG] [MXServer] [CID-CRON-29656] trackMessage MSG_TRK_ENABLED is false


From: Brian Swanson (2012-01-04 15:50)

HI Dave,
Have you checked the interface tables and logic to make sure that the new
functionality like reorder field is being accounted for. I had the
similar thing happen in early development when I did not account for some
new functionality..
Brian Swanson
Systems Analyst-Maximo
Information Technology
HermanMiller
From: "dave.littley" <dave.littley@yahoo.ca>
To: MAXIMO@yahoogroups.com
Date: 01/04/2012 01:28 PM
Subject: [MAXIMO List] Maximo 7.5 Upgrade - Integration Stopped
Working
Sent by: MAXIMO@yahoogroups.com

We recently upgraded to Maximo 7.5.
Prior to the upgrade, we had the integration set up to use interface
tables for the items, inventory, and meters. After the upgrade, it stopped
working.
The tricky part is that it seems to run fine. The entries get put into the
interface table and the queue table. Maximo processes the queue and the
record is removed from the queue table. No errors get put into the message
reprocessing log.
But unfortunately, nothing is changed in the data. I dug through the log
files a bit and see where it attempted to change the data, but it gives a
'Data array returned without transformation. bidiFormat is null' message
(error?). I've attached the portion of the log file below.
Has anyone had a similar problem, or have any ideas how to fix it? Any
help would be greatly appreciated.
Dave Littley


From: dave.littley (2012-01-05 02:52)

Figured it out... had to enable some code in a couple of XML files and then rebuild the ear file.
Dave
--- In MAXIMO@yahoogroups.com, Brian Swanson <brian_swanson@...> wrote:
>
> HI Dave,
> Have you checked the interface tables and logic to make sure that the new
> functionality like reorder field is being accounted for. I had the
> similar thing happen in early development when I did not account for some
> new functionality..
>
>
>
> Brian Swanson
> Systems Analyst-Maximo
> Information Technology
>
>
> HermanMiller
>
>
>
> From: "dave.littley" <dave.littley@...>
> To: MAXIMO@yahoogroups.com
> Date: 01/04/2012 01:28 PM
> Subject: [MAXIMO List] Maximo 7.5 Upgrade - Integration Stopped
> Working
> Sent by: MAXIMO@yahoogroups.com
>
>
>
>
> We recently upgraded to Maximo 7.5.
>
> Prior to the upgrade, we had the integration set up to use interface
> tables for the items, inventory, and meters. After the upgrade, it stopped
> working.
>
> The tricky part is that it seems to run fine. The entries get put into the
> interface table and the queue table. Maximo processes the queue and the
> record is removed from the queue table. No errors get put into the message
> reprocessing log.
>
> But unfortunately, nothing is changed in the data. I dug through the log
> files a bit and see where it attempted to change the data, but it gives a
> 'Data array returned without transformation. bidiFormat is null' message
> (error?). I've attached the portion of the log file below.
>
> Has anyone had a similar problem, or have any ideas how to fix it? Any
> help would be greatly appreciated.
>
> Dave Littley
>
>
>
>
>
>
>


From: Rae Simpson (2012-01-06 01:47)

Here are the gory details of the solution:
Browse to: C:\ibm\SMP\maximo\applications\maximo\mboejb\ejbmodule\META-INF
2 files need to have XML enabled: ejb-jar.xml and ibm-ejb-jar-bnd.xmi
Scan down to find sections - <!-- MEA MDB --> and
<!-- MEA MDB for error queue --->
Uncomment those sections in both files. Rebuild the EAR, Deploy and away she goes.
Thanks to Eugene Bonks at IBM support!

--- In MAXIMO@yahoogroups.com, "dave.littley" <dave.littley@...> wrote:
>
> Figured it out... had to enable some code in a couple of XML files and then rebuild the ear file.
>
> Dave
>
> --- In MAXIMO@yahoogroups.com, Brian Swanson <brian_swanson@> wrote:
> >
> > HI Dave,
> > Have you checked the interface tables and logic to make sure that the new
> > functionality like reorder field is being accounted for. I had the
> > similar thing happen in early development when I did not account for some
> > new functionality..
> >
> >
> >
> > Brian Swanson
> > Systems Analyst-Maximo
> > Information Technology
> >
> >
> > HermanMiller
> >
> >
> >
> > From: "dave.littley" <dave.littley@>
> > To: MAXIMO@yahoogroups.com
> > Date: 01/04/2012 01:28 PM
> > Subject: [MAXIMO List] Maximo 7.5 Upgrade - Integration Stopped
> > Working
> > Sent by: MAXIMO@yahoogroups.com
> >
> >
> >
> >
> > We recently upgraded to Maximo 7.5.
> >
> > Prior to the upgrade, we had the integration set up to use interface
> > tables for the items, inventory, and meters. After the upgrade, it stopped
> > working.
> >
> > The tricky part is that it seems to run fine. The entries get put into the
> > interface table and the queue table. Maximo processes the queue and the
> > record is removed from the queue table. No errors get put into the message
> > reprocessing log.
> >
> > But unfortunately, nothing is changed in the data. I dug through the log
> > files a bit and see where it attempted to change the data, but it gives a
> > 'Data array returned without transformation. bidiFormat is null' message
> > (error?). I've attached the portion of the log file below.
> >
> > Has anyone had a similar problem, or have any ideas how to fix it? Any
> > help would be greatly appreciated.
> >
> > Dave Littley
> >
> >
> >
> >
> >
> >
> >
>