Cisco Security Manager

Document ID: 110387

Contents

Introduction
Prerequisites
      Requirements
      Components Used
      Conventions
Issue
Reason for this Issue
Resolution
NetPro Discussion Forums - Featured Conversations
Related Information

Introduction

This document explains how to remove pending activities from Cisco Security Manager.

Prerequisites

Requirements

There are no specific requirements for this document.

Components Used

The information in this document is based on the Cisco Security Manager 3.x version.

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

Refer to Cisco Technical Tips Conventions for more information on document conventions.

Issue

This document describes how to resolve an issue that results from this scenario:

• Cisco Security Manager version 3.2.0 is installed

• Pending changes exist in this version of CSM when you uninstall/install Cisco Security Manager to a new version of 3.2.2

• You want to restore the database from the previous version but can not. This error message appears, and the installation fails:

  Found uncommitted policy objects in the database! 
  Please save or discard any uncommitted data and then try again.

• This error can also be found from the migration log on the server.

Reason for this Issue

In this scenario, there is some uncommitted data in the previous version of Cisco Security Manager. The upgrade aborts if there is any uncommitted data in the backed up DB from where the restore is attempted.

The other possibility is that there is still some pending data, such as an object, policy, or policy assignment, that is not committed.

Check the Cisco Security Manager Deployment Manager to see if you have any pending jobs there.

Resolution

Note:  Before you upgrade to the later version, you must commit (submit) all the uncommitted data in the 3.x server and take a backup. Then restore this newly backed up data to the Cisco Security Manager 3.x.x server.

In order to remove the uncommitted objects, complete these steps:

Note:  Ensure that you make a DB backup on the previous version of Cisco Security Manager before you attempt this procedure.

1. Launch the Cisco Security Manager internal database:

   1. cd Program Files
      cd CSCOpx

   2. Launch dbisqlc from the command line. Database details:

      • username—DBA

      • password—This password is the one that you set during the original install of the CSM.

      

   3. If you forget the database password, complete these steps:

      1. Stop the Cisco Security Manager Daemon Manager:

         cd Program Files 
         cd CSCOpx
         cd bin

      2. Run perl dbpasswd.pl dsn=vms npwd=<new password>

         

   4. Once again, launch dbisqlc from the command line, and enter the database credentials.

2. Point the DB to Program Files > CSCOpx > databases > vms > vms.db in order to choose the correct database.

3. Run a query on the internal database to remove uncommitted objects:

   Run the script with these commands:

   delete from bb_main where activityid <> 0;
   delete from policy_main where activityid <> 0;
   delete from assignment_data where activityid <> 0;
   delete from hierarchy_nodes where activityid <> 0;
   commit;

   

4. Try the installation of the Cisco Security Manager version 3.2.2 again with the cleaned database.

NetPro Discussion Forums - Featured Conversations

Related Information

• Cisco Security Manager
• Technical Support & Documentation - Cisco Systems