one xi jdbc communication channel dead?

[former_member186158]

It is jdbc sender.

I found that XI didn't read data from the table.

log info in cc monitoring is:

4/21/10 3:38:29 PM Processing started

4/21/10 3:26:29 PM Processing started

4/21/10 3:20:29 PM Processing started

4/21/10 3:19:53 PM Processing started

4/21/10 3:16:21 PM Processing started

4/21/10 3:10:21 PM Processing started

4/20/10 5:14:17 PM Processing started

4/20/10 5:08:22 PM 094538a3-5dca-4edd-1468-91b1230cabc2 Polling interval started. Length: 360.0 seconds

4/20/10 5:08:22 PM 094538a3-5dca-4edd-1468-91b1230cabc2 Processing finished successfully

4/20/10 5:08:17 PM Processing started

4/20/10 5:02:20 PM 094538a3-5dca-4edd-1468-91b1230cabc2 Polling interval started. Length: 360.0 seconds

4/20/10 5:02:20 PM 094538a3-5dca-4edd-1468-91b1230cabc2 Processing finished successfully

4/20/10 5:02:17 PM Processing started

4/20/10 4:56:28 PM 094538a3-5dca-4edd-1468-91b1230cabc2 Polling interval started. Length: 360.0 seconds

4/20/10 4:56:28 PM 094538a3-5dca-4edd-1468-91b1230cabc2 Processing finished successfully

4/20/10 4:56:17 PM Processing started

it looks like stopped at 4/20/10 5:14:17 PM.

ALL the other CCs works fine.

This happens before, I have to restart the PI Server.

Any ideas?

Thanks and regards

Edited by: Shen Peng on Apr 21, 2010 9:49 AM

Edited by: Shen Peng on Apr 21, 2010 9:50 AM

[former_member186158]

set parameter: taskTimeout

[Former Member]

HI

It seems there is no data in your table , just look into your Db table , if you haev access to it , or ask you DB guys to see if your table is locked for any reason or it may happen that yout channel itself is locked

Pl look into it and revert

rgds

mojib

[Former Member]

Hi,

I have faced same issue.But i resolved it.I think u r table have no data.If table have data,just made some changes in the jdbc channel configaration and activate it.

Then u r problem will resolved.

Thanks

Ravi

[former_member186158]

It didn't work.

Until I copy another cc from this and the data came through.

I still didn't know why.

[Former Member]

Until I copy another cc from this and the data came through.

can you please elaborate

rgds

mojib

[former_member186158]

copy an new channel from this channel, and replace it in sender agreement.

[Former Member]

Pl try Ravi Alla's suggestion , I think it should solve your problem

rgds

mojib

[former_member200962]

1) There may not be any new data to be picked from the DB

2) The JDBC adapter might be locked and hence no message was picked....log will still show processing completely successfully.

Regards,

Abhishek.