2 Replies Latest reply on Jun 28, 2006 1:09 PM by Sergio Silva

    deployment problem in 2.2.1sp1 on 4.03sp1

    john john Newbie

      Folks,

      When I installed portal 2.2.1sp1 on jboss 4.0.3sp1 AS seeing lot of errros
      Portal is not able to comeup at all.

      I have checked for proper ds xml config & driver for oracle 9. I can see the tables created.. This is weird for me..

      Iam deploying on "all" instance of jboss & not configured anything else

      Your great help is appreciated !!

      In console, table not found errors are coming & cache timeout failure etc.

      The portion of errors are

      18:27:02,205 INFO [NamingHelper] JNDI InitialContext properties:{}
      18:27:02,215 INFO [SessionFactoryImpl] Checking 0 named queries
      18:27:02,215 INFO [HibernateStore] HibernateSessionFactory Created.
      18:27:04,819 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      18:27:04,829 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist

      18:27:04,829 ERROR [HibernateStore] failed to check existence of file system entry: /meta
      org.hibernate.exception.SQLGrammarException: could not execute query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.loader.Loader.doList(Loader.java:2150)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
      at org.hibernate.loader.Loader.list(Loader.java:2021)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1020)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
      at org.jboss.portal.cms.hibernate.HibernateStore.exists(HibernateStore.java:554)
      at org.apache.jackrabbit.core.RepositoryImpl.(RepositoryImpl.java:172)
      at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:424)
      at org.jboss.portal.cms.impl.jcr.jackrabbit.JackrabbitJCRService.start(JackrabbitJCRService.java:102)
      at org.jboss.portal.cms.impl.jcr.JCRCMS.startJCR(JCRCMS.java:233)
      at org.jboss.portal.cms.impl.jcr.JCRCMS.startService(JCRCMS.java:199)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181)
      at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:86)




      at org.jboss.Main$1.run(Main.java:438)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877)
      at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:137)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1676)
      at org.hibernate.loader.Loader.doQuery(Loader.java:662)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
      at org.hibernate.loader.Loader.doList(Loader.java:2147)
      ... 126 more
      18:27:05,910 WARN [ServiceController] Problem starting service portal:service=CMS
      javax.jcr.RepositoryException: failed to create folder for repository meta data: failed to check existence of file system entry: /meta: could not execute query: failed to check existence of file system entry: /meta: could not execute query
      at org.apache.jackrabbit.core.RepositoryImpl.(RepositoryImpl.java:178)
      at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:424)
      at org.jboss.portal.cms.impl.jcr.jackrabbit.JackrabbitJCRService.start(JackrabbitJCRService.java:102)
      at org.jboss.portal.cms.impl.jcr.JCRCMS.startJCR(JCRCMS.java:233)


      at org.hibernate.loader.Loader.doList(Loader.java:2147)
      ... 126 more
      org.apache.jackrabbit.core.fs.FileSystemException: failed to check existence of file system entry: /meta: could not execute query
      at org.jboss.portal.cms.hibernate.HibernateStore.exists(HibernateStore.java:573)
      at org.apache.jackrabbit.core.RepositoryImpl.(RepositoryImpl.java:172)
      at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:424)
      at org.jboss.portal.cms.impl.jcr.jackrabbit.JackrabbitJCRService.start(JackrabbitJCRService.java:102)
      at org.jboss.portal.cms.impl.jcr.JCRCMS.startJCR(JCRCMS.java:233)
      at org.jboss.portal.cms.impl.jcr.JCRCMS.startService(JCRCMS.java:199)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181)
      at org.jboss.portal.common.system.AbstractJBossService.start(AbstractJBossService.java:86)


      18:27:42,001 WARN [EhCacheProvider] Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
      18:27:42,001 INFO [SessionFactoryImpl] Checking 0 named queries
      18:27:43,373 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      18:27:43,373 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist

      18:27:44,745 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      18:27:44,745 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist

      18:27:46,107 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      18:27:46,107 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist

      18:27:47,469 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      18:27:47,469 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist

      18:27:48,831 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      18:27:48,841 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist

      18:27:48,841 INFO [Dialect] Using dialect: org.hibernate.dialect.OracleDialect
      18:27:48,851 INFO [Configuration] processing extends queue



      18:33:56,542 WARN [TreeCache] status is 1 (not ACTIVE or PREPARING); returning null)
      18:33:56,542 ERROR [CacheLoaderInterceptor] failed loading node /instance/CatalogPortletInstance from CacheLoader
      java.lang.NullPointerException
      at org.jboss.portal.core.security.store.HibernateCacheLoader$Blah.close(HibernateCacheLoader.java:161)
      at org.jboss.portal.core.security.store.HibernateCacheLoader.loadNode(HibernateCacheLoader.java:674)
      at org.jboss.portal.core.security.store.HibernateCacheLoader.exists(HibernateCacheLoader.java:210)
      at org.jboss.cache.interceptors.CacheLoaderInterceptor.getNode(CacheLoaderInterceptor.java:196)
      at org.jboss.cache.interceptors.CacheLoaderInterceptor.invoke(CacheLoaderInterceptor.java:81)
      at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:41)
      at org.jboss.cache.interceptors.UnlockInterceptor.invoke(UnlockInterceptor.java:35)
      at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:41)


      18:33:57,434 WARN [ReadWriteCache] An item was expired by the cache while it was locked (increase your cache timeout): org.jboss.portal.core.impl.model.portal.ObjectNode.children#2
      18:33:57,464 WARN [ReadWriteCache] An item was expired by the cache while it was locked (increase your cache timeout): org.jboss.portal.core.impl.model.portal.PortalObjectImpl.declaredProperties#2
      18:33:57,464 WARN [ReadWriteCache] An item was expired by the cache while it was locked (increase your cache timeout): org.jboss.portal.core.impl.model.portal.PortalImpl.modes#2
      18:33:57,474 WARN [ReadWriteCache] An item was expired by the cache while it was locked (increase your cache timeout): org.jboss.portal.core.impl.model.portal.PortalImpl.windowStates#2
      18:33:57,474 WARN [ReadWriteCache] An item was expired by the cache while it was locked (increase your cache timeout): org.jboss.portal.core.impl.model.portal.ObjectNode#2



      WARN [ReadWriteCache] An item was expired by the cache while it was locked (increase your cache timeout): org.jboss.portal.core.impl.model.portal.ObjectNode.children#3
      18:33:58,065 INFO [STDOUT] org.jboss.deployment.DeploymentException: - nested throwable: (java.lang.NullPointerException); - nested throwable: (org.jboss.util.NestedRuntimeException: - nested throwable: (java.lang.NullPointerException))
      18:33:58,065 INFO [STDOUT] at org.jboss.portal.core.deployment.jboss.ObjectDeployment.start(ObjectDeployment.java:306)
      18:33:58,065 INFO [STDOUT] at org.jboss.portal.server.deployment.jboss.PortalDeploymentInfo$DeploymentContext.start(PortalDeploymentInfo.java:208)
      18:33:58,065 INFO [STDOUT] at org.jboss.portal.server.deployment.jboss.ServerDeployer.registerFactory(ServerDeployer.java:137)


      Help me !! :(

        • 1. Re: deployment problem in 2.2.1sp1 on 4.03sp1
          Rali Genova Novice

          first error: deploy in the default configuration of the server
          second error: the tables initially do not exist (how would they if you have new config) - they are created during first start up. This error has been discussed gazillion times on this forum. If you restart it, you shouldn't see any.

          • 2. Re: deployment problem in 2.2.1sp1 on 4.03sp1
            Sergio Silva Newbie

            Sorry, but I'm having the same error, on the same configuration. I'm running the default instance, and have restarted it and keeps throwing this:

            12:08:39,997 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist

            12:08:39,997 ERROR [HibernateStore] failed to check existence of file system entry: /meta
            org.hibernate.exception.SQLGrammarException: could not execute query

            And also it is not creating the JBP_CMS tables in the database, that's why i think it keeps throwing this excpetion. Any comment or suggestion will be greatly appreciated. Thanks in advance!