API Gateway : "wsdl. Message: Connection timed out (Connection timed out)" - causing the gateway Service to not start
search cancel

API Gateway : "wsdl. Message: Connection timed out (Connection timed out)" - causing the gateway Service to not start

book

Article ID: 189171

calendar_today

Updated On:

Products

CA API Gateway API SECURITY CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7) CA API Gateway Enterprise Service Manager (Layer 7) STARTER PACK-7 CA Microgateway

Issue/Introduction

After restoring the gateway from a snapshot the ssg service would not start.  Below are the last errors in the ssg_0_0.log:

2020-04-20T20:04:51.051+0200 INFO 1 com.l7tech.server.service.ServiceWsdlImportChecker: Checking WSDL imports for SOAP services.
2020-04-20T20:05:56.004+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP1//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:06:59.018+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP2/ServiceBeantwoordVraag.svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:08:02.042+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP3//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:09:05.058+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP4//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:10:08.084+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP5//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:11:11.096+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP6//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:12:14.130+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP7//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:13:17.156+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP8//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:15:23.211+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP9//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:16:26.231+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP10//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:17:29.243+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP11//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:18:32.276+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP12//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:19:35.298+0200 WARNING 1 com.l7tech.wsdl.ResourceTrackingWSDLLocator: Error getting import input source 'https://<WSDL_FQDN>/folder/APP13//Service..svc?wsdl'. Message: Connection timed out (Connection timed out)
2020-04-20T20:19:37.632+0200 INFO 1 com.l7tech.server.transport.SsgConnectorManagerImpl: Default HTTP port: 8080
2020-04-20T20:19:37.637+0200 INFO 1 com.l7tech.server.transport.SsgConnectorManagerImpl: Default HTTPS port: 8443
2020-04-20T20:19:38.521+0200 INFO 1 com.l7tech.server.log.SinkManager: Redirecting logging to configured log sinks.
2020-04-20T20:19:38.553+0200 INFO 1 com.l7tech.server.log.SinkManager: Redirected logging to configured log sinks.

 

Environment

Release : 9.4

Component : API GATEWAY

Cause

It looks like the gateway was trying to load a WSDL in cache from a host that was not reachable. 

Resolution

We were able to fix this by disabling the services that had an issue directly within the database.

1.  We have listed all of the services with the issue by executing the following: 

mysql ssg -e "select * from  published_service  where wsdl_xml like'%Service..svc?wsdl%';"


2. To disable services with the issue:

mysql ssg -e "update published_service set disabled='1' where wsdl_xml like'%Service..svc?wsdl%';"


3. and restarted the ssg service

SSG Service is now running and we are able to login to the gateway. 

4. to enable those services back,  make sure that gateway can reach out to the host. 

Then run this:

mysql ssg -e "update published_service set disabled='0' where wsdl_xml like'%Service..svc?wsdll%';"


service ssg restart