Soap test connection is failing -Error While Test connection: hostname

[jitendra_sharma]

I am trying to integrate SOAP base application and it use basic authentication method. prepared below json but while testing connection it failed with below error.  we have checked connectivity between sc2 client to target machine. it is reachable from SC2 client server.

Error While Test connection: hpg0000001056.corp.xxxxxxxxxxx.com

 JSON CONNECTION -

{

    "authentications": {

        "login": {

            "properties": {

                "SOAP_ENDPOINT" : "https://hpg0000001056.corp.xxxxxxx.com:8209/p6ws/services/UserService",

                "USERNAME" : "xxxxxxxxxxxxxxxxxxxxx",

                "PASSWORD" : "xxxxxxxxxxxxxxxxxxxxx",

                "REQUESTPARAMS" : {

                    "Content-Type" : "text/xml"

                }

            }

        }

    }

}

error log :

2023-09-04/12:16:09.780 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - debugEnabled = true

2023-09-04/12:16:09.780 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - Getting JSON for CONNECTIONJSON

2023-09-04/12:16:09.780 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - CONNECTIONJSON = ********

2023-09-04/12:16:09.780 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - End getting JSON for CONNECTIONJSON

2023-09-04/12:16:09.780 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - Calling URL: https://hpg0000001056.corp.xxxxxx.com:8209/p6ws/services/UserService

2023-09-04/12:16:09.780 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - setting connection timeout to 20 seconds and request timeout to 60 seconds

2023-09-04/12:16:09.780 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - Connecting to webservice: https://hpg0000001056.corp.xxxxxxxx.com:8209/p6ws/services/UserService

2023-09-04/12:16:09.977 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - Trying again by adding '?WSDL' to the URL

2023-09-04/12:16:09.977 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - Calling URL: https://hpg0000001056.corp.hitachi-powergrids.com:8209/p6ws/services/UserService?WSDL

2023-09-04/12:16:09.977 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - setting connection timeout to 20 seconds and request timeout to 60 seconds

2023-09-04/12:16:09.977 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - Connecting to webservice: https://hpg0000001056.corp.xxxxxxxx.com:8209/p6ws/services/UserService?WSDL

2023-09-04/12:16:09.977 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - Trying again by adding '?SOAP' to the URL

2023-09-04/12:16:09.977 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - Calling URL: https://hpg0000001056.corp.xxxxxxxxxxx.com:8209/p6ws/services/UserService?SOAP

2023-09-04/12:16:09.977 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - setting connection timeout to 20 seconds and request timeout to 60 seconds

2023-09-04/12:16:09.977 [{}] [https-jsse-nio-443-exec-160]  DEBUG provisoning.SoapProvisioningService - Connecting to webservice: https://hpg0000001056.corp.xxxxxxxxxx.com:8209/p6ws/services/UserService?SOAP

2023-09-04/12:16:09.978 [{}] [https-jsse-nio-443-exec-160]  ERROR provisoning.SoapProvisioningService - Error in test connection for SOAP:

java.lang.Exception: hpg0000001056.corp.xxxxxxxxx.com

      at com.saviynt.provisoning.SoapProvisioningService.testAndConnectSOAP(SoapProvisioningService.groovy:3773)

      at com.saviynt.provisoning.SoapProvisioningService$_testConnectionSOAP_closure56.doCall(SoapProvisioningService.groovy:3699)

      at com.saviynt.provisoning.SoapProvisioningService.testConnectionSOAP(SoapProvisioningService.groovy:3692)

      at com.saviynt.ecm.integration.ExternalConnectionCallService.testExternalConnection(ExternalConnectionCallService.groovy:458)

      at com.saviynt.ecm.utility.domain.EcmConfigController$_closure21.doCall(EcmConfigController.groovy:751)

      at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53)

      at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:171)

      at grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter.doFilter(MutableLogoutFilter.java:62)

      at grails.plugin.springsecu

I tried from soap ui tool it works fine. 

URL : https://hpg0000001056.corp.xxxxxxxxxx.com:8209/p6ws/services/UserService 

Payload :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v1="http://xmlns.oracle.com/Primavera/P6/WS/User/V1">
<soapenv:Header>
<wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
<wsse:UsernameToken wsu:Id="UsernameToken-938C8F13BDA479751516934751375442">
<wsse:Username>xxxxxxxxxxxxxxxxxxxx</wsse:Username>
<wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText"xxxx...
<wsse:Nonce EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary">JTbi...
<wsu:Created>2023-08-31T09:45:37.543Z</wsu:Created>
</wsse:UsernameToken>
</wsse:Security>
</soapenv:Header>
<soapenv:Body>
<v1:ReadUsers>
<!--1 or more repetitions:-->
<v1:Field>ObjectId</v1:Field>
<v1:Field>Name</v1:Field>
<v1:Field>PersonalName</v1:Field>
<v1:Field>OfficePhone</v1:Field>
<!--Optional:-->
<v1:Filter/>
<!--Optional:-->
<v1:OrderBy/>
</v1:ReadUsers>
</soapenv:Body>
</soapenv:Envelope>

Response : 

Response =

