ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

EM SAP - Unable to connect to SQuirreL

book

Article ID: 145894

calendar_today

Updated On:

Products

CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

Would like to connect APMSQlServer to SQuirreL, we are following steps as per documentation:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-5/integrating/apmsql-cookbook/connect-to-ca-apmsql.html

But we get below error:
TEIID20020 Error establishing socket to host and port: 
Reason: TEIID20032 Could not connect to server in non-SSL mode. The server may be configured for SSL”

In apmserverlog.txt:
6/06/19 04:51:25.920 AM EDT [INFO] [NIO1] [APMSqlSecurityHelper] Invalid username/token :Admin, Http Response :404,Not Found

In IntrosocpeEnterpriseManager.log:
Jun 06, 2019 4:51:25 AM org.springframework.web.servlet.PageNotFound noHandlerFound
WARNING: No mapping found for HTTP request with URI [/apm/appmap/private/token/temporaryToken] in DispatcherServlet with name 'rest-dispatcher'
Jun 06, 2019 4:51:25 AM org.springframework.web.servlet.PageNotFound noHandlerFound
WARNING: No mapping found for HTTP request with URI [/apm/appmap/private/apmData/schema] in DispatcherServlet with name 'rest-dispatcher'

Cause

REST API is not available in EM SAP version

From EM log:
6/05/19 07:29:14.698 PM EDT [VERBOSE] [main] [Manager.PropertyService] Added introscope.apm.feature.enabled=false

Environment

APM 10.5.2

Resolution

Solution:
None, enhancement request opened DE420457-Add APMSQLServer support for EM SAP

Workarounds:
Use CLWorkstation, IntrsocopeJDBC, Webserver SDK or SmartstorTool.