JDBc Sender: No data coming to PI

[Former Member]

Hi..

Data is being fetched from oracle database through sender JDBC channel...

I have given query statement as:

Select H.Field1,H.field2,L.field3,L.field4

from Table1 H, Table2 L where H.field1= L.field3 order by H.field1

Communication channel is in green state but data is not coming to PI... its generating message ID and in audit log I can see

11.08.2011 10:24:39 Information Channel JDBC_Test: Executed Query successfully, confirmation skipped - data may be send again ("TEST" mode).

11.08.2011 10:24:39 Information Send query result, size 1070865 characters.

How can it be resolved?

Thanks.

Shivanjali

[Former Member]

Hai!

First u check whether your query is picking the data in your Data base.Once it is done then, Check The Message Monitor in RWB

Goto RWB>Message Monitor->in the filter give AdapterEnigne and Daat base overview. Here u can find out whether u got the message in PI or where is the error and etc.

Also , cross check that u gave a correct connection detail.

Regard's

Preethi.

[baskar_gopalakrishnan2]

Just few cents...

Use the same query in toad or some sql client tool and check what do you get for the query? (Test outside PI)

Go to SXMB_MONI and see the payload

use logSQLStatement parameter in the advanced tab of the jdbc channel and set value true. THis gives log trace to get some idea.

[Former Member]

What did you see in response payload before mapping?

[Former Member]

also,

Please verify your structure in IR(ESR) as per your query.

---Divyesh

[rajasekhar_reddy14]

are you sure that Data available in Tables and satisfies your Select statement condition?

if it genarated message id then check payload of message id in CC monitoring

[Former Member]

Yes Data is available.

I cant see message payload in audit log... or in RWB message monitoring..

What all i get in audit log is :

11.08.2011 10:24:39 Information Channel JDBC_Test: Executed Query successfully, confirmation skipped - data may be send again ("TEST" mode).

11.08.2011 10:24:39 Information Send query result, size 1070865 characters.