Running Silent Install for APM EM upgrade does not upgrade the schema for PostgreSQL cemdb database even though "upgradeSchema=true" is set in response file. What can be done about this?
search cancel

Running Silent Install for APM EM upgrade does not upgrade the schema for PostgreSQL cemdb database even though "upgradeSchema=true" is set in response file. What can be done about this?

book

Article ID: 48619

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope) INTROSCOPE

Issue/Introduction

Description:

Using the following silent install response file settings results in successful upgrade of the software but the PostgreSQL database schema for the cemdbdatabase is not upgraded i.e. no schematools.log file is created in the install directory and the value of column ts_db_versions in table ts_domains remains unchanged.

silentInstallChosenFeatures=Enterprise Manager,WebView,ProbeBuilder,DatabaseshouldUpgrade=true           dbHost=127.0.0.1             dbPort=5432                       dbName=cemdb                    dbUser=admin                        dbPassword=********                                                            databaseDir=C:\\Progra~2\\CAAPM~1\\database  dbAdminUser=postgres                dbAdminPassword=********                                              validateDatabase=true             upgradeSchema=true 

Solution:

The problem was confirmed as being due to having the option "validateDatabase=true" enabled and this will be fixed in a future release.

In the meantime the "validateDatabase=true" should be left commented which is the default.

Environment

Release:
Component: APMINT