search cancel

API Gateway : "wsdl. Message: Connection timed out (Connection timed out)" - causing gateway Service won't 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 gateway from snapshot , ssg service would not start .. bellow is the last error in logs 

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://URL.local.com/folder/.DDS.PROD//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://URL.local.com/folder/.DDS.PROD/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://URL.local.com/folder/.BPA.PROD//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://URL.local.com/folder/.JGZ.PROD//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://URL.local.com/folder/.GWS.PROD//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://URL.local.com/folder/.LLA.PROD//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://URL.local.com/folder/.BPA.PROD//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://URL.local.com/folder/.DDS.PROD//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://URL.local.com/folder/.JGZ.PROD//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://URL.local.com/folder/.GWS.PROD//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://URL.local.com/folder/.LLA.PROD//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://URL.local.com/folder/.PAR.PROD//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://URL.local.com/folder/.PIM.PROD//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.

Cause

it looks like gateway was trying to load WSDL in cache from host that was not reachable 

Environment

Release : 9.4

Component : API GATEWAY

Resolution

We were able to fix this by disabling the services that had issue in DB  directly.

1.  we have listed all of the services with the issue 

 

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 are able to log in to the gateway. 

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

Than Run this:

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


service ssg restart