How do I view Charts in the Operator Console that were created in a QDB that has been moved? (NETIQKB42216)

  • 7742216
  • 02-Feb-2007
  • 01-Nov-2010

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

How do I view Charts in the Operator Console that were created in a QDB that has since been moved to a new SQL server?

Resolution

To view the Charts created in the QDB before the database was moved to another server, ensure that the Logon ID being used to access SQL on the new QDB server is identical to the Logon ID that was used to access SQL on the old QDB server then perform the following steps:

  1. Launch SQL Query Analyzer on the new QDB server.
  2. Select the QDB.
  3. Query the blob table to get the row values for previously existing charts by using the following query (This query will not work if the QDBis not the actively selected database in SQL Query Analyzer):

    select * from blob
  4. You will get a return consisting of a list of rows representing chart info.  The content of the "Comment" value is the piece you will want to inspect.  On each chart row, the Comment value should be in the format: Charts_<QDB server name>\<qdb name>\<user> Where the <QDB server name> represents the name of the Server that previously hosted the QDB, <qdb name> represents the name of your QDB, and <user> represents the Logon ID being used to access SQL on the old QDB server.
  5. The content of that field should be the same on each row all the way through, unless multiple accounts were used to create Charts on the old QDB server.  The existing Comment value on these old charts will need to be changed to match the Comment value as they would have appeared had the charts been created while the QDB was on the new QDB server.  The following steps will help you to accomplish this:
    • In the Operator Console that is pointing at the QDB on the new SQL Server, create ONE new chart.
    • Re-query the blob table with the follwing query:  
      • select * from blob
    • Compare the value in the Comment field on the old charts to the value of the Comment field for the newly created chart.  The server name in the Comment field representing the previously created Charts will not match the server name of the new QDB SQL Server.
  6. To fix the old charts so that SQL will see the ID that is accessing the new SQL server as the same ID that created the old charts on the old SQL server, you will need to replicate the value from the Comment field of the new chart you created above, to the Comment field of all the charts that were created when the QDB was on the old QDB Server.  You will accomplish this by using the following query:

    update blob set comment = 'Charts_<NEW QDB Server>\<qdb name>\<user>' where comment = 'Charts_<OLD QDB Server>\<qdb name>\<user>'
  7. Once the query has completed, you can verify your changes were successfully replicated to all the old charts by re-running the following query:
    • select * from blob 
  8. If the results are successful, you can then re-open the Operator Console, and you should be able to view your charts.

Additional Information

Formerly known as NETIQKB42216