WINCONNECTOR connection failur

[PeterRaja]

Hi Team,

We are using an OOTB WINCONNECTOR connection type to connect to a Windows IIS server from Saviynt. We have followed the prerequisite steps to deploy the Saviynt App on the IIS Server using the following documentation site: 

Understanding the Integration between EIC and Windows Server (saviyntcloud.com)

We stuck with the connection failed error. Please let me know if any validation i need to do in windows server where i have IIS and Saviynt Agent installed. 

Logs:

"2024-03-13T13:18:57.274+00:00","ecm","integration.ExternalConnectionCallService","http-nio-8080-exec-7-4x7qt","DEBUG","in testExternalConnection for External Connection : WINPS_Connector"
"2024-03-13T13:18:57.275+00:00","ecm","services.WindowsConnectorService","http-nio-8080-exec-7-4x7qt","DEBUG","Enter testConnection"
"2024-03-13T13:18:57.277+00:00","ecm","services.WindowsConnectorService","http-nio-8080-exec-7-4x7qt","ERROR","Exception "
"2024-03-13T13:18:57.391+00:00","ecm","","null-4x7qt","","org.codehaus.groovy.grails.web.converters.exceptions.ConverterException: Error parsing JSON at grails.converters.JSON.parse(JSON.java:292) at com.saviynt.ecm.services.WindowsConnectorService.testConnection(WindowsConnectorService.groovy:1460) at com.saviynt.ecm.integration.ExternalConnectionCallService.testExternalConnection(ExternalConnectionCallService.groovy:947) at com.saviynt.ecm.utility.domain.EcmConfigController$_closure21.doCall(EcmConfigController.groovy:769) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:155) at grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter.doFilter(MutableLogoutFilter.java:62) at grails.plugin.springsecurity.web.SecurityRequestHolderFilter.doFilter(SecurityRequestHolderFilter.java:59) at com.mrhaki.grails.plugin.xframeoptions.web.XFrameOptionsFilter.doFilterInternal(XFrameOptionsFilter.java:69) at com.brandseye.cors.CorsFilter.doFilter(CorsFilter.java:82) at java.lang.Thread.run(Thread.java:750)Caused by: org.codehaus.groovy.grails.web.json.JSONException: Missing value. at character 0 of at grails.converters.JSON.parse(JSON.java:283) ... 10 more"
"2024-03-13T13:18:57.277+00:00","ecm","services.WindowsConnectorService","http-nio-8080-exec-7-4x7qt","DEBUG","Status to return is false"
"2024-03-13T13:18:57.277+00:00","ecm","services.WindowsConnectorService","http-nio-8080-exec-7-4x7qt","DEBUG","Exit testConnection"
"2024-03-13T13:18:57.279+00:00","ecm","integration.ExternalConnectionCallService","http-nio-8080-exec-7-4x7qt","DEBUG","EXIT invokeExternalMethod"
"2024-03-13T13:18:40.697+00:00","ecm","domain.EcmConfigController","http-nio-8080-exec-3-4x7qt","DEBUG","vaultConfig not found for the connectionId 44"
"2024-03-13T13:18:39.527+00:00","ecm","rest.JwtService","http-nio-8080-exec-4-4x7qt","DEBUG","Parsed an HMAC signed JWT"
"2024-03-13T13:18:39.527+00:00","ecm","rest.JwtService","http-nio-8080-exec-4-4x7qt","DEBUG","Parsed an HMAC signed JWT"
"2024-03-13T13:18:39.548+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-4-4x7qt","DEBUG","Disable Audit Logging : true"
"2024-03-13T13:18:39.549+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-4-4x7qt","DEBUG","Default max limit is set to 50"
"2024-03-13T13:18:39.549+00:00","ecm","ws.Restfulv5Controller","http-nio-8080-exec-4-4x7qt","DEBUG","inside getEcmVersion"
"2024-03-13T13:18:39.549+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-4-4x7qt","DEBUG","contentType - text/json"
"2024-03-13T13:18:39.550+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-4-4x7qt","DEBUG","contentTypeFromConfig - application/json"
"2024-03-13T13:18:37.328+00:00","gateway","o.s.b.a.w.r.e.AbstractErrorWebExceptionHandler","reactor-http-epoll-4-xfwsz","ERROR","[7123c52b-880936] 500 Server Error for HTTP POST "/ECMv6/api/connectorms/test"|java.net.UnknownHostException: Failed

