Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Database Performance Analyzer (DPA) > Error logging into DPA; Invalid object name 'CONPRM'

Error logging into DPA; Invalid object name 'CONPRM'

Updated April 25th, 2017

Overview

When logging in to DPA, you receive the following error:

DPA was stopped due to the following error. DPA is attempting to restart try again in 30 seconds.
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select V from CONPRM where P = ?]; nested exception is java.sql.SQLException: Invalid object name 'CONPRM'

Environment

All DPA versions

Cause 

The repository user was given SYSADMIN privileges.

The SYSADMIN server role defaults to the dbo Schema. By removing the SYSADMIN role, it can default to the Ignite schema.

Resolution

  1. Remove the sys_admin server role from the repo user.
  2. Grant it DB owner over DB, and make sure it defaults to Ignite schema.
  3. Restart the Ignite server service.

 

Last modified

Tags

Classifications

Public