Delimiter Test connection

Which IIQ version are you inquiring about?

Version 8.2

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

Hi,
Does anyone facing intermittent test connection issue on delimited connector.(v 8.2). If anyone faced this issue and get is resolved need your inputs. Error was : Unable to open the fileStream : filepath
Thanks in advance.

Akshay

Akshay , that could mean only one thing: The file is not in the location you put it on the connector config, the File Enconding is wrong.

1 Like

Hi @AkshayB

Please check that your file is located in the correct path and check that permissions are properly set

Also, please check the following solution, if problem is related with path

It could also happen if no records are not returned on test connection due to any changes in the rule, or file data. So maybe validate if you can preview and schema and all other attributes of the connector is defined

Hi Ismael,
Yes, I’m sure about that file location and permissions was provided. The weird part is
ex: E:\feeds\testdata.csv this one is working
E:\feeds\proddata.csv this is not working.
I compared the file permission b/w this two files both are similar only but somehow don’t know what’s happening.

Hi @AkshayB

Are both files of different environments or in the same?
If environment is diferentes please, move your proddata.csv file to your lower env, and try preview option.

Is encoding of both files the same?

Do you have multi-node cluster? Is the file present on all servers?

If you go to Debug → About you will see which host you are connected and you can verify if file is in that host.

Can you use “/” or “//” instead of \ this?

Hi @AkshayB,
Try to troubleshoot via Rule as mentioned in this topic by Chris (SailPoint Employee) and see what is going on maybe it will be useful…

https://community.sailpoint.com/t5/IdentityIQ-Forum/DelimitedFile-Connector-quot-Unable-to-open-filestream-for/m-p/97576