Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Error registering a database in DPA Map Empty

Error registering a database in DPA Map Empty

Updated August 24th, 2017

Overview

You get the following error when trying to register an Oracle or SQL Server instance:

 

Environment

DPA, all supported versions

Cause 

 

Oracle

  • This occurs during the building of the TEMP TABLESPACE and TABLESPACE drop-down lists of the second wizard screen.
    • Since there is a failure building the lists, the web-flow dumps a stack trace.
  • Other possible cause is the Oracle recycle bin on the Repository database being full. 
  • The source code fix is to catch the DataAccessException thrown by Spring JDBC and log the error, and then proceed with a new status of DATAFILE_ACCESS_ERROR, which causes the application to use the database's default tablespaces.

-----------------

SQL Server

  • This occurred due to a cumulative update and change in how SQL server presents versions, causing issues with how DPA monitors SQL instances

 

Resolution

Oracle

  • Check that the Oracle repository recycle bin is not full.
  • Set the system property ORACLE_REG_DB_USE_DEFAULT_TABLESPACES=true.
    • This will force the wizard to only display SYSTEM - Default for the Tablespace, and TEMP - Default for the Temp Tablespace.
    • From the DPA home page, Go to Options>Administration Tab>Advanced Options>Support Options Tab and search for
      • " ORACLE_REG_DB_USE_DEFAULT_TABLESPACES
    • Click on the name to display the Edit Option box, click the drop down arrow and set to "True" and click the update button.

--------------------

SQL Server

  • Upgrade DPA to at least Version 10.0

 

 

 

Last modified

Tags

Classifications

Public