HTTP/1.1 200 OK
Date: Mon, 04 Sep 2023 12:14:58 GMT
Content-Type: text/xml; charset=utf-8
Accept: text/xml, text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
X-Frame-Options: SAMEORIGIN

<?xml version='1.0' encoding='UTF-8'?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header><work:WorkContext xmlns:work="http://oracle.com/weblogic/soap/workarea/">rO0ABXdMABF3ZWJsb2dpYy5hcHAucDZ3cwAAANYAAAAjd2VibG9naWMud... xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.oracle.com/Primavera/P6/WS/User/V1"><User><Name>admin</Name><ObjectId>25</ObjectId><Off... Admin</PersonalName></User><User><Name>XE-XEABB-P6PRODAPP_S</Name><ObjectId>54</ObjectId><OfficePhone/><PersonalName>Services account</PersonalName></User><User><Name>GLB-IDM-PrimaveraP6</Name><ObjectId>75</ObjectId><OfficePhone/><PersonalName>LDAP admin account</PersonalName></User><User><Name>joerg.ritter@hitachienergy.com</Name><ObjectId>116</ObjectId><OfficePhone/><PersonalName>Joerg Ritter</PersonalName></User><User><Name>nikolay.spasibenko@hitachienergy.com</Name><ObjectId>118</ObjectId><OfficePhone>+46313392125</OfficePhone><PersonalName>Nikolay Spasibenko</PersonalName></User><User><Name>eric.yuhara@hitachienergy.com</Name><ObjectId>120</ObjectId><OfficePhone>+55

Can you please suggest the connection json for basic soap authentication. above sample got from doc but it did not work.

[jitendra_sharma]

There is no info about connection json in soap document. anyone has sample json. what soap endpoint at connection level. same info passing in soap json.  

[SB]

Let me check on this and will update.

[jitendra_sharma]

Even i have tried below  json 

{
"authentications": {
"login": {
"properties": {

"SOAP_ENDPOINT": "https://xxxxxxxxxxxxx:8209/p6ws/services/UserService",
"TEST_URL" : "https://xxxxxxxxxxxxxxxxx:8209/p6ws/services/AuthenticationService",
"USERNAME" : "xxxxxxxxxxxx",
"PASSWORD" : "xxxxxxxxxx",
"REQUESTPARAMS" : {
"Content-Type" : "text/xml"
}
}
}
}
}

I tried with changing value of SOAP_ENDPOINT and TEST_URL. but still it did not work.

2023-09-11/09:37:03.021 [{}] [quartzScheduler_Worker-18] DEBUG services.HttpClientUtilityService - getHttpClient - HttpClientBuilder.create().build() called.
2023-09-11/09:37:03.049 [{}] [https-jsse-nio-443-exec-46] DEBUG provisoning.SoapProvisioningService - Trying again by adding '?WSDL' to the URL
2023-09-11/09:37:03.049 [{}] [https-jsse-nio-443-exec-46] DEBUG provisoning.SoapProvisioningService - Calling URL: https://hpg0000004019.corp.hitachi-powergrids.com:8209/p6ws/services/UserService?WSDL
2023-09-11/09:37:03.049 [{}] [https-jsse-nio-443-exec-46] DEBUG provisoning.SoapProvisioningService - setting connection timeout to 20 seconds and request timeout to 60 seconds
2023-09-11/09:37:03.049 [{}] [https-jsse-nio-443-exec-46] DEBUG provisoning.SoapProvisioningService - Connecting to webservice: https://hpg0000004019.corp.hitachi-powergrids.com:8209/p6ws/services/UserService?WSDL
2023-09-11/09:37:03.050 [{}] [https-jsse-nio-443-exec-46] DEBUG provisoning.SoapProvisioningService - Trying again by adding '?SOAP' to the URL
2023-09-11/09:37:03.050 [{}] [https-jsse-nio-443-exec-46] DEBUG provisoning.SoapProvisioningService - Calling URL: https://hpg0000004019.corp.hitachi-powergrids.com:8209/p6ws/services/UserService?SOAP
2023-09-11/09:37:03.050 [{}] [https-jsse-nio-443-exec-46] DEBUG provisoning.SoapProvisioningService - setting connection timeout to 20 seconds and request timeout to 60 seconds
2023-09-11/09:37:03.050 [{}] [https-jsse-nio-443-exec-46] DEBUG provisoning.SoapProvisioningService - Connecting to webservice: https://hpg0000004019.corp.hitachi-powergrids.com:8209/p6ws/services/UserService?SOAP
2023-09-11/09:37:03.051 [{}] [https-jsse-nio-443-exec-46] ERROR provisoning.SoapProvisioningService - Error in test connection for SOAP:
java.lang.Exception: hpg0000004019.corp.hitachi-powergrids.com
at com.saviynt.provisoning.SoapProvisioningService.testAndConnectSOAP(SoapProvisioningService.groovy:3773)
at com.saviynt.provisoning.SoapProvisioningService$_testConnectionSOAP_closure56.doCall(SoapProvisioningService.groovy:3699)

[SB]

It appears the Saviynt server is unable to reach the target. Can you create a ticket with Support to check if the connectivity is working from the back end (Ping/telnet the target)