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


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'


All DPA versions


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.


  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