Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

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