Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Error logging in to DPA: Invalid object name 'CONPRM'

Error logging in to DPA: Invalid object name 'CONPRM'

Updated February 15, 2018

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

DPA, all versions

Cause 

The repository login was assigned to the sysadmin server role.

A login assigned to the sysadmin server role always defaults to the dbo schema, regardless of what is in the user mapping. The login will not see tables in the ignite schema, because it is looking at the dbo schema. Instead of looking for ignite.CONPRM, it looks for dbo.CONPRM

When you remove the repository login from the sysadmin server role, the repository login can default to the ignite schema.

Resolution

  1. Remove the repository login from the sysadmin server role.
    For more information see ALTER SERVER ROLE (© 2018 Microsoft, available at https://docs.microsoft.com, obtained on January 22, 2018).
  2. Add the repository login to the db_owner database role.
    For more information see ALTER ROLE (© 2018 Microsoft, available at https://docs.microsoft.com, obtained on January 22, 2018).
  3. Make sure the repository login defaults to the ignite schema.
    For more information see ALTER USER (© 2018 Microsoft, available at https://docs.microsoft.com, obtained on January 22, 2018).
  4. Restart DPA.

 

Last modified

Tags

Classifications

Public