DPA Startup Failure

Question

Hi

When I try to go to the login page for DPA on my browser, I'm getting

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 com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'CONPRM'. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1583) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:675) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:721) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:752) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:758) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:879) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:903) at com.confio.ignite.common.parameters.dao.ParameterDaoImpl.getParameterValue(SourceFile:276) at com.confio.ignite.common.parameters.dao.ParameterDaoImpl.getRepositoryParameterValue(SourceFile:257) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:113) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:241) at com.sun.proxy.$Proxy78.getRepositoryParameterValue(Unknown Source)

Any suggestions as to what this means?

newport2 · Answer

Hey, thanks for your response. No, didn't touch the db server. I figured out what it was and your suggestion is a good one. The dpa login uses a db user called "ignite" with a default schema of "ignite". So I figured it had somehow lost that, used the server default schema of dbo and was looking for the table dbo.CONPRM which doesn't exist, instead of ignite.CONPRM.  I removed the default schema setting ignite from the user and re-applied it back and that sorted it.

Appreciate your input.

vinay.by · Answer

@newport2 - looks like an issue with your database, did you recently upgrade or do anything with your setup ?

The first line on error clearly states that

select V from CONPRM where P = ? —> Invalid object name 'CONPRM'