JDBC Queue Error

[Former Member]

Hi All,

I am getting the following error in my JDBC Adapter:

Delivery of the message to application using connection JDBC_http://sap.com/xi/XI/System failed due to: com.sap.aii.af.ra.ms.api.RecoverableException: Channel has reached maximum concurrency(5,000 concurrent Messages) and no free resourse found within 5,000 milliseconds; Increase the maximum Concurrency Level.

The queue settings are shown below:

AFW.Call.maxConsumers 10

AFW.Recv.maxConsumers 5

AFW.Rqst.maxConsumers 10

AFW.Send.maxConsumers 5

JDBC_http://sap.com/xi/XI/System.Call.maxConsumers 15

JDBC_http://sap.com/xi/XI/System.Recv.maxConsumers 15

JDBC_http://sap.com/xi/XI/System.Rqst.maxConsumers 15

JDBC_http://sap.com/xi/XI/System.Send.maxConsumers 15

Also in my receiver JDBC adapter the Max Concurrency is set to '10'

I don't understand how can error message show that maximum concurrency reached '5000'.

Please Advice

Regards,

XIer

[Former Member]

Self Resolved...

[Former Member]

Hi,

Could you please let us know if this issue was resolved and how, as we are also facing the same problem.

thanks

francis

[Former Member]

We tried with these values and now it works fine:

AFW.Call.maxConsumers 10

AFW.Recv.maxConsumers 5

AFW.Rqst.maxConsumers 10

AFW.Send.maxConsumers 5

JDBC_http://sap.com/xi/XI/System.Call.maxConsumers 20

JDBC_http://sap.com/xi/XI/System.Recv.maxConsumers 10

JDBC_http://sap.com/xi/XI/System.Rqst.maxConsumers 20

JDBC_http://sap.com/xi/XI/System.Send.maxConsumers 10

Regards,

XIER

[Former Member]

hey,

but this issue is not related to the MS.

Then how can you say that this is solved because of that changes which you have made in VisualAdmin.

It is purely related to the Maximum Concurrency Value in the channel configuration of receiver adapter.

Please have a look it once again and provide exact work arround and solution to the problem.

Thanks,

Soorya

[GabrielSagaya]

Check this tuning guide and ask your Basis guys to set the paramters according to this document:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ada5ef-0201-0010-1f8b-c935e444...

If you are setting Maximum Concurrency to a greater value then even check out in the adavance mode Database Transaction Level as isolation level determines how transactions running in parallel can influence each other.