Update Cisco ACS 5.1 to 5.3

[baev_aleksei]

After the upgrade from version 5.1 to 5.3 does not start the process of view-logprocessor. The update process went without error.

Please, help me.

#-----------------------------------------------------------------

show application status acs

ACS role: PRIMARY

Process 'database'                  running
Process 'management'                running
Process 'runtime'                   running
Process 'view-database'             running
Process 'view-jobmanager'           running
Process 'view-alertmanager'         running
Process 'view-collector'            running
Process 'view-logprocessor'         not monitored

#-----------------------------------------------------------------

show application version acs

Cisco ACS VERSION INFORMATION
-----------------------------
Version : 5.3.0.40
Internal Build ID : B.839

[mohanak]

Please check the BUG :

'view-logprocessor' Process stuck in 'not monitored'

CSCtw64212

Description

Symptom:
Customer noticed this after the Upgrade from 5.1 to 5.2

Conditions:

restarting the services or rebooting doesn't help.

rchtd16-acs1/admin# show application status acs

ACS role: PRIMARY

Process 'database' running
Process 'management' running
Process 'runtime' running
Process 'view-database' running
Process 'view-jobmanager' running
Process 'view-alertmanager' running
Process 'view-collector' running
Process 'view-logprocessor' not monitored


Workaround:


The reason the log_processor is stuck in not monitored because the View h2 database is corrupted.

In MonitoringAndReportingProcess.log we can see exceptions:
2011-11-29 17:55:34 :: Starting Log Processor...
:::
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Unique index or primary key violation:
SYS_ID ON PUBLIC.SYS(ID) [23001-114]

We need to cleanup the h2 database

First, youll need to install the root patch, and access (console port) as root to the Linux shell.
I am attaching the root patch in the email.
-We need to have console port access for this

After we have installed the root patch, we would perform the following steps to resolve the issue.

Please find the below steps for replacing h2 DB with clean DB.

1. Please stop the services using "application stop acs" command.

2. Take backup of h2 db from /opt/CSCOacs/view/data/h2 to
/localdisk

3. delete all the RadiusSession and TacacsSession csv files.

rm -rf RadiusSession*

rm -rf TacacsSession*

4. Replaced /opt/CSCOacs/view/data/h2 files with
/opt/CSCOacs/view/data/h2/clean-install/* files

cp /opt/CSCOacs/view/data/h2/clean-install/*
/opt/CSCOacs/view/data/h2

5. Restarted the services

Known Fixed Releases:

(2)

5.4(0.46)

5.3(0.40.2)

Known Affected Releases:

(2)

5.2(0.20)

5.3(0.40)

[baev_aleksei]

Thanks for your reply.

Please tell me where I can download the "root patch"?