JDBC Sender Channel problem. Pls help

[Former Member]

Hi All,

JDBC Sender Channel details

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@20.198.58.12:1527:IXI

user name

password

In query statement when I give --- select * from usr02

usr02 is custom table name in XI server which has many records

In Communication Channel monitoring Details it shows --

Polling interval started. Length: 5.0 seconds

Processing finished successfully

But no message is displayes in Message Monitoring -- Adapter Engine and also in SXMB_MONI.

Pls suggest.

[Former Member]

Hi

CC is polling that means CC is configured correctly. But looks like on relevant data exists on the ip provided and the table name specified.

Regards

Monika

[prateek]

Try changing your SQL statement and see if it still doesn't work. e.g.

select ABC from usr02 where XYZ = 'xx'

Regards,

Prateek

[former_member200962]

This can happen when:

1) There is no new data to be picked from the table

2) The sender JDBC channel is locked....check the same in Visual Admin.

Regards,

Abhishek.

[Former Member]

Hi,

Did the IP address provided is your source database i.e PI Database ? Cross check the same

looks like there is no data maintained in that table in the current database..

In CC you must be seeing the MessageID which does not contain any URL associated to it...then it means there is no data to process or fetch...

HTH

Rajesh