Login issue in API Gateway

Dear all,

I am a newbie on APIGateway and I’d like to get your help on the issue that I’m dealing with.When I try to login my local APIGateway with Administrator/manage; I get the “Data store is down” message.To sort out this;I manually created “GatewayInternalTechnicalUser” user however I still face with the same error.Below you may find the log details.I’d be grateful if you could give me a help for this.

APIGateway.log:

2019-11-10 16:30:08 INFO [apigatewayui] [com.softwareag.apigateway.ui.service.RequestHandler] - Login request for User: Administrator invoked.
2019-11-10 16:30:08 INFO [apigatewayui] [com.softwareag.apigateway.ui.service.ServerConnection] - Get ACL calls returns unexpected status code : 500
2019-11-10 16:30:08 ERROR [apigatewayui] [com.softwareag.apigateway.ui.service.RequestHandler] - Data store is down - com.softwareag.apigateway.ui.exception.DataStoreConnectionException: Data store is down

server.log:
2019-11-10 16:29:41 EET [YAI.0300.8889E] [default][SAG-1LTD1Z2] Exception while searching index. Search request cannot be completed due IOException java.net.ConnectException: Timeout connecting to [/192.168.0.35:9240]
at org.elasticsearch.client.RestClient.extractAndWrapCause(RestClient.java:804) ~[?]
at org.elasticsearch.client.RestClient.performRequest(RestClient.java:225) ~[?]
at org.elasticsearch.client.RestClient.performRequest(RestClient.java:212) ~[?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.performRequest(ElasticsearchClientImpl.java:170) ~[?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.searchDoc(ElasticsearchClientImpl.java:1613) ~[?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.searchDocuments(ElasticsearchClientImpl.java:1122) [?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.searchDocuments(ElasticsearchClientImpl.java:1175) [?]
at com.softwareag.apigateway.core.datastore.ElasticSearchQueryExecutor.fetchDocuments(ElasticSearchQueryExecutor.java:147) [?]
at com.softwareag.apigateway.core.datastore.ElasticSearchQueryExecutor.getResponse(ElasticSearchQueryExecutor.java:57) [?]
at com.softwareag.apigateway.core.datastore.ElasticSearchQueryExecutor.execute(ElasticSearchQueryExecutor.java:29) [?]
at com.softwareag.apigateway.core.datastore.GatewayElasticsearchRepository.findRecords(GatewayElasticsearchRepository.java:235) [?]
at com.softwareag.apigateway.core.datastore.GatewayElasticsearchRepository.findAll(GatewayElasticsearchRepository.java:223) [?]
at com.softwareag.apigateway.core.persistence.handlers.PackagePersistanceHandler.getAll(PackagePersistanceHandler.java:30) [?]
at com.softwareag.apigateway.core.manager.PackageManager.getAll(PackageManager.java:155) [?]
at com.softwareag.pg.pgmen.processors.QuotaSurvivalProcessor.exec(QuotaSurvivalProcessor.java:41) [?]
at com.softwareag.pg.pgmen.processors.DCProcessor.run(DCProcessor.java:3 [?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_222]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:30 [?:1.8.0_222]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_222]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_222]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_222]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_222]
at java.lang.Thread.run(Thread.java:74 [?:1.8.0_222]
Caused by: java.net.ConnectException: Timeout connecting to [/192.168.0.35:9240]
at org.apache.http.nio.pool.RouteSpecificPool.timeout(RouteSpecificPool.java:169) ~[?]
at org.apache.http.nio.pool.AbstractNIOConnPool.requestTimeout(AbstractNIOConnPool.java:62 ~[?]
at org.apache.http.nio.pool.AbstractNIOConnPool$InternalSessionRequestCallback.timeout(AbstractNIOConnPool.java:894) ~[?]
at org.apache.http.impl.nio.reactor.SessionRequestImpl.timeout(SessionRequestImpl.java:183) ~[?]
at org.apache.http.impl.nio.reactor.DefaultConnectingIOReactor.processTimeouts(DefaultConnectingIOReactor.java:210) ~[?]
at org.apache.http.impl.nio.reactor.DefaultConnectingIOReactor.processEvents(DefaultConnectingIOReactor.java:155) ~[?]
at org.apache.http.impl.nio.reactor.AbstractMultiworkerIOReactor.execute(AbstractMultiworkerIOReactor.java:351) ~[?]
at org.apache.http.impl.nio.conn.PoolingNHttpClientConnectionManager.execute(PoolingNHttpClientConnectionManager.java:221) ~[?]
at org.apache.http.impl.nio.client.CloseableHttpAsyncClientBase$1.run(CloseableHttpAsyncClientBase.java:64) ~[?]
… 1 more

2019-11-10 16:29:41 EET [YAI.0103.0014I] [default][SAG-1LTD1Z2] Error while retrieving Documents for Index gateway_default, Type packages. Cause: Search request cannot be completed
2019-11-10 16:30:18 EET [YAI.0103.0012I] [default][SAG-1LTD1Z2] Error while creating/updating Document for Index gateway_default_audit, Type auditlogs, Id d4b01016-cee8-4560-999e-be0b9e717253. Cause: Timeout connecting to [/192.168.0.35:9240]
2019-11-10 16:30:18 EET [YAI.0205.0032E] [default][SAG-1LTD1Z2] Error sending pgmen event. Cause: com.softwareag.apigateway.core.exceptions.DataStoreException java.net.ConnectException: Timeout connecting to [/192.168.0.35:9240] com.softwareag.apigateway.core.exceptions.DataStoreException: java.net.ConnectException: Timeout connecting to [/192.168.0.35:9240]
at com.softwareag.apigateway.core.datastore.GatewayElasticsearchRepository.index(GatewayElasticsearchRepository.java:180) ~[?]
at com.softwareag.apigateway.core.datastore.GatewayElasticsearchRepository.index(GatewayElasticsearchRepository.java:162) ~[?]
at com.softwareag.apigateway.core.persistence.handlers.GatewayAuditlogPersistenceHandler.saveGatewayAuditlogData(GatewayAuditlogPersistenceHandler.java:33) ~[?]
at com.softwareag.pg.pgmen.events.gateway.GatewayAuditlogEventSender.onSend(GatewayAuditlogEventSender.java:61) ~[?]
at com.softwareag.pg.pgmen.events.EventSender.send(EventSender.java:16 ~[?]
at com.softwareag.pg.pgmen.events.BaseEventPublisher.sendHere(BaseEventPublisher.java:276) ~[?]
at com.softwareag.pg.pgmen.events.BaseEventPublisher.publish(BaseEventPublisher.java:249) ~[?]
at com.softwareag.pg.pgmen.events.BaseEventPublisher.lambda$publishEventAsync$2(BaseEventPublisher.java:216) ~[?]
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590) [?:1.8.0_222]
at java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1582) [?:1.8.0_222]
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289) [?:1.8.0_222]
at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056) [?:1.8.0_222]
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692) [?:1.8.0_222]
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157) [?:1.8.0_222]
Caused by: java.net.ConnectException: Timeout connecting to [/192.168.0.35:9240]
at org.elasticsearch.client.RestClient.extractAndWrapCause(RestClient.java:804) ~[?]
at org.elasticsearch.client.RestClient.performRequest(RestClient.java:225) ~[?]
at org.elasticsearch.client.RestClient.performRequest(RestClient.java:212) ~[?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.performRequest(ElasticsearchClientImpl.java:170) ~[?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.createOrUpdate(ElasticsearchClientImpl.java:147 ~[?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.createDocument(ElasticsearchClientImpl.java:333) ~[?]
at com.softwareag.apigateway.core.datastore.GatewayElasticsearchRepository.index(GatewayElasticsearchRepository.java:174) ~[?]
… 13 more
Caused by: java.net.ConnectException: Timeout connecting to [/192.168.0.35:9240]
at org.apache.http.nio.pool.RouteSpecificPool.timeout(RouteSpecificPool.java:169) ~[?]
at org.apache.http.nio.pool.AbstractNIOConnPool.requestTimeout(AbstractNIOConnPool.java:62 ~[?]
at org.apache.http.nio.pool.AbstractNIOConnPool$InternalSessionRequestCallback.timeout(AbstractNIOConnPool.java:894) ~[?]
at org.apache.http.impl.nio.reactor.SessionRequestImpl.timeout(SessionRequestImpl.java:183) ~[?]
at org.apache.http.impl.nio.reactor.DefaultConnectingIOReactor.processTimeouts(DefaultConnectingIOReactor.java:210) ~[?]
at org.apache.http.impl.nio.reactor.DefaultConnectingIOReactor.processEvents(DefaultConnectingIOReactor.java:155) ~[?]
at org.apache.http.impl.nio.reactor.AbstractMultiworkerIOReactor.execute(AbstractMultiworkerIOReactor.java:351) ~[?]
at org.apache.http.impl.nio.conn.PoolingNHttpClientConnectionManager.execute(PoolingNHttpClientConnectionManager.java:221) ~[?]
at org.apache.http.impl.nio.client.CloseableHttpAsyncClientBase$1.run(CloseableHttpAsyncClientBase.java:64) ~[?]
at java.lang.Thread.run(Thread.java:74 ~[?:1.8.0_222]

2019-11-10 16:30:41 EET [YAI.0300.8889E] [default][SAG-1LTD1Z2] Exception while searching index. Search request cannot be completed due IOException java.net.ConnectException: Timeout connecting to [/192.168.0.35:9240]
at org.elasticsearch.client.RestClient.extractAndWrapCause(RestClient.java:804) ~[?]
at org.elasticsearch.client.RestClient.performRequest(RestClient.java:225) ~[?]
at org.elasticsearch.client.RestClient.performRequest(RestClient.java:212) ~[?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.performRequest(ElasticsearchClientImpl.java:170) ~[?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.searchDoc(ElasticsearchClientImpl.java:1613) ~[?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.searchDocuments(ElasticsearchClientImpl.java:1122) [?]
at com.softwareag.apigateway.core.datastore.ElasticsearchClientImpl.searchDocuments(ElasticsearchClientImpl.java:1175) [?]
at com.softwareag.apigateway.core.datastore.ElasticSearchQueryExecutor.fetchDocuments(ElasticSearchQueryExecutor.java:147) [?]
at com.softwareag.apigateway.core.datastore.ElasticSearchQueryExecutor.getResponse(ElasticSearchQueryExecutor.java:57) [?]
at com.softwareag.apigateway.core.datastore.ElasticSearchQueryExecutor.execute(ElasticSearchQueryExecutor.java:29) [?]
at com.softwareag.apigateway.core.datastore.GatewayElasticsearchRepository.findRecords(GatewayElasticsearchRepository.java:235) [?]
at com.softwareag.apigateway.core.datastore.GatewayElasticsearchRepository.findAll(GatewayElasticsearchRepository.java:223) [?]
at com.softwareag.apigateway.core.persistence.handlers.PackagePersistanceHandler.getAll(PackagePersistanceHandler.java:30) [?]
at com.softwareag.apigateway.core.manager.PackageManager.getAll(PackageManager.java:155) [?]
at com.softwareag.pg.pgmen.processors.QuotaSurvivalProcessor.exec(QuotaSurvivalProcessor.java:41) [?]
at com.softwareag.pg.pgmen.processors.DCProcessor.run(DCProcessor.java:3 [?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_222]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:30 [?:1.8.0_222]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_222]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_222]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_222]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_222]
at java.lang.Thread.run(Thread.java:74 [?:1.8.0_222]
Caused by: java.net.ConnectException: Timeout connecting to [/192.168.0.35:9240]
at org.apache.http.nio.pool.RouteSpecificPool.timeout(RouteSpecificPool.java:169) ~[?]
at org.apache.http.nio.pool.AbstractNIOConnPool.requestTimeout(AbstractNIOConnPool.java:62 ~[?]
at org.apache.http.nio.pool.AbstractNIOConnPool$InternalSessionRequestCallback.timeout(AbstractNIOConnPool.java:894) ~[?]
at org.apache.http.impl.nio.reactor.SessionRequestImpl.timeout(SessionRequestImpl.java:183) ~[?]
at org.apache.http.impl.nio.reactor.DefaultConnectingIOReactor.processTimeouts(DefaultConnectingIOReactor.java:210) ~[?]
at org.apache.http.impl.nio.reactor.DefaultConnectingIOReactor.processEvents(DefaultConnectingIOReactor.java:155) ~[?]
at org.apache.http.impl.nio.reactor.AbstractMultiworkerIOReactor.execute(AbstractMultiworkerIOReactor.java:351) ~[?]
at org.apache.http.impl.nio.conn.PoolingNHttpClientConnectionManager.execute(PoolingNHttpClientConnectionManager.java:221) ~[?]
at org.apache.http.impl.nio.client.CloseableHttpAsyncClientBase$1.run(CloseableHttpAsyncClientBase.java:64) ~[?]
… 1 more

2019-11-10 16:30:41 EET [YAI.0103.0014I] [default][SAG-1LTD1Z2] Error while retrieving Documents for Index gateway_default, Type packages. Cause: Search request cannot be completed

Hi Deniz,

Please check whether the internal data store is down by invoking http://localhost:9240/

Thanks,
Mohammed

Thanks for the reply Mohammad.

I checked and Data Store is up as it responded the outputs shown below.You can also find the screenshot in the attachment.

{
“name” : “SAG-1LTD1Z2.eur.ad.sag1573228897589”,
“cluster_name” : “SAG_EventDataStore”,
“cluster_uuid” : “hWoX3McqSlCu9Y_FQY-_Fg”,
“version” : {
“number” : “7.2.0”,
“build_flavor” : “oss”,
“build_type” : “zip”,
“build_hash” : “508c38a”,
“build_date” : “2019-06-20T15:54:18.811730Z”,
“build_snapshot” : false,
“lucene_version” : “8.0.0”,
“minimum_wire_compatibility_version” : “6.8.0”,
“minimum_index_compatibility_version” : “6.0.0-beta1”
},
“tagline” : “You Know, for Search”
}

Can you please invoke the below url and share us the results to check ES is accessible from API Gateway
GET /rest/apigateway/apis HTTP/1.1
Host: localhost:5555
Accept: application/json
Authorization: Basic QWRtaW5pc3RyYXRvcjptYW5hZ2U=

Thanks,
Mohammed

(post withdrawn by author, will be automatically deleted in 24 hours unless flagged)