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)