‎2008 Jul 08 1:49 PM
Hello everyone.
I have interface between ECC application and SQL server thru XI JDBC communication channel. The XML message is synchronous.
The interface need to delete all data from one off the tables in sql db and reponse message is number off records that was deleted.
When I run the program for small data (10000records) in SQL , the running complete properly, But when I run for large data (1000000 records) in SQL I get error:
"INTERNAL.CLIENT_RECEIVE_FAILED Error when receiving by HTTP (error code: 402, error text: ICM_HTTP_TIMEOUT (" .
I already tried to increase http time out in XI but it is still not working and I have same error.
Somebody knows what I need to do for avoid this error. I guess that I need increase the http time out. How I do it???
‎2008 Jul 08 1:59 PM
‎2008 Jul 08 1:59 PM
‎2008 Jul 08 3:47 PM
I already was Implemented this note but I still have same error.
Please wrote me If you have some other offer/Idea.
‎2008 Jul 09 6:33 AM
In you example you say 10.000 and 1.000.000 records, maybe it is not "advisable" to give SQl instruction on a such huge batch of records, try to cut the treatment in smaller lots. (Else you should multiply the time by 100 which may overflow some technical limits) Also you may look at proctimeout and keep_alive_timeout.
Regards
‎2008 Jul 10 7:19 AM
Hi,
Thank you for your help. We succeed solve the problem by increase some parameters in http timeout on ECC .
Regards
‎2012 Jun 19 11:46 AM
hi
can you explain more what parameters change you did in http timout on ECC? cox i am facing same problem please help as soon as possible
will be waiting for your reply.
regards
kavita T