I am facing an error while loading flat file from application server into BW.
Error text is : 'The argument 'erintegrat' cannot be interpreted as' at conversion exit RSDS_CONVERT_NUMBER.
Read preview data from Datasource works sucessfully for first 8744 records but when we increase the no. of records it gives the above error message.
The error meassage shows error at Record no. 8745 but 8745 data record does not have any data issue.
However when i tried to load the same file from local workstation it could load data without any errors. Complete file is loaded. No. Of records are more than 15,000. I am unable to find as to why is this happening?
Is there any limitation to file size in application layer because of which we are getting the same error always at Record no. 8745.
Helpful answers would be awarded points.