JDBC Adapter Level Error

[Former Member]

Hi Guys,

i am getting below error at JDBC Adapter Level.

Can any one please help me on how to resolve this issue.

JDBC Message processing failed, due to Channel has reached maximum concurrency (5,000 concurrent messages) and no free resource found within 5,000 milliseconds; increase the maximum concurrency level

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Channel has reached maximum concurrency (5,000 concurrent messages) and no free resource found within 5,000 milliseconds; increase the maximum concurrency level

Adapter Framework caught exception: Channel has reached maximum concurrency (5,000 concurrent messages) and no free resource found within 5,000 milliseconds; increase the maximum concurrency level

Delivering the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Channel has reached maximum concurrency (5,000 concurrent messages) and no free resource found within 5,000 milliseconds; increase the maximum concurrency level. Setting message to status failed.

Thanks,

Siva.

[rajasekhar_reddy14 · Accepted solution]

Hi Siva,

How many receiver JDBC communication channels you have created in ID, create one receiver JDBC channel and set maximum concurrency value as 3.

You problem get solved.

Regards,

Raj

[Former Member · Accepted solution]

Hi Raj,

Thanks for ur help.

created 4 JDBC communication channels in ID. This error i got in Production system. now i can not change in production environment. can u pls give me some other solution..?

how i will set max concurency value as 3 ? and where i will set these parameter ..? can u pls send me step by step procedure pls...

Regards,

Siva.

[rajasekhar_reddy14 · Accepted solution]

You no need to do anything wait sometime all messages will get processed , concurrency errors comes when all JDBC connections consumed by other JDBC channels .

If you are looking for quick solution stop the channel and start it works.

Maximum concurrence value you have to set in JDBC receiver channel by default that value is 1, you can set maximum 5,but bets practice is setting 3 is good idea,if load less then set value as 1 only

[Former Member · Accepted solution]

Hi Raj,

Thanks for ur help.

Now i am not getting any error messgaes. only i got one error messgae alert.

But could u pls let me know the step by step where i will set default value in JDBC Communication channel..? any specific tab or some thing..? pls share me...

i will do accordingly..

Thanks,

Siva.

[rajasekhar_reddy14 · Accepted solution]

As i said this error wont occur regularly , if JDBC connections consumed by other channels then only this error occurs (after some times it goes off once connection available).

If you want to set max concurenecy value in JDBC receiver chennal, Open JDBC Channel , you will find tab with min value as 1.

Regards,

Raj

[naveen_chichili · Accepted solution]

Hi,

You need to increase the concurrency threads to solve the issue.This occurs when all the existing threads in PI server are utilized.

Regards,

Naveen

[baskar_gopalakrishnan2]

You have solution here...

http://forums.sdn.sap.com/thread.jspa?threadID=1629787