Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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: 171 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