Problems and Solutions encountered when the sap RFC function is called in SSIs

1. If there are too many parameters in RFC and only a few parameters must be input, it is difficult to call them successfully.

For example, an RFC with 20 parameters is used, but the call fails in several cases.

= "Solution: extract the parameters that need to be used, add a new RFC function separately, and use the new function to call the old RFC. In this way, the default value of null parameters is processed in the RFC, in this way, functions can be called.

 

2. An error similar to "the value was too large to fit in the output column..." occurs during SSIS verification.

= "Solution: Find the corresponding error field in the proposed Information and check this field. You can use an independent SSIS process to separately verify this field, for example, if the original is select * from table, the new SSIS uses select fielda from table for independent testing.

Check whether this field is correct during the test. Then, view the data element of this field in the corresponding sap table, and compare it with similar fields that are no problem. Finally, after changing the definition method and length of the field is found in the Data Element Definition, this problem can be solved. Previously, the predefine method was used. The new method was changed to the domain method to solve this problem.