I had created a delimited application where source file is from a server which is Windows server exposing an SMB file share.
SO i tried establishing connection by giving path as below
\servername\export\Computers with Names.csv with transport mode as local getting below error | Unable to open filestream for file: \\servername\export\Computers with Names.csv |
|----|
But through dir \servername\export i am able to see the file . what might be issue .
Is the SailPoint IIQ application installed and running on the same local server where you are able to access the file using the directory path. Also can you check on your application server if the app server is running with setup Log On As Local System or as another account. If its using any other account then you need to check if that account is allowed to access that file.
@lsaipriya26 Could you please login to IIQ server and try telnet to the Windows Server exposing SMB file share? It’ll help us ruling out any firewall/network related restrictions.
@lsaipriya26 The telnet failure on port 23 is expected — port 23 is the default Telnet service port, not the SMB port. To properly test SMB connectivity from the IIQ server to the file server, you should test against port assigned to SMB, possibly 445 (or 139 for legacy SMB). If that also fails, it confirms a firewall or network-level block between the IIQ server and the SMB file share, which would explain the “Unable to open filestream” error.
Hello Saipriya. The port 23 test does not test SMB. From the IIQ application server, test TCP 445:
Test-NetConnection servername -Port 445
If 445 fails, check the network and firewall path first. If it succeeds, check the account running the IIQ application-server service. With Local transport, SailPoint requires that account to have read access to the file.
Grant it both Share and NTFS read access to:
\\servername\export\Computers with Names.csv
Also confirm the configured UNC path starts with \\.
If the service runs as LocalSystem on a domain-joined server, the share sees the IIQ server computer account (DOMAIN\IIQSERVER$).
SailPoint documents Local transport for files residing on the IIQ application server. If the UNC path still fails, place the file locally on the IIQ server or use a supported remote transport such as SFTP.
Given path is as below :\lansweeper\export\Computers with Names.csv.
Tomcat running as Local service
After adding permissions i had even restart the tomcat but still getting Same error .
Do i missing something here?
Hello Saipriya. If by “Local service” you mean Tomcat is running as NT AUTHORITY\LocalService, that is likely the issue. LocalService presents anonymous credentials when accessing a remote share, so the permission granted to SP-TEST-WEB1$ would not be used.
Please check the Tomcat service Log On As account. If it is LocalService, run Tomcat with a domain service account, grant that same account Read on both the Share and NTFS permissions, then restart Tomcat.
Also confirm the path starts with two backslashes:
\\lansweeper\export\Computers with Names.csv
SailPoint documents Local transport for files residing locally on the IIQ application server and requires the application-server service account to have read access: Configuration Parameters.
If it still fails, copy the CSV to the IIQ server and test with a local path. If that works, the remaining issue is with access to the remote SMB share.
