Error when loading data: The data file is empty. Please check the data file again and try again

[Former Member]

Hi experts,

Please note that currently we're using SAP BPC 7.5 MS version.

The method for importing data is "Merge data values".

When trying to import an .act file into SAP BPC via the Import package following error is showing up.

However, the datafile itself does contain 2 rows of test data

TOTAL STEPS  10
1. Move all files to Queue:                completed  in 0 sec.
2. Merge and move file to Progress:        completed  in 0 sec.
3. File Exists:                            completed  in 0 sec.
4. Convert Data:                          completed  in 0 sec.
5. LOAD AND PROCESS:                      Failed  in 1 sec.
6. Failed by Load:                        completed  in 0 sec.
7. MergeImportWB:                          completed  in 0 sec.

[Selection]
------------------------------------------------------------
myProcess=4_Load_Interco
myROW=4
DESTTBL=6
TRANSFORMATION=\GPS_Maint\INTERCO_MATCH\DataManager\TransformationFiles\\Interco_Textfiles_Bernard.xls
CLEARDATA= Yes
RUNLOGIC= No
CHECKLCK= No

[Messages]
------------------------------------------------------------

Convert Data
Success

Record Count : 2
Accept Count : 0
Reject Count : 0
Skip Count  : 2

The data file is empty. Please check the data file and try again.

Could you please advise on what else can be checked?

Thanks  a lot in advance,

Wai Yee Kong

[Former Member]

Hello Wai,

What is the file extension of the input file?

That error usually occurrs when you don't have the OPTION Delimiter well defined.

.CSV -> DELIMITER = ;

.TXT -> DELIMITER = TAB;

Thank you.

Raquel Oliveira

[former_member186498]

Hi Wai Yee Kong,

sorry what is an .act file? Normally the inupt file is a .csv or .txt

Can you please share input, transformation and conversions files?

Regards

     Roberto

[Former Member]

Hi Roberto,

Thanks for having a look at my question.

We're using .act files to upload data from SAP BW into SAP BPC.

This is the content of  .act file that I'm trying to upload:

ACTUAL

1

1

GCN.CZN,2621.LC_.EUR,100.5000

GCN.CZN,2621.TC_.CZK,7050.0000

Transformation file looks like:

Conversion files are:

Time:

Category:

Entity:

Counterpart:

RCCinterco:

IntercoCurr:

Transcurrency:

In case of any other info needed, please let me know.

Thanks a lot in advance,

Wai Yee Kong

[former_member186498]

Hi Wai Yee Kong,

very difficult to help if there is a big mess.

I'll try to explain, first of all try import in BPC using standard extension (*.txt or *.csv).

In your input and mapping files there isn't a TIME dimension but you have a tranformation for it (how should it works?).

You don't specify a delimiter but it seems you have use a comma as delimiter.

You use skipif=! but I don't see any "!" to skip, etc., see please Data Transformations and the how to guides about script logic.

Another doubt, you have combined codes separate by "." but "point" is also a decimal separator for the amount so maybe it can cause some issues, try first using a "_" instead of "." as separator and only if works try with ".".

Image of the files are ok only the input file (hand made) isn't clear.

Correct the files after reading the help and if you have other issues please repost input and transformation files to see the changes (an image is better).

BTW I see you have also an old post that isn't closed, if solved please close it assingning the correct answer and eventually also the helpful answers, this will help in the future other users with the same issue to find quickly a solution.

Regards

     Roberto

[Former Member]

Hi Roberto,

Thank you for your feedback.

I agree that the current set up is not how is should look like and there are for sure rooms for improvement.

However, this is a set up that has been defined few years ago and all conversion/transformation files are built on this.

Unfortuantely, there is currently no way to change the whole set up on this.

Above mentioned conversion/transformation files are following the same set up as the ones we have currently in the system. The only performed change was in the transformation file fields with regard to IntercoCurr and Transcurrency.

However, I believe your below point is really good. I'll adapt the file and check the outcome.

"Another doubt, you have combined codes separate by "." but "point" is also a decimal separator for the amount so maybe it can cause some issues, try first using a "_" instead of "." as separator and only if works try with "."."

Thanks for the advice.

Wai Yee Kong

[former_member186498]

Hi Wai Yee Kong,

see please also these notes about  the delimiter of the transformation file

1496685 - BPC: Data file is empty error when running the import package

Regards

     Roberto