Error during File upload into BI IP

[Former Member]

Hi,

I have followed the steps outlined in the How-to Guide for loading files into BI-IP (NEtweaver) as posted by Marc. When I execute the same, I get the following error:

System error in program CL_RSR_FIPT_VAL2SID_PREFETCH and form BEFORE_TRANSFORM-01- (see long text).

I am not sure why this is happening and also about what should be done! Any ideas are most welcome!

Thanks and Regards

Sriram

[Former Member]

Hi Sampath,

Please ensure you are on SP 15 patch level , else if you are on SP 14 then apply note 1070655 - Termination msg CL_RSPLFR_CONTROLLER =>GET_READ_WRITE_PROVIDS

b] Apply Correction Instruction 566059 [i.e: in Object - CL_RSPLFR_CONTROLLER GET_READ_WRITE_PROVIDS,

delete the block: l_r_alvl = cl_rspls_alvl=>factory( i_aggrlevel = p_infoprov ).

and insert block - l_r_alvl = cl_rspls_alvl=>factory( i_aggrlevel = i_infoprov ).

Apart from this ensure at Planning function level create the rows as like in the flat file. Also give correct parameters to the skip header and other functions.

Hope this helps

Raja

[Former Member]

Hi RajaGopal,

Thanks for the response. We already implemented the specified note and the error continued. We further debugged and came to the discovery that the error was because of one of the records where a characteristic (0SOLD_TO) is supplied a blank value (#). When i remove that record, the file gets uploaded however. Is this error by design or is there any way I can avoid it!

Regards

Sriram

[Former Member]

Hi Sriram,

The Masterdata of the Info Object and the data on the file should be in Sync and hence # would continue to give issues.

Please ensure your file has only the data relevant for respective Master Data set of the particular Info Objects.

Hope this helps

Raja