Regards,

Peter

[stalluri]

@PeterRaja 
org.codehaus.groovy.grails.web.converters.exceptions.ConverterException: Error parsing JSON at grails.converters.JSON.parse(JSON.java:292) 

Can you share the connection JSON and all the JSON you are using in the connection.

[PeterRaja]

Hi Sam,

Connection json:

http://Servername/SaviyntApp/PS/ExecutePSScript

I have tried along with servername : port 80 and 443 but no luck. And used same username password provided by customer.

And using the testconnection json as followed,

{
"TESTCOMMAND": "SCRIPT=Test-NetConnection 'servername'",
"RESPONSE": {
"OBJECTTOREAD": "get(0).PingSucceeded",
"SUCCESSVALUE": "TRUE"
}
}

Regards,

Peter

[stalluri]

@PeterRaja Can you send me the connection Josn.

Did you try connecting using the postman?
What is the response you are getting.

What is the response you are getting when you click on the binding sites on the IIS server.

[PeterRaja]

Hi Sam
It is not working from postman. It's giving timeout error when using basic auth with the above mentioned URL and credentials.

From windows server ISS if i run the 443 port, it is not working but for 80 port it is opening below page from browser.

FYR from where i tried bindings,

Regards,

Peter

[rushikeshvartak]

You need to make postman connection successful first

[stalluri]

@PeterRaja 
Make sure you can connect via Postman.

[PeterRaja]

Thanks Sam for the response.

I am not able to connect from my local postman to run the comment. Are you asking me to have the postman installed in the windows box and try running the comment or what ?

Also i am getting this error now from winconnector. Please help if any idea.

Error:::

"2024-03-19T08:52:46.024+00:00","ecm-worker","services.WindowsConnectorService","quartzScheduler_Worker-6-n76qs","DEBUG","Enter callRestWebService"
"2024-03-19T08:52:46.024+00:00","ecm-worker","services.WindowsConnectorService","quartzScheduler_Worker-6-n76qs","DEBUG","Calling webservice: http://IP:80/SaviyntApp/PS/ExecutePSScript"
"2024-03-19T08:52:45.995+00:00","gateway","o.s.b.a.w.r.e.AbstractErrorWebExceptionHandler","reactor-http-epoll-4-xfwsz","ERROR","[4eb27854-925784] 500 Server Error for HTTP POST "/ECMv6/api/connectorms/test"|java.net.UnknownHostException: Failed to resolve 'connectorms' [A(1)] after 2 queries | at

[naveenss]

Hi @PeterRaja ,

Can you please check if the Application pool for Saviynt under the IIS server is up and running?

[PeterRaja]

Hi Naveen,

Yes, It is running. 

Regards,

Peter

[naveenss]

@PeterRaja  Cool. Can you please try installing the Postman on the windows box and try the connectivity first as suggest in the above comments?

[PeterRaja]

Hi Naveen and Sam,

Yes, i am getting same response as above from postman in windows box. What will be the next step or issue with connecting from Saviynt winconnector?

Regards,

Peter

[PeterRaja]

Hi Sam,

Yes, i am getting same response as above from postman in windows box. What will be the next step or issue with connecting from Saviynt winconnector?

Regards,

Peter

[stalluri]

@PeterRaja 

Make sure you have given the service account username and password on the AppPool.

URL: use only HTTP and don't include the port.
  example: http://XXXXXXXXXX/saviynt(add the folder name)/PS/ExecutePSScript


TestconnectionJson:
{ "TESTCOMMAND": "SCRIPT=Test-NetConnection XXXXXXXXXXX", "RESPONSE": { "OBJECTTOREAD": "get(0).PingSucceeded", "SUCCESSVALUE": "TRUE" } }

share here the full log.