Applications Systems

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

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'

First published date

11/21/2018 11:19 PM

Last published date

5/9/2025 8:42 PM

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'
 

Product section

Database Performance Analyzer

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 
  2. Add the repository login to the db_owner database role.
    For more information see ALTER ROLE 
  3. Make sure the repository login defaults to the ignite schema.
    For more information see ALTER USER 
  4. Restart DPA.