0 Replies Latest reply on Jul 12, 2010 8:21 AM by sangramakrishnan

    Regarding Gatein with Oracle - config data load into JCR_CONFIG

    sangramakrishnan
    sangramakrishnan Jul 12, 2010 8:21 AM

      Hi,

      I am trying to setup Gatein portal with Oracle DB

      I made the changes to the config files as mentioned in the Ref Guide and then when I try to start the JBoss server, the tables are created in the newly created schema(jdbcjcr_portal) in Oracle. But when its trying to load some config data, an error is being thrown as below

       

      From Log file:

       

      17:00:53,694 ERROR [RootContainer] Cannot create the portal container 'portal' . ServletContext: org.apache.catalina.core.ApplicationContextFacade@64f299

      org.picocontainer.PicoIntrospectionException

       

      : Failed when calling start on org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@23e66d

      at org.picocontainer.defaults.LifecycleVisitor.traverse(

      LifecycleVisitor.java:81)

      at org.picocontainer.defaults.LifecycleVisitor.start(

      LifecycleVisitor.java:113)

      at org.exoplatform.container.ConcurrentPicoContainer.start(

      ConcurrentPicoContainer.java:453)

      at org.exoplatform.container.ExoContainer.start(

      ExoContainer.java:186)

      at org.exoplatform.container.PortalContainer.start(

      PortalContainer.java:595)

      at org.exoplatform.container.ExoContainer.start(

      ExoContainer.java:180)

      at org.exoplatform.container.RootContainer.createPortalContainer(

      RootContainer.java:338)

      at org.exoplatform.container.RootContainer.createPortalContainers(

      RootContainer.java:233)

      at org.exoplatform.container.web.PortalContainerCreator.contextInitialized(

      PortalContainerCreator.java:57)

      at org.apache.catalina.core.StandardContext.listenerStart(

      StandardContext.java:3910)

      at org.apache.catalina.core.StandardContext.start(

      StandardContext.java:4393)

      at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(

      TomcatDeployment.java:310)

      at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(

      TomcatDeployment.java:142)

      at org.jboss.web.deployers.AbstractWarDeployment.start(

      AbstractWarDeployment.java:461)

      at org.jboss.web.deployers.WebModule.startModule(

      WebModule.java:118)

      at org.jboss.web.deployers.WebModule.start(

      WebModule.java:97)

      at sun.reflect.GeneratedMethodAccessor301.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(

      ReflectedDispatcher.java:157)

      at org.jboss.mx.server.Invocation.dispatch(

      Invocation.java:96)

      at org.jboss.mx.server.Invocation.invoke(

      Invocation.java:88)

      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(

      AbstractMBeanInvoker.java:264)

      at org.jboss.mx.server.MBeanServerImpl.invoke(

      MBeanServerImpl.java:668)

      at org.jboss.system.microcontainer.ServiceProxy.invoke(

      ServiceProxy.java:206)

      at $Proxy38.start(Unknown Source)

      at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(

      StartStopLifecycleAction.java:42)

      at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(

      StartStopLifecycleAction.java:37)

      at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(

      SimpleControllerContextAction.java:62)

      at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(

      AccessControllerContextAction.java:71)

      at org.jboss.dependency.plugins.AbstractControllerContextActions.install(

      AbstractControllerContextActions.java:51)

      at org.jboss.dependency.plugins.AbstractControllerContext.install(

      AbstractControllerContext.java:348)

      at org.jboss.system.microcontainer.ServiceControllerContext.install(

      ServiceControllerContext.java:286)

      at org.jboss.dependency.plugins.AbstractController.install(

      AbstractController.java:1631)

      at org.jboss.dependency.plugins.AbstractController.incrementState(

      AbstractController.java:934)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:1082)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:984)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:822)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:553)

      at org.jboss.system.ServiceController.doChange(

      ServiceController.java:688)

      at org.jboss.system.ServiceController.start(

      ServiceController.java:460)

      at org.jboss.system.deployers.ServiceDeployer.start(

      ServiceDeployer.java:163)

      at org.jboss.system.deployers.ServiceDeployer.deploy(

      ServiceDeployer.java:99)

      at org.jboss.system.deployers.ServiceDeployer.deploy(

      ServiceDeployer.java:46)

      at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(

      AbstractSimpleRealDeployer.java:62)

      at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(

      AbstractRealDeployer.java:50)

      at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(

      DeployerWrapper.java:171)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(

      DeployersImpl.java:1439)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(

      DeployersImpl.java:1157)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(

      DeployersImpl.java:1178)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(

      DeployersImpl.java:1210)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.install(

      DeployersImpl.java:1098)

      at org.jboss.dependency.plugins.AbstractControllerContext.install(

      AbstractControllerContext.java:348)

      at org.jboss.dependency.plugins.AbstractController.install(

      AbstractController.java:1631)

      at org.jboss.dependency.plugins.AbstractController.incrementState(

      AbstractController.java:934)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:1082)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:984)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:822)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:553)

      at org.jboss.deployers.plugins.deployers.DeployersImpl.process(

      DeployersImpl.java:781)

      at org.jboss.deployers.plugins.main.MainDeployerImpl.process(

      MainDeployerImpl.java:702)

      at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(

      MainDeployerAdapter.java:117)

      at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(

      ProfileDeployAction.java:70)

      at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(

      AbstractProfileAction.java:53)

      at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(

      AbstractProfileService.java:361)

      at org.jboss.dependency.plugins.AbstractControllerContext.install(

      AbstractControllerContext.java:348)

      at org.jboss.dependency.plugins.AbstractController.install(

      AbstractController.java:1631)

      at org.jboss.dependency.plugins.AbstractController.incrementState(

      AbstractController.java:934)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:1082)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(

      AbstractController.java:984)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:822)

      at org.jboss.dependency.plugins.AbstractController.change(

      AbstractController.java:553)

      at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(

      AbstractProfileService.java:306)

      at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(

      ProfileServiceBootstrap.java:271)

      at org.jboss.bootstrap.AbstractServerImpl.start(

      AbstractServerImpl.java:461)

      at org.jboss.Main.boot(

      Main.java:221)

      at org.jboss.Main$1.run(

      Main.java:556)

      at java.lang.Thread.run(Unknown Source)

      Caused by:

      java.lang.RuntimeException: org.exoplatform.services.jcr.config.RepositoryConfigurationException: Fail to init from xml! Reason: javax.jcr.RepositoryException: Database exception. java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

      . SQL: INSERT INTO JCR_CONFIG (NAME, CONFIG) VALUES (?,?): Database exception.

      java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested

      . SQL: INSERT INTO JCR_CONFIG (NAME, CONFIG) VALUES (?,?)

      at org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl.start(

      RepositoryServiceConfigurationImpl.java:303)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(

      Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.picocontainer.defaults.LifecycleVisitor.traverse(

      LifecycleVisitor.java:75)

      ... 77 more

       

      Any pointers on where is the config data being loaded from - so that I can take a look at that and then see if I can debug this issue

      Any help in this regard would be good

       

      Thanks

      Sangeetha