Updated February 15, 2018
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'
DPA, all versions
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.
sysadmin
server role.db_owner
database role.ignite
schema.