JDBC sender adapter can not get any message

[Former Member]

HI~

I have a problem with my JDBC Sender which reads data from a SQL Server. Previously it was working fine but It is not Picking the records from the JDBC table.

I have checked in RWB communication Channel monitoring there no any error or success messages but channel is showing healthy status only(Green).

User's authorization and SQL statement is all right. I checked the SQL in the DB and there are some messages that should be processed.

I also inactive and active the Comunication Channel.

I also checked the LOCKING ADAPTER in Visual Administration is nothing.

BUT the same configuration in DEV system are work perfectly.

I don't want to restart XI,because is PRD system.

[dharamveer_gaur2]

Hi

look this thread

Try slecting option Dissconnect after each message.

[Former Member]

Hi,

1 ) What is exact audit log message ?

2) Try fetching the count in SQL statement if there are any valid records it will give the count.

May for testing you can use <TEST> in update statement.

3) Have you used taskTimeout parameter ?

4) Are multiple channels polling on same table ?

regards

Ganga

[Former Member]

Hi,

Try for these things,

1) Try for Cash refresh

2) Check XIP physical box having JDBC Server access.

3) Cross check with your SQL statement.

4) Delete and recreate the communication channel.

Regards,

Boopathi