on 03-19-2009 9:52 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It might be due to a timeout as the message size is large.
Are you using request, response beans concept.........
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.