APM Database config error thrown in IntroscopeEnterpriseManager.log file.

book

Article ID: 37193

calendar_today

Updated On:

Products

APP PERF MANAGEMENT CA Application Performance Management Agent (APM / Wily / Introscope) CUSTOMER EXPERIENCE MANAGER INTROSCOPE

Issue/Introduction

Problem:

We are using Oracle for the APM backend database which seems to be working without any issues however below error is still getting logged in EM logs:

[Manager.com.timestock.tess.util.DbConfigurationUtil] Could not get the Database Configuration.

java.lang.StringIndexOutOfBoundsException: String index out of range: -2

at java.lang.String.substring(String.java:1955)

at com.timestock.tess.util.DbConfigurationUtil.parseDBUrlPostgres(DbConfigurationUtil.java:415)

at com.timestock.tess.util.DbConfigurationUtil.getDbConfigurationFromXml(DbConfigurationUtil.java:100)

at com.timestock.tess.util.DbConfigurationUtil.getDbConfigurationFromXml(DbConfigurationUtil.java:55)

at com.timestock.tess.util.DbConfigurationUtil.getDbConfiguration(DbConfigurationUtil.java:46)

at com.timestock.tess.util.TessConfigConstants.getValue(TessConfigConstants.java:12)

at com.timestock.tess.util.TessConfigConstants.getIntConstant(TessConfigConstants.java:43)

 

How can we address this ? Why is EM trying to parse the Database URL as Postgres instead of Oracle ?

Cause:

Issue is caused due to the fact that the required entry in the tess-db-cfg.xml <property name="em.dbtype"> had incorrect value specified.

Property is case sensitive and in this case customer had specified "oracle" instead of "Oracle" due to which EM was parsing the Database connection URL as Postgres instead of Oracle and throwing the error.

 

Resolution:

Modified the tess-db-cfg.xml from

<property name="em.dbtype">oracle</property>

to

<property name="em.dbtype">Oracle</property>

address the issue.

 

 

 

 

 

 

 

 

Environment

Release: CEMUGD00200-10.1-Introscope to CA Application-Performance Management-Upgrade Mai
Component: