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 !! :( View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3954023#3954023 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3954023 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user