HCI-DS error: post-processing finished with zero records processed

[Former Member]

Hi Experts,

While uploading a KF from a csv file We are getting the following error

We are unable to figure out the root cause. Can anyone help on this?

Regards,

Subhadip

[Former Member]

Hi All,

Thanks for your inputs. The issue has been resolved.

Regards,

Subhadip

[Alecsandra]

How?

[parveen_kumar6]

Hello Subhadip

It seems that your source doesn't have any records. Can you make sure that there is an extra line at the end of file?

You can also try to run the task by checking the Include Debug Information and you can see in the monitor log how many records are sent to IBP.

Thanks

Parveen Kumar

[Former Member]

Hi Parveen,

Thanks for your reply.

Our source file contains 5 rows as below:

The monitor log is showing that the required numbers of rows are sent to IBP:

Even the design-time data is showing the expected result.

The task is listed in IBP Data Load List and marked as 'success'.

But there are no record processed.

We have kept an extra line as suggested by you but still getting the same error.

Regards,

Subhadip

[Alecsandra]

Hi,

Did you map the FILENAME field from the target query? It has to contain the name of the target table.

Regards

Alecsandra

[Former Member]

Subhadip,

From the IBP logs, Filename showing up blank. If this is blank, no records will be moved from the stage tables to core tables. To avoid this, map the File name attribute in target query to the exact name of the table name or the KeyFigure Name.

Thanks,

Kiran

[Former Member]

Hi Alecsandra,

The Filename field from the target is mapped with the exact name of the target table.

Regards,

Subhadip

[Former Member]

Hi Kiran,

Filename is already mapped with the target table name.

Regards,

Subhadip

[Alecsandra]

Did you define all the mandatory global variables? Like BATCH_COMMAND (insert_update), TIME_PROFILE (-1), PLANNING AREA etc?

[Former Member]

Below are the list of global variables:

Please suggest if any additional variables are required or not.

Regards,

Subhadip

[parveen_kumar6]

Hello Subhadip

Is it possible to attach the csv file? I would suggest you to create an incident to check this issue further.

Thanks

Parveen Kumar

[Former Member]

Hi Parveen,

I am unable to attach the file. Hence attaching the content below.

Regards,

Subhadip