You may get - Error : 417 Expectation Failed Error (when you send XML or JSON Data)

Problem:

Sometimes you may get the following error when sending data to your web server via HTTP POST 

417 Expectation Failed

Possible Cause

A possible reason could be your server is expecting data in a certain format may be in certain encoding and you didn't send that way. Also in a rare case, some servers reject expect-continue flag if its ON.

Possible Solution(s)

There are two possible workarounds you can try.

If you have XML Data type in your SQL Query and you sending that output to the Remote server via Web API Destination or  SSIS REST API Task

1. Change your source SQL query so it outputs your XML data as nvarchar datatype rather than XML datatype
   
   select CAST(myXmlColumn as nvarchar(max)) as myXmlColumn from myTable
   
   
2. If you are not using XML data type but still getting 417 Expectation failed error then try to add a Script Task before you call any API (add the first step in your flow).
   
   Drag Microsoft SSIS Script Task and edit it.
   
   Add following one line in the Main method of the script and close it and try to run your package again see it helps.

   System.Net.ServicePointManager.Expect100Continue = false;

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/