Skip to Content

Error while fetching data from ECC,RUN-50406 |StoredProcedureExecutor|

Mar 05 at 10:41 AM


avatar image
Former Member

Hi Experts,

I have created task to upload [Currency ]data from ECC to IBP, have used the filter to restrict the values - TCURT.SPRAS = 'E' AND TCURT.WAERS IN ('CURRENCY1','CURRENCY2','CURRENCY3','CURRENCY4','CURRENCY5')

I receive the following error and the task is finished with errors.

RUN-50406 |StoredProcedureExecutor|TASK| Could not complete stored procedure "SAPHANADB."/IBP/CL_SAP_SFND_SOPINTEG=>SOPINTEG_DATA_UPLOAD_V1"" of application "SNOP" due to "Failed to run stored procedure for SAP DBTech JDBC: [257 ] : sql syntax error: "SAPHANADB"."/1BCAMDP/SOPINTEG_DATA_UPLOAD_V1": line 20 col 11 (at pos 784): "SAPHANADB"."/IBP/CL_SAP_SFND_SOPINTEG=>SOPINTEG_DATA_UPLOAD_INT": line 200 col 13 (at pos 9595): sql syntax error: incorrect syntax near "EMPTY_STRING_IS_NOT_ALLOWED_FOR_COMMAND_OUTSIDE___ERROR__": line 1 col 1 (at pos 1)".

Can someone assist me to correct the error.

Thanks in Advance.


SendhilAzhagan K

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Mar 05 at 05:42 PM

Hello Sendhil,

Please check, if you are passing any column with a blank or NULL value. Hence, the target column is not accepting. Please check, if you have mapped all the mandatory columns.

with regards,


10 |10000 characters needed characters left characters exceeded