Delimiter Test connection

IdentityIQ (IIQ) IIQ Discussion and Questions
1

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

2

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.

2 Likes
3

Hi @AkshayB

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

1 Like
4

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

1 Like
5

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

1 Like
6

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.

7

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.

8

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.

1 Like
9

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

1 Like
10

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

1 Like
11

Hi Muhammad,

Thanks for your input. The problem is file permission to access in the specific folder was removed after we done our patching to our environment. After give R/W/E permission test connection was successful.

Regards,
Akshay

12

Hi @ismaelmoreno1 both the files are in same environment the problem was I don’t have the folder access to read and write permissions. Now, It is good. Thanks.

Regards,
Akshay B

13

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