nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Oracle Database Issue

lmoulin

I use a Oracle database in a MacX.
When the application is started, the following error is displayed:

11:04:55,266 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Echec de la mise jour automatique du schma
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:613)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:54)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
        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:3729)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4187)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
        at org.apache.catalina.core.StandardService.start(StandardService.java:450)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
        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:294)
        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.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)
Caused by: java.sql.SQLException: ORA-00942: Table ou vue inexistante

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
        at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351)
        at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:893)
        at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:983)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1123)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.countAppliedPatches(SchemaBootstrap.java:218)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:301)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:598)
        … 36 more

Have you any idea?
Thanks a lot
Luc

Find more posts tagged with

Comments

lmoulin

I found the issue !!!!
I have already an alfresco user and schema on the same SID.
But I have created a new user and new schema on this SID.

The first connection is:
db.driver=oracle.jdbc.OracleDriver
db.name=alfresco
db.url=jdbc

racle:thin:@localhost:1521

RA1
db.username=ERD
db.password=ERD

The second connection is:
db.driver=oracle.jdbc.OracleDriver
db.name=alfresco
db.url=jdbc

racle:thin:@localhost:1521

RA1
db.username=GDF
db.password=GDF

I use the same SID: ORA1.

How can I use 2 Alfresco applications on the same SID ORACLE?

Thanks a lot

lmoulin

Have you an idea?
Thanks a lot

steve

Hi,

Could it be that both your connections use the same db.name

db.name=alfresco

I would have thought that since you are trying to use two seperate instances that this should be different.

Hope this helps,

Steve

lmoulin

Thanks,
I try with the following connection parameters:

db.driver=oracle.jdbc.OracleDriver
db.name=alfrescogdf
db.url=jdbcracle:thin:@localhost:1521RA1
db.username=GDF
db.password=GDF

The same error is displayed. Why?
Thanks
Luc

lmoulin

Have you any idea?

steve

Hi,

It could be a symptom of this bug:
http://issues.alfresco.com/browse/AR-1307

Steve

lmoulin

If I replace my oracle database by a MySQL database, can I use several Alfresco webclients on the same server?

derek

Hi,

I've not tried several Alfresco servers sharing the same Oracle database server. We'll look into the bug - it'll be fixable, no doubt.

I have run several Alfresco instances using the same MySQL server instance (different DB names, ofcourse). Is this what you wanted to know?

Regards

lmoulin

Hello,
You say this oracle bug will be fixed:

We'll look into the bug - it'll be fixable, no doubt.

Have you the date of correction of this bug?

Thanks a lot,
Luc