File to JDBC Sync some times its working some times getting error

[Former Member]

Hi All,

I have done the File to JDBC sync scenario. It is working fine i am getting the JDBC response i am storing into XML file.

Now the problem is some times its working fine some times i am getting error in File sender adaptor.

Error: com.sap.aii.af.ra.ms.api.DeliveryException: XIAdapterFramework:GENERAL:com.sap.aii.af.ra.ms.api.MessageExpiredException: Message 91941ba7-f58e-46f2-3865-86fbea9fa197(INBOUND) expired

Error: com.sap.aii.af.service.util.transaction.api.TxManagerException: Unable to roll back transaction: com.sap.engine.services.ts.exceptions.BaseIllegalStateException

when i check the JDBC receiver communication its showing green there is no error. but i did't get the out put this time. when i try again its working fine with output file with 40mb size

Could you pls suggest where i am doing wrong.

Thanks,

Venkat.

[Former Member]

thanks for your help we have chaged the value in visual admin for inbound peramater the current default value is 120min

pls check the note which we have applied Note 791379

[JoelTrinidade]

Hi,

I came across this text paragraph.

"If a error message(MessageExpiredException) is shown for a receiver channel the timeout setting is done in the inbound XI-Adapter of the Adapter Engine and not via the above described setting in the RFC-Adapter. The value of xiadapter.inbound.timeout.default from J2EE Service 'SAP XI Adapter: XI' is used in this case. Note 791379 will explain this in detail."

Regards

joel

[Former Member]

Hi Joel,

Thanks for your reply. I have made the chages in JDBC receiver adaptor as you suggesed in Adavance tab, poolWaitingTime 300000 after that i have tried to execute the scenario, it was succuss 2 times 3rd time again i am getting the same error in sender file adaptor.

Error: com.sap.aii.af.ra.ms.api.DeliveryException: XIAdapterFramework:GENERAL:com.sap.aii.af.ra.ms.api.MessageExpiredException: Message c06fc5ed-5c5b-44e6-370a-83a40e24f0ab(INBOUND) expired

Error: com.sap.aii.af.service.util.transaction.api.TxManagerException: Unable to roll back transaction: com.sap.engine.services.ts.exceptions.BaseIllegalStateException

Retry interval started. Length: 1800.0 seconds

i have set the poll interval 30 min.

Please help to reslove this issue.

Thanks,

Venkat.

[JoelTrinidade]

Hi,

I think there is an issue with your

PoolWaitingTime:

This timeout value will define the maximum waiting time to get the connection from resource pool. If connection is not available within this time, we return the message to Messaging System and the message is in retry mode.

The configuration of this timeout requires the use of an advanced mode configuration parameter.

To configure a timeout for the JDBC receiver channels, please enable the "Advanced Mode" for the respective JDBC communication channel in the Integration Directory and add an entry "poolWaitingTime" and set to a time in Milli Secs (without any quotation marks) to the "Additional Parameters" section. This parameter is case-sensitive.

The default value of this parameter is 5000 Milli Secs.

The default value ensures a channel will wait 5000 Milli Secs before aquiring connection.

Regards

joel

[former_member181985]

It might be due to a timeout as the message size is large.

Are you using request, response beans concept.........