RAM repository is not the correct version error.
I ran into the following problem after a
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. |
|
In my case, I was connecting to the database as the database instance owner db2inst1 from the RAM setup application. The setup worked fine. I did look at the Authorities tab in Control Center, and db2inst1 is a valid user with DBADM authority.
|
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 |
|
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! |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.