cancel
Showing results for 
Search instead for 
Did you mean: 

BW data Upload issue

Former Member
0 Kudos

Hello Gurus,

We have upgraded our APO system to SCM5.0.

When I am trying to upload upload a flatfile into BI7.0 I am getting an error.

Here are the error details:

Error 1 when loading external data

Message no. RSAR234

Diagnosis

Error number 1 occurred when loading external data:

1. Error when reading the file (access rights, file name, ...)

2. File size or number of records does not correspond to the data in the control file

3. Error when generating the IDoc

4. File contains invalid data (errors with an arithmetic operation or data conversion)

Procedure

Check whether you have the required access rights and whether the data in the control file is correct (file names, record length, number of records, ...). Correct the data in the control file if necessary and check the data file for invalid data (values of the wrong type, values in the wrong format for conversion exit,...). Check whether the file has headers that have not been specified.

I checked all the things and everything looks good. I even tried to upload it into PSA but still the problem persists.

Could anyone please help me out with this

Thanks in advance

Sai

Message was edited by:

sai balakavi

Message was edited by:

sai balakavi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sai,

Could you try to do a preview in your infopackage, or are you using a data transfer process?.

I think that your problem could be in the layout, i can check the layout if you want, but i need that you send me the file that you want to load, and the transfer rules, in order to see what is the infoobject that shows the problem.

This is my mail ulises_marin@yahoo.com.mx.

Regards.

Marí

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Sai,

I already sent you a file with some correction, could you try to load this file and tell me if it works please?

Regards.

Marín.

Former Member
0 Kudos

Marin,

I tried with the file that you sent me, however, the problem still persists. I sent you the screenshot of the detailed error mssg. Please look into that and give me some suggestions

Thanks

Sai

Former Member
0 Kudos

Sai, did you check the preview, if preview works, then in the infopackage in the Processing tab select Data targets only.

I need to know if preview works in order to know if the problem is in format or in communications.

I wait for your answer.

Regards.

Marín.

Former Member
0 Kudos

Marin,

The preview is also not working. Its giving the same error. I checked the file upload in another client and it worked well there.

what could be the issue with the present client?

Thanks

Sai

Former Member
0 Kudos

I have a question for you.

When you sent me your error i can see that your source system is PW5CLNT300 so, i think that you have a connection with an R3 system.

Why are you trying to load a file with an R3 datasource?

I think that you are sending me an incorrect error, because your load monitor must show PC FILE source system instead of PW5CLNT300.

Regards.

Marín.

Message was edited by:

Ulises Marí

Former Member
0 Kudos

Marin,

PW5CLNT300 is our BW system and not the R/3 system

Hope I am clear

Thanks

Sai

Former Member
0 Kudos

Ok, but that's my question, you sent me a file that shows an error in a PW5CLNT300 data source.

I think that you are seeing the wrong load monitor.

You need to see the infopackage for your PC FILE source system.

Regards.

Marín.

Former Member
0 Kudos

Marin,

yes you are right. I looked into Infopackage and it looks fine.I still cant figure out the issue

Regards

Sai

Message was edited by:

sai balakavi

Former Member
0 Kudos

Hello Sai -

Look at the following OSS notes

555788, 567109 and 600246

They are linked with your error.

Hope this helps.

Regards,

Suresh Garg

Former Member
0 Kudos

You can do this.

Load the file that i sent you and make a preview, when you receive an error prompt select help "?" and tell me what is the field that is causing this error. You can see the field when you press on help button "?".

Regards.

Marí

Former Member
0 Kudos

Suresh,

Thanks for responding to my post. I have looked into those OSS notes and they found out to be helpful for me,however, they are for earlier releases.

Marin,

Please send me the file and I'll try to preview it as you suggested.

Thanks

Sai

Former Member
0 Kudos

Hello Sai -

What GUI version are you using? normally if the notes are related to previous versions then by upgrading your GUI to the latest available will help youin solving the problem.

Regards,

Suresh Garg

Former Member
0 Kudos

Marin and Suresh, the issue was solved. There was some issue with the infopackage settings which has been taken care of.

I thank both of you for taking your time to help me out.

Thanks

Sai