cancel
Showing results for 
Search instead for 
Did you mean: 

Sender JDBC channel stop send messages

Former Member
0 Kudos

Hi,

We have a sender JDBC scenario which is working correctly time ago.

However, sometimes this channel stop sending messages although the Adapter Monitor shows that they regularly execute the polling interval.

We have confirmed that there isn't any connection from XI to target BD.

In other ocasions, we are required to restart XI and, after that, this scenario works without any problem.

What could be the cause?

How to solve it?

thanks, in advance

Carme

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Sometimes though the adapter monitor shows it as green, you need to check the messages where it will tell you polling interval started, polling not finished.

If that is the case, there is no other fix rather than restarting XI server.

This is due to the improper installation of SAP-XI.

Regards

Krish

Former Member
0 Kudos

Hi , Krish

You are right: polling process is started but not finished.

We have restarted our XI system for this reason 3 times, but now, we need a definitive solution. We have a great volume of scenarios and nearly 3.000 messages per day!

If this issue is due to a improper installation... ¿how to confirm that this is really the problem? ¿how to solve it? ¿have you experience the same issue?

thanks,

Carme

Former Member
0 Kudos

Sorry... real volume nearly 30.000 message per day.

And Bhavesh, there is no change in any driver.

Carme.

bhavesh_kantilal
Active Contributor
0 Kudos

Can you select the option Disconnect From Database after each message processing in the Sender JDBC adapter and then see if you get this issue again.

Regards

Bhavesh

Former Member
0 Kudos

Thanks, for you reply.

Check "disconnect from database after Processing each message" is enabled from the first day. So, this doesn't solve the problem.

Any other input, please?

Carme

bhavesh_kantilal
Active Contributor
0 Kudos

This is rather strange.

A few of my observations -

1. When the sender jdbc adapter polls , and there is no data matching the select query, you will still see a message id in Comm Channel Monitoring but with no hyper link.

2. The actual message id / message is created only if there is data in the database and also the hyper link is enabled.

3. If you are confident that the data is being commited on the database and that it is XI not pulling the right data, one issue might be - driver issues. Can you check if you have the right compatible drivers for your database on XI server - is there a new'er driver available?

We hit a similar issue with JMS adapters and we learnt that the JMS server had been updated as a result of which a new driver had to be installed which we did not until we hit intermittent problems like these.

Hope this helps

Regards

Bhavesh