Topic
  • 5 replies
  • Latest Post - ‏2012-10-05T13:17:40Z by SystemAdmin
SystemAdmin
SystemAdmin
5842 Posts

Pinned topic How export / import data using external systems in TSRM 7.1 ?

‏2008-11-06T17:48:35Z |
Hi to all!
I have a problem, i can not export data using the external systems in my TSRM 7.1.

Some data example for table asset:

In Object Structure: MXASSET have Support Flat Structure checked.

In Publish channel: its defined in MXASSETInterface

In End Point: MXFLATFILE, the attribute FILEDIR is c:\export

In External Systems: EXTSYS1 is enabled, in Publish Channel tab, MXASSETInterface have the endpoint MXFLATFILE, and its enabled. Then click in the button Data Export, in the Data Export Window, press OK,… but nothing happens,.. and c:\export is still empty.

Any idea, how to resolve this issue?
Updated on 2012-10-05T13:17:40Z at 2012-10-05T13:17:40Z by SystemAdmin
  • Freshh
    Freshh
    12 Posts

    Re: How export / import data using external systems in TSRM 7.1 ?

    ‏2008-11-06T18:12:51Z  
    Is your JMS Crontask turned on? In your log file you should see an entry if the data has made it to the queue.
  • SystemAdmin
    SystemAdmin
    5842 Posts

    Re: How export / import data using external systems in TSRM 7.1 ?

    ‏2008-11-06T18:47:57Z  
    • Freshh
    • ‏2008-11-06T18:12:51Z
    Is your JMS Crontask turned on? In your log file you should see an entry if the data has made it to the queue.
    Hi Freshh!

    I dont know why a Crontask is needed?

    Thanks for your help!
  • GT2112
    GT2112
    46 Posts

    Re: How export / import data using external systems in TSRM 7.1 ?

    ‏2008-11-12T21:00:02Z  
    Hi Freshh!

    I dont know why a Crontask is needed?

    Thanks for your help!
    As you are using an external system and an end point, the data is exported to a queue. There is a cron task called JMSQSEQCONSUMER that consumes the sequential queues, inbound and outbound to send the messages to Maximo or your End point, in this case MXFLATFILE.

    You have to enable the cron task instance SEQQOUT in the JMSQSEQCONSUMER cron task.

    If you have configured the loggin properties and enabled the cron task must see as follows in your maximo log

    11/12/08 16:24:31:609 VET 0000003a SystemOut O 12 Nov 2008 16:24:31:609 INFO Integration crontask JMSQSEQCONSUMER.SEQQOUT polling for messages in queue=jms/maximo/int/queues/sqout with selector=
  • kunika
    kunika
    2 Posts

    Re: How export / import data using external systems in TSRM 7.1 ?

    ‏2012-10-05T10:23:48Z  
    Hi,

    I did all the steps reqired to export data from TSRM. But the data is not getting exported. Its getting stuck in the queue. any possible thing m missing?

    Thanks
    Kunika
  • SystemAdmin
    SystemAdmin
    5842 Posts

    Re: How export / import data using external systems in TSRM 7.1 ?

    ‏2012-10-05T13:17:40Z  
    • kunika
    • ‏2012-10-05T10:23:48Z
    Hi,

    I did all the steps reqired to export data from TSRM. But the data is not getting exported. Its getting stuck in the queue. any possible thing m missing?

    Thanks
    Kunika
    If the message stays in the queue then verify the timestamp of the JMSQSEQCONSUMER: is it running as scheduled ?
    Typically messages remain untouched in the queue because Maximo is still in Admin Mode (via Config DB), which halts all cron tasks.