IIQ8.5: java.lang.RuntimeException: Ensure there is a valid data present in file

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

IIQ8.5

Share all details about your problem, including any error messages you may have received.

Hello,

After upgrading from IIQ8.2 to IIQ8.5, we observed something different regarding the delimited file connector.

Let’s say there is a CSV file which has no records inside, only has the column headers at the first line.

In IIQ8.2, the aggregation is successful even the CSV has no records.

However, after upgrading to IIQ8.5, we encountered the following error when IIQ aggregates from a CSV file with no records.

java.lang.RuntimeException: Ensure there is a valid data present in file

Does anyone know how to fix? Thank you.

2

but then my question is, if there is no record in the csv file, why you want to run the aggregation, if there is no record, Aggregation will not do anything. Correct??

3

Thanks for your reply, let me describe more on that.

There is a situation where the CSV file had records originally, but then those records are not valid anymore so they have all been removed.

Before upgrade (IIQ8.2), the aggregation would still be successful for the above situation, and the corresponding account links will be deleted in the identity cubes.

However, after upgrading to IIQ8.5, since the aggregation is failed with the above error, IIQ would not proceed to delete the corresponding account links. That’s the actual problem that we are facing right now.

4

@adrianlaw In this case, why you need to run the Aggregation Task when there is no data. This is OOTB feature that shows this message.

5

Details please check my reply to @naveenkumar3

6

Understood now, that is a genuine case. In my local I am on 8.4 , and it works. Do you mind sharing the logs?? when you run the aggregation??

7

Attached please find the log, thanks

log_20251029.txt (2.4 KB)

8

Hi @adrianlaw

Is your delimited source defined as an authoritative source as well?

9

@adrianlaw

8.5 connector is updated with a runtime exception if there is no record from the file to process, it throws the exception. You would also get the same error when tried to preview the accounts as well along with the aggregation task.

<
if (this._processed == 0L)
throw new RuntimeException(“Ensure there is valid data present in file”);
}
/>

There seems to be no OOTB attribute support to skip the error at the moment. However, you can always add a preIterate rule to validate if the content of the file is empty and return null, such that task doesn’t showup as a failure with the runtime exception message.

10

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.