0 Replies Latest reply on Jun 28, 2006 9:43 AM by john john

    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 !! :(