How to configure the integration using Interface table?

[whell]

Does anybody knows how to configure the integration using the interface table? Currrently I'm doing some integration to pull the data from the other database into maximo database. I created an external systems and create the interface table using the select action found on Enterprise systems. Inside the maximo database it creates automatically the 3 tables (asset_interface, MXIN_INTER_TRANS,MXOUT_INTER_TRANS). I tried to insert new records on Asset_interface table and insert new records on MXIN_INTER_TRANS. As the interface cron task run, the records in MXIN_INTER_TRANS was automatically deleted (means the records already on process on jms queue). The problem now is that I can't find any records being processed inserted in maximo main table let say asset. I can't find any error  being displayed on systemout.log.

I hope anybody already explore the same scenarios and will be able to give me the best solutions.


Thank you so much.

whell

[vijet]

Hi Whell,

Even i have the same problem.. The record in MXIN_INTER_TRANS is deleted but nothing is inserted in the business table... Did you get any solution for this.. I have tried the web but no luck as of now. Can anybody shed light on this.

Regards
Vijet

[vijet]

Hi All,

I identified the reason for the problem..... The jms queue was throwing the null pointer exception... Now there is one thing that i have come across while inserting the records into MXIN_INTER_TRANS table.. The action column in the table needs to be given some keyword like Add,Change,Delete,AddChange etc....

Add :              Insert the data provided in the message.
Delete:            Delete the parent data, and any related child data, from the database.
Change:          Update parent and child data per the contents of the message, but do not delete existing child data not explicitly specified in the message.
Replace:          Replace the existing record(s) with the contents of the message and delete existing child data not referenced in the message.
AddChange:    If the primary record does not exist, process as Add action; otherwise, process as a  Change action.
Null:                If the primary record does not exist, process as Add action; otherwise, process as a Replace action.

I initially tried the add action but i got the error that there was no record for the key value as in interface table in my business table...

Scenario:  I have a developer table in maximo with developerid as key column. I have created the interface table for the same. Now if i specify the action as add in the MXIN_INTER_TRANS table, the record is picked from the MXIN_INTER_TRANS table and put in the queue. Now maximo checks for the record with the developerid specified in interface table to that in developer table. if it does not find any then it should insert the new record.. In my case its not happening... I am getting a null pointer exception.. But if i manually insert a record in developer table and then reload the crontask for inbound transaction then the record gets updated with the new values coming from interface tables... Dont know what is the problem in inserting the new record... The scenario is the same for Add, AddChange or if i leave the action column as null....

Can anybody give an idea how i can insert the new record.....

[vijet]

Hi All,

The error was in the add method of the MBO.. After the modification to the class and redeployment everything went fine.

Now i am successfully able to import and export to and from maximo to the interface tables...

Thanks
Vijet

[whell]

Hello vijet,

 Sorry for my late response actually I'm also stuck up with same problem. Can please help also with this what method or class i should modify. ? or can you share with me the modified class..

Thank you so much

[Today]

• How to get list data whic... by kvnaresh [Today at 12:39:03 am]
• How to change an email ad... by kvnaresh [Today at 12:25:57 am]
• Difference between fixpac... by jithu1989 [Yesterday at 05:25:18 am]
• Maximo Programmer Require... by ravikorukonda [February 06, 2012, 05:59:58 pm]
• Demo Maximo 7.1 Online by hyubby [February 06, 2012, 11:05:43 am]
• Error loading the Object ... by G Jeevan [February 06, 2012, 07:21:36 am]
• plzz attribute in another... by Dileep Kumar [February 06, 2012, 07:02:09 am]
• Jpeg attachments within M... by zenagarfield [February 02, 2012, 02:02:53 pm]
• How to change senders ema... by zenagarfield [February 02, 2012, 10:28:06 am]
• Lead and Crew by G Jeevan [February 02, 2012, 07:08:45 am]