Error after DB restore

0
We moved our application to a new server and when we try and when we try and access certain parts of the application we get an error of: ERROR: permission denied for sequence system$filedocumentfilenamemxseq The full stack trace below: le: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: Failed to retrieve autonumber value for object 'CRMMaster.DashBoardImage' at CRMMaster.DS_RetrieveImage (CreateAndChange : 'Create DashBoardImage') Advanced stacktrace: at mv.a(SourceFile:185) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: Failed to retrieve autonumber value for object 'CRMMaster.DashBoardImage' at hC.a(SourceFile:184) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: Failed to retrieve autonumber value for object 'CRMMaster.DashBoardImage' at hC.b(SourceFile:218) Caused by: com.mendix.core.CoreRuntimeException: Failed to retrieve autonumber value for object 'CRMMaster.DashBoardImage' at ii.a(SourceFile:917) Caused by: l: An exception has occurred for the following request(s): fp@6624305 at x.a(SourceFile:49) Caused by: l: Exception occurred while retrieving data. (SQL State: 42501, Error Code: 0) at H.a(SourceFile:1398) Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for sequence system$filedocumentfilenamemxseq at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at H.a(SourceFile:313) at H.a(SourceFile:209) at H.a(SourceFile:159) at H.a(SourceFile:148) at z.a(SourceFile:41) at dA.a(SourceFile:192) at dA.a(SourceFile:150) at dA.a(SourceFile:83) at dE.a(SourceFile:68) at x.a(SourceFile:43) at h.a(SourceFile:269) at ii.a(SourceFile:906) at hf.a(SourceFile:65) at hf.c(SourceFile:28) at hf.executeAction(SourceFile:17) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:57) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:457) at hC.b(SourceFile:207) at hC.a(SourceFile:175) at com.mendix.core.Core.instantiate(SourceFile:650) at lK.a(SourceFile:33) at mv.a(SourceFile:72) at mu.a(SourceFile:151) at mu.executeAction(SourceFile:98) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:57) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:457) at hC.b(SourceFile:207) at com.mendix.core.Core.execute(SourceFile:226) at gn.execute(SourceFile:186) at jb.a(SourceFile:319) at com.mendix.externalinterface.connector.RequestDispatching$Worker.a(SourceFile:170) at com.mendix.externalinterface.connector.RequestDispatching$Worker$a.a(SourceFile:161) at com.mendix.externalinterface.connector.RequestDispatching$Worker$a.apply(SourceFile:160) at akka.actor.Actor$class.apply(Actor.scala:545) at com.mendix.externalinterface.connector.RequestDispatching$Worker.apply(SourceFile:156) at akka.actor.LocalActorRef.invoke(ActorRef.scala:910) at akka.dispatch.MessageInvocation.invoke(MessageHandling.scala:25) at akka.dispatch.ExecutableMailbox$class.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:223) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:123) at akka.dispatch.ExecutableMailbox$class.run(ExecutorBasedEventDrivenDispatcher.scala:195) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.run(ExecutorBasedEventDrivenDispatcher.scala:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) at akka.dispatch.MonitorableThread.run(ThreadPoolBuilder.scala:192) Any ideas as to what this could be ? Thanks Marc
asked
2 answers
0

I recommend to restore to a new database.

answered
0

Thanks. We finally figured out the issue. There were different owners on some of the objects and was causing issues. Updated permissions and it works 100%

answered