Error logging into DPA; Invalid object name 'CONPRM'

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.