FLAT File upload fails and succeeds without any changes to the file in SAP BPC 10.0

[Former Member]

Hi Experts,

We have a FLAT File upload. When the user executes the Package, it fails in the first two instances but succeeds third time with out any changes to the File. Please see steps by steps below. Can anyone help what exactly is causing the issue. Please see the error screen below.

1. Package  status

When I analyze the backend, i can see the below error.

2. Error log from Backend. Step failing while loading to PSA

More details of the error below

Please let me know if any one has an idea what exactly is causing the issue.

Thanks in advance,

Best Regards,

Venkata

[Former Member]

Hi Venkata,

From all your screen shots, it seems you were trying to run a process chain to upload data to BPC, but prior to load data to BPC you were trying to load data to PSA from a flat file stored in server (AL11).

As per the rule, when prior to load data from a flat file to either a PSA or BPC Cube, we have to close that flat file (Means it should not be open mode).

I think, at the time of 1st and 2nd instances, your file was open at the time of  to running the Package, but in the 3rd instances, it was closed.So it worked.

Thanks,

Shub

[Former Member]

Hi Venkata,

Do you have multiple App Servers? You can check that from t/a SM51.

If you have, can you check if you see that file from both servers?

Regards,

Gersh

[gajendra_moond]

Hi Venkata

It seems that the file is generated via some program and saved on the application server. It could be possible that file is being generated when you ran the first time and hence process step could not find the file. Check in T-code AL11 that your file has been generated successfully before the process chain is triggered.

Secondly, why are you not using the standard Data Manager Package to load flat file to BPC Model? DTP route is not recommended.