JDBC Sender Adapter - NOT FETCHING RECORDS...

[Former Member]

Hello Experts,

I know this was answered in a separate thread ().

However, my question is, Is there a way that we can be notified if a channel has stopped fetching records?

or is there a reporting tool that can be used to check/monitor if a channel is not processing any messages?

Thanks & Kregards,

allar

[Former Member · Accepted solution]

Hi,

alert configuration helps you to send alerts when ever any errors in Communication Channel.........

Sreedhar goud.

[Former Member · Accepted solution]

Hi Sreedhar,

Thanks for your reply.

These case is not being captured by our alert configuration because its not throwing any error.

in the communication channel monitoring, we see only something like this..:

3/16/09 8:25:19 PM Processing started

3/16/09 8:34:20 PM Processing started

3/16/09 8:33:55 PM Processing started

3/16/09 8:32:54 PM Processing started

but no error is being displayed nor sent.

Also, there was a case that the channel just stopped fetching, even though everything is active.

example log:

3/12/09 8:32:54 PM Processing started

We're looking for ways on how we can trap these scenarios as early as possible, get us notified and perform adapter-lock release when needed.

Regards,

allar

[Former Member · Accepted solution]

Hi,

According to SapNote : 1083488

use Advance Mode --> taskTimeout value in Sec

other than we cannot find any alert config

rgds

srini

[Former Member · Accepted solution]

Allar,

Only option which I can see is wtiring JDBC adapter Module which you can call after standard jdbc module. You can check for data and raised an alert base on result.

Hope this will help.

Nilesh

[Former Member]

Hi All,

thanks for all your very useful comments/information...

regards,

allar

[former_member206760]

we had a similar problem with file adapter though...

note 801926,1083488 solved the problem also in advanced mode give

clusterSyncMode value lock in file adapter

[former_member206760]

Dear Alla,

there are no such alerts you can define for that

this is a problem with File adapter taht we faced as well .....you only have the option of restarting the file adapter servce in VA