RAM repository is not the correct version error.
I ran into the following problem after a successful setup of RAM 7.2.0.2 on a WAS ND 6.1.0.29 cluster. I got RAM 7.2.0.2 from the external site. I am using DB2 Enterprise Dev Ed 9.7.1
I used the ram setup application to install and configure RAM. The installation was successful. When I go to the RAM web UI, I see this:
The Rational Asset Manager repository is not the correct version. Contact your Rational Asset Manager administrator to notify them about this problem. If you are the administrator, when you log in you will be taken the migration page.
I was doing a clean install of RAM in that I had uninstalled previous versions.
If I continue by logging into the the RAM web application, I get this error:
An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-206", SQLSTATE "42703" and message tokens "RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.58.82
Is the problem my version of DB2? Here is the trace:
javax.faces.FacesException: #{pc_Register.doRegister}: javax.faces.el.EvaluationException: com.ibm.ram.repository.security.RAMEntitlementException: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException: QE select:"RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.58.82
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:79)
at javax.faces.component.UICommand.broadcast(UICommand.java:312)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:302)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:419)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:77)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:220)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:91)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1152)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1087)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at com.ibm.ram.repository.web.security.RAMServletFilter.doFilter(RAMServletFilter.java:418)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ram.repository.web.filters.GZipFilter.doFilter(GZipFilter.java:42)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:837)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:680)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:588)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:525)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:751)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1478)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:126)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: javax.faces.el.EvaluationException: com.ibm.ram.repository.security.RAMEntitlementException: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException: QE select:"RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.58.82
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:131)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:73)
... 36 more
Caused by: com.ibm.ram.repository.security.RAMEntitlementException: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException: QE select:"RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.58.82
at com.ibm.ram.repository.security.AbstractUser.init(AbstractUser.java:302)
at com.ibm.ram.repository.security.AbstractUser.reinit(AbstractUser.java:233)
at com.ibm.ram.repository.security.AbstractUser.initializeIfNeeded(AbstractUser.java:263)
at com.ibm.ram.repository.security.RegisteredUser.isRegistered(RegisteredUser.java:231)
at com.ibm.ram.repository.security.SecurityManager.logoutUser(SecurityManager.java:485)
at com.ibm.ram.repository.web.security.Login.refreshUser(Login.java:311)
at pagecode.includes.Preferences.refreshUser(Preferences.java:112)
at pagecode.includes.Preferences.modifyUser(Preferences.java:89)
at pagecode.secure.Register.doRegister(Register.java:63)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:127)
... 37 more
Caused by: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException: QE select:"RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.58.82
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.createRepositoryException(BaseRAMSchemaAccess.java:1905)
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.throwRepositoryException(BaseRAMSchemaAccess.java:1896)
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.getResourceGroup(BaseRAMSchemaAccess.java:6280)
at com.ibm.ram.repository.security.SecurityManager.getConsoleGroup(SecurityManager.java:697)
at com.ibm.ram.repository.security.RegisteredUser.postInit(RegisteredUser.java:126)
at com.ibm.ram.repository.security.AbstractUser.init(AbstractUser.java:294)
... 50 more
Caused by: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException$RepositoryLinkedException: com.ibm.db2.jcc.am.ro: "RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.58.82
at com.ibm.db2.jcc.am.ed.a(ed.java:676)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.tm.c(tm.java:2523)
at com.ibm.db2.jcc.am.tm.d(tm.java:2511)
at com.ibm.db2.jcc.am.tm.a(tm.java:1991)
at com.ibm.db2.jcc.t4.fb.g(fb.java:140)
at com.ibm.db2.jcc.t4.fb.a(fb.java:40)
at com.ibm.db2.jcc.t4.t.a(t.java:32)
at com.ibm.db2.jcc.t4.ub.i(ub.java:135)
at com.ibm.db2.jcc.am.tm.fb(tm.java:1962)
at com.ibm.db2.jcc.am.um.nc(um.java:2989)
at com.ibm.db2.jcc.am.um.b(um.java:3760)
at com.ibm.db2.jcc.am.um.Zb(um.java:673)
at com.ibm.db2.jcc.am.um.executeQuery(um.java:647)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:681)
at com.ibm.ws.sdo.mediator.jdbc.JDBCAdapter.executeSelect(Unknown Source)
at com.ibm.ws.sdo.mediator.jdbc.ConnectionWrapperImpl.executeSelect(Unknown Source)
at com.ibm.ws.sdo.mediator.jdbc.queryengine.QueryEngineImpl.executeReadQuery(Unknown Source)
at com.ibm.ws.sdo.mediator.jdbc.queryengine.QueryEngineImpl.executeSelect(Unknown Source)
at com.ibm.ws.sdo.mediator.jdbc.MediatorImpl.getGraph(Unknown Source)
at com.ibm.ws.sdo.mediator.jdbc.MediatorImpl.getGraph(Unknown Source)
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.getResourceGroup(BaseRAMSchemaAccess.java:6271)
... 53 more
Caused by: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException$RepositoryLinkedException: com.ibm.db2.jcc.am.SqlException: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-206", SQLSTATE "42703" and message tokens "RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.58.82
at com.ibm.db2.jcc.am.ed.a(ed.java:679)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.tm.c(tm.java:2523)
at com.ibm.db2.jcc.am.tm.d(tm.java:2511)
at com.ibm.db2.jcc.am.um.a(um.java:2893)
at com.ibm.db2.jcc.t4.fb.a(fb.java:189)
at com.ibm.db2.jcc.t4.fb.b(fb.java:83)
at com.ibm.db2.jcc.t4.t.b(t.java:69)
at com.ibm.db2.jcc.t4.vb.c(vb.java:242)
at com.ibm.db2.jcc.am.um.kc(um.java:2884)
at com.ibm.db2.jcc.am.um.nc(um.java:2990)
... 64 more
Caused by: com.ibm.db2.jcc.am.SqlException: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-206", SQLSTATE "42703" and message tokens "RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.58.82
at com.ibm.db2.jcc.am.ed.a(ed.java:679)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.tm.c(tm.java:2523)
at com.ibm.db2.jcc.am.tm.a(tm.java:2018)
at com.ibm.db2.jcc.t4.fb.n(fb.java:802)
at com.ibm.db2.jcc.t4.fb.i(fb.java:259)
at com.ibm.db2.jcc.t4.fb.c(fb.java:54)
at com.ibm.db2.jcc.t4.t.c(t.java:44)
at com.ibm.db2.jcc.t4.ub.j(ub.java:147)
at com.ibm.db2.jcc.am.tm.hb(tm.java:2013)
at com.ibm.db2.jcc.am.um.b(um.java:3819)
... 63 more
I used the ram setup application to install and configure RAM. The installation was successful. When I go to the RAM web UI, I see this:
The Rational Asset Manager repository is not the correct version. Contact your Rational Asset Manager administrator to notify them about this problem. If you are the administrator, when you log in you will be taken the migration page.
I was doing a clean install of RAM in that I had uninstalled previous versions.
If I continue by logging into the the RAM web application, I get this error:
An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-206", SQLSTATE "42703" and message tokens "RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.58.82
Is the problem my version of DB2? Here is the trace:
javax.faces.FacesException: #{pc_Register.doRegister}: javax.faces.el.EvaluationException: com.ibm.ram.repository.security.RAMEntitlementException: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException: QE select:"RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.58.82
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:79)
at javax.faces.component.UICommand.broadcast(UICommand.java:312)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:302)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:419)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:77)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:220)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:91)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1152)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1087)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at com.ibm.ram.repository.web.security.RAMServletFilter.doFilter(RAMServletFilter.java:418)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ram.repository.web.filters.GZipFilter.doFilter(GZipFilter.java:42)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:837)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:680)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:588)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:525)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:751)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1478)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:126)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: javax.faces.el.EvaluationException: com.ibm.ram.repository.security.RAMEntitlementException: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException: QE select:"RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.58.82
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:131)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:73)
... 36 more
Caused by: com.ibm.ram.repository.security.RAMEntitlementException: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException: QE select:"RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.58.82
at com.ibm.ram.repository.security.AbstractUser.init(AbstractUser.java:302)
at com.ibm.ram.repository.security.AbstractUser.reinit(AbstractUser.java:233)
at com.ibm.ram.repository.security.AbstractUser.initializeIfNeeded(AbstractUser.java:263)
at com.ibm.ram.repository.security.RegisteredUser.isRegistered(RegisteredUser.java:231)
at com.ibm.ram.repository.security.SecurityManager.logoutUser(SecurityManager.java:485)
at com.ibm.ram.repository.web.security.Login.refreshUser(Login.java:311)
at pagecode.includes.Preferences.refreshUser(Preferences.java:112)
at pagecode.includes.Preferences.modifyUser(Preferences.java:89)
at pagecode.secure.Register.doRegister(Register.java:63)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:127)
... 37 more
Caused by: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException: QE select:"RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.58.82
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.createRepositoryException(BaseRAMSchemaAccess.java:1905)
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.throwRepositoryException(BaseRAMSchemaAccess.java:1896)
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.getResourceGroup(BaseRAMSchemaAccess.java:6280)
at com.ibm.ram.repository.security.SecurityManager.getConsoleGroup(SecurityManager.java:697)
at com.ibm.ram.repository.security.RegisteredUser.postInit(RegisteredUser.java:126)
at com.ibm.ram.repository.security.AbstractUser.init(AbstractUser.java:294)
... 50 more
Caused by: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException$RepositoryLinkedException: com.ibm.db2.jcc.am.ro: "RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.58.82
at com.ibm.db2.jcc.am.ed.a(ed.java:676)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.tm.c(tm.java:2523)
at com.ibm.db2.jcc.am.tm.d(tm.java:2511)
at com.ibm.db2.jcc.am.tm.a(tm.java:1991)
at com.ibm.db2.jcc.t4.fb.g(fb.java:140)
at com.ibm.db2.jcc.t4.fb.a(fb.java:40)
at com.ibm.db2.jcc.t4.t.a(t.java:32)
at com.ibm.db2.jcc.t4.ub.i(ub.java:135)
at com.ibm.db2.jcc.am.tm.fb(tm.java:1962)
at com.ibm.db2.jcc.am.um.nc(um.java:2989)
at com.ibm.db2.jcc.am.um.b(um.java:3760)
at com.ibm.db2.jcc.am.um.Zb(um.java:673)
at com.ibm.db2.jcc.am.um.executeQuery(um.java:647)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:681)
at com.ibm.ws.sdo.mediator.jdbc.JDBCAdapter.executeSelect(Unknown Source)
at com.ibm.ws.sdo.mediator.jdbc.ConnectionWrapperImpl.executeSelect(Unknown Source)
at com.ibm.ws.sdo.mediator.jdbc.queryengine.QueryEngineImpl.executeReadQuery(Unknown Source)
at com.ibm.ws.sdo.mediator.jdbc.queryengine.QueryEngineImpl.executeSelect(Unknown Source)
at com.ibm.ws.sdo.mediator.jdbc.MediatorImpl.getGraph(Unknown Source)
at com.ibm.ws.sdo.mediator.jdbc.MediatorImpl.getGraph(Unknown Source)
at com.ibm.ram.repository.core.sdo.BaseRAMSchemaAccess.getResourceGroup(BaseRAMSchemaAccess.java:6271)
... 53 more
Caused by: com.ibm.ram.repository.core.IRepositoryAccess$RepositoryException$RepositoryLinkedException: com.ibm.db2.jcc.am.SqlException: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-206", SQLSTATE "42703" and message tokens "RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.58.82
at com.ibm.db2.jcc.am.ed.a(ed.java:679)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.tm.c(tm.java:2523)
at com.ibm.db2.jcc.am.tm.d(tm.java:2511)
at com.ibm.db2.jcc.am.um.a(um.java:2893)
at com.ibm.db2.jcc.t4.fb.a(fb.java:189)
at com.ibm.db2.jcc.t4.fb.b(fb.java:83)
at com.ibm.db2.jcc.t4.t.b(t.java:69)
at com.ibm.db2.jcc.t4.vb.c(vb.java:242)
at com.ibm.db2.jcc.am.um.kc(um.java:2884)
at com.ibm.db2.jcc.am.um.nc(um.java:2990)
... 64 more
Caused by: com.ibm.db2.jcc.am.SqlException: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-206", SQLSTATE "42703" and message tokens "RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.58.82
at com.ibm.db2.jcc.am.ed.a(ed.java:679)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.tm.c(tm.java:2523)
at com.ibm.db2.jcc.am.tm.a(tm.java:2018)
at com.ibm.db2.jcc.t4.fb.n(fb.java:802)
at com.ibm.db2.jcc.t4.fb.i(fb.java:259)
at com.ibm.db2.jcc.t4.fb.c(fb.java:54)
at com.ibm.db2.jcc.t4.t.c(t.java:44)
at com.ibm.db2.jcc.t4.ub.j(ub.java:147)
at com.ibm.db2.jcc.am.tm.hb(tm.java:2013)
at com.ibm.db2.jcc.am.um.b(um.java:3819)
... 63 more
4 answers
DB2 9.7 has added more security settings. At a first glance, this looks like permission problems on the DB.
From the control center, right click on the RAM DB, and select Authorities. On the dialog that comes up, make sure to set/add the uid RAM is using to access the DB, and enable the DBADM authority ... the migration will require (in some cases) to change RAM tables and what not.
From the control center, right click on the RAM DB, and select Authorities. On the dialog that comes up, make sure to set/add the uid RAM is using to access the DB, and enable the DBADM authority ... the migration will require (in some cases) to change RAM tables and what not.
Are you pointing to an existing database from an older RAM, or a brand
new database created from the same 7202 installation files that you used
to install.
This tells me that the database is not valid.
A -206 says that it is looking for the column
RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT. But that column doesn't exist
in your database.
If you had created a valid brand new 7202 installation, including the
database, then that column should exist.
Go to your database and append the results of the following query:
select * from ramschema.configuration where config_key =
'ram.repositoryVersion'
Also verify that your RAMSCHEMA.REPOSITORYROLE table looks like this
structure:
CREATE TABLE "RAMSCHEMA"."REPOSITORYROLE" (
"ID" INTEGER NOT NULL ,
"NAME" VARCHAR(80) NOT NULL ,
"RESOURCEGROUPID" INTEGER NOT NULL ,
"TEST_DATA" VARCHAR(3000) ,
"ROLE_TYPE" INTEGER NOT NULL WITH DEFAULT 0 ,
"DESCRIPTION" VARCHAR(512) ,
"RR_RELATE_KIND" BIGINT NOT NULL WITH DEFAULT 8 ,
"RR_ENTITLEMENT" BIGINT NOT NULL WITH DEFAULT 0 )
Rich
new database created from the same 7202 installation files that you used
to install.
This tells me that the database is not valid.
A -206 says that it is looking for the column
RAMSCHEMA.REPOSITORYROLE.RR_ENTITLEMENT. But that column doesn't exist
in your database.
If you had created a valid brand new 7202 installation, including the
database, then that column should exist.
Go to your database and append the results of the following query:
select * from ramschema.configuration where config_key =
'ram.repositoryVersion'
Also verify that your RAMSCHEMA.REPOSITORYROLE table looks like this
structure:
CREATE TABLE "RAMSCHEMA"."REPOSITORYROLE" (
"ID" INTEGER NOT NULL ,
"NAME" VARCHAR(80) NOT NULL ,
"RESOURCEGROUPID" INTEGER NOT NULL ,
"TEST_DATA" VARCHAR(3000) ,
"ROLE_TYPE" INTEGER NOT NULL WITH DEFAULT 0 ,
"DESCRIPTION" VARCHAR(512) ,
"RR_RELATE_KIND" BIGINT NOT NULL WITH DEFAULT 8 ,
"RR_ENTITLEMENT" BIGINT NOT NULL WITH DEFAULT 0 )
Rich
I had dropped my old database on DB2 9.7.1 and recreated a new database using the Database scripts included in RAM 7202 install files.
When I issue the command,
select * from ramschema.configuration where config_key = 'ram.repositoryVersion'
I see the following
ram.repositoryVersion 7.2.0.2.v20100201
However the RR_ENTITLEMENT column does not exist in the RAMSCHEMA.REPOSITORYROLE table.
Am not sure how this happened. The database creation script has the column in it. Will recreate the database and give it another go. Thanks!
When I issue the command,
select * from ramschema.configuration where config_key = 'ram.repositoryVersion'
I see the following
ram.repositoryVersion 7.2.0.2.v20100201
However the RR_ENTITLEMENT column does not exist in the RAMSCHEMA.REPOSITORYROLE table.
Am not sure how this happened. The database creation script has the column in it. Will recreate the database and give it another go. Thanks!