Hi Guys,

I am trying to upgrade AR from version 1.5 to 2.0. But I am getting this
error when I log in.

catalina.out :

2016-07-21 14:40:29,384 ERROR [org.hibernate.util.JDBCExceptionReporter]
(http-nio-8080-exec-2) ERROR: relation "sod_case_info" does not exist
Position: 45
com.netiq.iac.persistence.spi.exception.IacPersist enceException:
org.hibernate.exception.SQLGrammarException: could not execute query
at
com.netiq.iac.persistence.dao.DataTransactor.execu te(DataTransactor.java:132)
at
com.netiq.iac.persistence.service.SoDPolicyService .getSoDCaseCount(SoDPolicyService.java:1960)
at
com.netiq.iac.server.rest.SoDService.getSoDCases(S oDService.java:1845)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at
com.sun.jersey.spi.container.JavaMethodInvokerFact ory$1.invoke(JavaMethodInvokerFactory.java:60)
at
com.sun.jersey.server.impl.model.method.dispatch.A bstractResourceMethodDispatchProvider$ResponseOutI nvoker._dispatch(AbstractResourceMethodDispatchPro v
ider.java:205)
at
com.sun.jersey.server.impl.model.method.dispatch.R esourceJavaMethodDispatcher.dispatch(ResourceJavaM ethodDispatcher.java:75)
at
com.sun.jersey.server.impl.uri.rules.HttpMethodRul e.accept(HttpMethodRule.java:302)
at
com.sun.jersey.server.impl.uri.rules.RightHandPath Rule.accept(RightHandPathRule.java:147)

.....

Caused by: org.postgresql.util.PSQLException: ERROR: relation
"fulfillment_item_combined" does not exist
Position: 1596
at
org.postgresql.core.v3.QueryExecutorImpl.receiveEr rorResponse(QueryExecutorImpl.java:2284)
at
org.postgresql.core.v3.QueryExecutorImpl.processRe sults(QueryExecutorImpl.java:2003)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(Q ueryExecutorImpl.java:200)
at
org.postgresql.jdbc.PgStatement.execute(PgStatemen t.java:424)
at
org.postgresql.jdbc.PgPreparedStatement.executeWit hFlags(PgPreparedStatement.java:161)
at
org.postgresql.jdbc.PgPreparedStatement.executeQue ry(PgPreparedStatement.java:114)
at
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedSta tement.executeQuery(DelegatingPreparedStatement.ja va:82)
at
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedSta tement.executeQuery(DelegatingPreparedStatement.ja va:82)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(Ab stractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.ja va:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:80 2)
at
org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:253 3)
.... 65 more
2016-07-21 14:40:29,649 ERROR
[com.netiq.iac.server.rest.FulfillmentService] (http-nio-8080-exec-10)
[AR] Encountered unexpected error: could not execute query


How can I solve this? Obviously the DB schema is wrong. I tried install
AR with DB option as "Update Existing..." and "Create a new..." but the
result is the same. The Error persists.
Thanks for a help.

Regards,
Milan


--
mjuricek
------------------------------------------------------------------------
mjuricek's Profile: https://forums.netiq.com/member.php?userid=1616
View this thread: https://forums.netiq.com/showthread.php?t=56307