Alfresco 2.1 on Oracle 10g Express

[liao1108]

:cry:
I am going to install Alfresco 2.1 with Tomcat bundled to connect to Oracle 10g Express, there is error message :

14:30:25,656 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:716)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:448)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: java.sql.SQLException: ORA-00942: 表格或視觀表不存在 (In English: Table or view not exist)

   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
   at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
   at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:902)
   at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1122)
   at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:953)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1242)
   at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1423)
   at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:262)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:345)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:669)
   … 34 more

I am sure Alfresco 2.0 with Oracle works fine. I remove all 2.0 stuffs and re-install 2.1, no matter SQL Server or Oracle, it seems get the same error.

Does anybody know how to get things going on. We try to pay someone experienced on Alfresco, but get no response at all. I am confusing for the choice more and more. Anyhow, thanks for any help.

[davidc]

I'm able to install 2.1 against Oracle 10g Express edition.

Are you installing from fresh or upgrading?

Which OS is your Oracle on?

Which table does not exist?

There's a known issue upgrading from 1.4/2.0 to 2.1RC on Oracle which has been fixed on HEAD.

[liao1108]

Hi David,

Thanks for so prompt reply.

I am doing 2.1 fresh installation with two type, one with tomcat bundled and change database to Oracle and modify repository.property and hibernate dialect, and two is deloy via war file in the tomcat 5.5.23 that Alfresco 2.0 works fine. These two installations are getting the same error.

I add and modify extension files to re-direct database connection to Oracle, Alfresco 2.1 knows i am goin to use Oracle jdbc driver, just can not update schema.

I am working on Windows XP, when i looks on alfresco schema on Oracle , anything has been created.

What's wrong with it. Or can you provide a fresh installation against Oracle XE with pay based, thanks.

[davidc]

Are you installing against an Oracle schema that has already had Alfresco installed against it?  If so, you're performing an upgrade and that will fail due to a bug (that's now been fixed in HEAD).

Please try and install against a fresh Oracle database schema and alf_data directory.

[liao1108]

Hi David,

I have rename schema name that stores Alfresco 2.0 stuffs, and create a fresh new schema name alfresco to wait for 2.1 RC, is it not ok ? There is also another schemas for another application, i am sure it works ok to company with Alfresco 2.0.

Do you mean i have to keep a pure empty database only one schema 'alfresco' alowed to exist ?

Thanks.

Leo

[liao1108]

Hi David,

I drop schema that alfresco 2.0 left, and create a new one, it works.

Thanks.

Leo