cancel
Showing results for 
Search instead for 
Did you mean: 

SQL to XI Scenario (message delivery problem)

former_member185881
Active Participant
0 Kudos

Hi All

Scenario is:

  • Sender Communication Channel is polling data from SQL.

  • From SQL around 2,75,000 records need to be picked up.

  • Communication Channel has successfully picked up data.

  • When i see communication channel monitoring getting an error

"Transmitting the message to endpoint http://hkbxiprd:8000/sap/xi/engine?type=entry using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: java.io.IOException: Error writing to server."

  • What is this error and how to sove it.

  • As XI sender channel already picked up data so flag in SQL side is also updated so cant try to pick up data again from SQL. All the records got stuck in adapter engine.

  • I also tried to resend the message but still getting the same Error Message.

Please suggest what can be done.

Regards

Dheeraj Kumar

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member185881
Active Participant
0 Kudos

Hi All

Now i have set icm/HTTP/max_request_size_KB = 2097152

Sender communication channel successfully picked up records and sent to Integration Engine.

Now the problem is now it got stucked into smq2.

When i am checking my moni it is showing message in automatic restart.

inside error it is showing

<SAP:Code area="INTERNAL">CLIENT_SEND_FAILED</SAP:Code> 
  <SAP:P1>110</SAP:P1> 
  <SAP:P2>HTTPIO_PLG_CANCELED-Fehlermeldung beim Senden der Daten.</SAP:P2>

What i can do next please suggest

Regards

Dheeraj Kumar

former_member200962
Active Contributor
0 Kudos

Check this similar discussion...may be becuase of the size the message is getting stuck:

Regards,

Abhishek

former_member185881
Active Participant
0 Kudos

Hi Abhishek

I have increased the Heap size and buffer size too but still getting same problem.

is there any other thing i can do?

Regards

Dheeraj kumar

former_member187339
Active Contributor
0 Kudos

Hi Dheeraj,

After doing these changes have you restarted the server? Also what is the new value that you have given for Heap size?

Regards

Suraj

former_member185881
Active Participant
0 Kudos

Hi Suraj

Yes i have restarted the server.

14000 heap size

512 mb Buffer Size

Regards

Dheeraj Kumar

Former Member
0 Kudos

Hi,

Can you check the following things in system

1. what is the QOS ? EOIO cant eb reprocessed... since it is sender it shud be BE

2. Error in default trace logs. Gives the prompt reason for the failure

3. Memory and CPU consumption details from BASIS guys. Gives an idea how system is loaded while executing that mes

sage

4. Have you done Java restart

Thanks,

Jogula Ramesh