[ramona]

Hi there,
I'm currently investigating whether a message can be pushed to the message center (via xml may be?) without an object being affected in OTM.

I'm trying to send a notification to users for orders not present in OTM yet but received via an integration service.

Does someone know which db table get updated when a message is ready to be read for a message center and if it is possible for a message to be triggered without an object present in OTM? How can something be pushed to the message centre without using contact notification event and agent? Can an xml be used?

Your assistance is greatly appreciated. We need to sign off on a project in the next 2 weeks.

Kind regards,
Ramona (Toll Solutions)

[bmj_23]

Hi Ramona,

The db table that the message centre uses is PROBLEM. So, if you were to load the correct data in to that table (using CSV), you may be able to see those messages in the message centre.

I am not aware of any standard XML interface to do that.

Take a look at the format of the database table and see what has to be populated. It should be relatively quick to test that.

Let me know how you get on.

[chrisplough]

Ramona,

I agree with bmj_23 -- looking at the OTM XML interfaces, there isn't a way to accomplish. If the test that bmj_23 succeeds, then you can look for ways to directly enter the sql and trigger an update.

Just be careful about documenting this, for future patch and migration work. (I know you're aware of this -- Toll has a great reputation, but want others to also consider this.)

--Chris

[ramona]

Thanks Chris and bmj_23.

I was able to load a csv file to populate data in the Problem tb but when clicking on the MESSAGE ID, the page is blank. The issue though is that there is no existing business object affected or created by my pushed data. I had to use a existing predifined NOTIFY_FUNCTION (which doesn't really reflect our desired purpose). The alternative is to push in a csv file in the NOTIFY_FUNCTION tb too and attach it to a style sheet so that it display the error and the message properly. Long process really!!!

The alternative option will to check the facilities available for the Transmission Manager. We want to display failed integration message captured somehow by GC3 but in this project GC3 has no visibility of the failed file. The file is stuck at our integration layer but somehow we want it to be shown to our users.

Any advice is appreciated.

Regards,
Ramona

[chrisplough]

Ramona,

You're right - one of the restrictions to CSV uploads is that they don't kick off any agents or business rules. I've known of GC3 / OTM users who used direct SQL or CSV files to update tables, but don't know how they then trigged the business process to process the data.

You have an interesting point about the TM. When the file gets stuck within your integration layer, is there any resulting error shown in the Transmission Manager? My only other thought would be to have an agent monitor for that particular error and then kick off an event.

--Chris