Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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

Error logging into DPA; Invalid object name 'CONPRM'

Created by Robert Holtam, last modified by Riggs Clough on Nov 16, 2016

Views: 115 Votes: 1 Revisions: 6

Updated

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
11:46, 16 Nov 2016

Tags

Classifications

Public