JDBC Adapter Message Monitoring

[Former Member]

Hi All,

I have configured a sender JDBC adapter. The adapter status is green. The message is Processing finished sucessfully. But I can not find any msg in SXMB_MONI.

I can not see any msg in msg monitoring also.

Any input on this will be highly appreciated.

Regards,

Jai Shankar.

[Former Member · Accepted solution]

Hi Jai,

Follow the steps in this blog and see what happens..

/people/michal.krawczyk2/blog/2005/05/10/xi-i-cannot-see-some-of-my-messages-in-the-sxmbmoni

cheers,

Prashanth

[bhavesh_kantilal]

Jai,

If you do not see any message in SXMB_MONI, look into the Select QUesry. Execute the SELECT query on your DB client and see if it returns any rows?

Also, trun any other scenario of XI and check if you are getting an entry in SXMB_MONI.

If things still dont work, try reactivating your JDBC adapter and restarting XI and your Database.

Regards,

Bhavesh

[Former Member]

What happened?

[Former Member]

Hi,

My id is jaishankar.ramakrihsnan@caritor.com.

Regards,

Jai Shankar.

[Former Member]

Ok Jai,

Send me ur mail id.. I shall send you a pdf on JDBC adapters.. Go thru that, and reconfigure ur scenario

cheers,

Prashanth

P.S Please mark helpful answers

[Former Member]

Did you check the trace level??

[Former Member]

Hi Jai,

Could you check transaction SMQ2 and see if there are any messages in the queue?

cheers,

Prashanth

[Former Member]

Hi,

Nothing is present in queues.

regards,

Jai

[moorthy]

Hi,

If there is no error in the RWB->Adapter Monitoring->JDBC->communication channel. and in the message monitoring->MDT(Message Display Tool) , then try to check the trace level of SXMB_MONI.

If you don;t have any error in these, then the message is not reached into IntegrationEngine.

Also activating the Sender Agreement once again may help you

/people/michal.krawczyk2/blog/2005/05/10/xi-i-cannot-see-some-of-my-messages-in-the-sxmbmoni

Regards,

Moorthy

[Former Member]

Hi All,

No success yet.

In message monitoring I can not find my msg.

Thanks & Regards,

Jai Shankar.

[Former Member]

Hi Jai,

Any success :-)??

[Former Member]

If that does not work , then do this

Can you check the following,

1. Check the SELECT query in your Sender JDBC adapter. Does it actually return any rows?

2. The values enterd for Documentname and DocumentNamespace in your Sender JDBC adapter. You have to enter the name of the Datatype and the namespace in these fields.

3.Have you enterd these details while doing the adapter configuration,

jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name (database name)>

Driver oracle.jdbc.driver.OracleDriver

Another thing that is to be checked is, if the table strucutre has changed in the database, if yes, deactivate and activate the Sender Adapter once again and it should work.

[Former Member]

Jai,

Reduce your polling interval to about 10 secs and check out whether the message is posted in moni

[Former Member]

Jai,

Reduce your polling interval to about 10 secs and check out whether the message is posted in moni

[Former Member]

Jai,

Check the following:

1.What is the polling interval set in the sender JDBC adapter?

2.What is your query written in the Sender JDBC adapter?

3.Do you have data in your source table?

cheers,

Prashanth

[Former Member]

Hi Prashanth,

1. Polling interval is 60 sec.

2. Select * from <table-name> where <field-name> = 'jai'

3. I have data in table.

Thanks & Regards,

jai shankar.