deployment problem in 2.2.1sp1 on 4.03sp1

[joneyp]

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

[rali.genova]

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.

[ssilvane]

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!