cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco Installation problem with Oracle database

arnab_thokder
Champ in-the-making
Champ in-the-making
I seek to install version 2.0 of alfresco.
I ran the AlfrescoCommunity-2.0-Setup and selected Oracle database as I have the Oracle App Server and also I need to use Alfresco with Oracle only.
I ran the alf_start.bat and got the following error in cmd…




CompilerOracle: exclude org/apache/lucene/index/IndexReader$1 doBody
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Mer
ger mergeIndexes
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Mer
ger mergeDeletions
May 28, 2007 1:56:58 PM org.apache.catalina.core.AprLifecycleListener lifecycleE
vent
INFO: The Apache Tomcat Native library which allows optimal performance in produ
ction environments was not found on the java.library.path: C:\Alfresco\java\bin;
.;C:\WINDOWS\system32;C:\WINDOWS;C:\Alfresco\java\bin;C:\Alfresco\bin;D:\product
\10.1.3.1\OracleAS_1\jdk\bin;D:\product\10.1.3.1\OracleAS_1\ant\bin;D:\OraHome_1
\bin;D:\OraHome_1\jlib;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C
:\Program Files\Common Files\Adobe\AGL;C:\Program Files\Subversion\bin;C:\Alfres
co\java\bin;C:\Alfresco\tomcat\bin;C:\Alfresco\bin;D:\product\10.1.3.1\OracleAS_
1\sdk\bin;
May 28, 2007 1:56:59 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
May 28, 2007 1:56:59 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1594 ms
May 28, 2007 1:56:59 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
May 28, 2007 1:56:59 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.20
May 28, 2007 1:56:59 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
May 28, 2007 1:57:00 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
FATAL - Unable to parse web.xml
java.lang.IllegalArgumentException: jaxp-null-input-source: The source specified
cannot be null.
        at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
        at org.apache.myfaces.webapp.webxml.WebXmlParser.parse(WebXmlParser.java
:89)
        at org.apache.myfaces.webapp.webxml.WebXml.init(WebXml.java:135)
        at org.apache.myfaces.webapp.StartupServletContextListener.initFaces(Sta
rtupServletContextListener.java:66)
        at org.apache.myfaces.webapp.StartupServletContextListener.contextInitia
lized(StartupServletContextListener.java:46)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3763)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
211)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:73
9)
        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(Lifecycl
eSupport.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:4
50)
        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(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
javax.faces.FacesException: java.lang.IllegalArgumentException: jaxp-null-input-
source: The source specified cannot be null.
        at org.apache.myfaces.webapp.webxml.WebXmlParser.parse(WebXmlParser.java
:105)
        at org.apache.myfaces.webapp.webxml.WebXml.init(WebXml.java:135)
        at org.apache.myfaces.webapp.StartupServletContextListener.initFaces(Sta
rtupServletContextListener.java:66)
        at org.apache.myfaces.webapp.StartupServletContextListener.contextInitia
lized(StartupServletContextListener.java:46)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3763)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
211)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:73
9)
        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(Lifecycl
eSupport.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:4
50)
        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(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: java.lang.IllegalArgumentException: jaxp-null-input-source: The sourc
e specified cannot be null.
        at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
        at org.apache.myfaces.webapp.webxml.WebXmlParser.parse(WebXmlParser.java
:89)
        … 27 more
May 28, 2007 1:57:03 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
May 28, 2007 1:57:03 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
May 28, 2007 1:57:03 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/32  config=null
May 28, 2007 1:57:03 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
May 28, 2007 1:57:03 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 4312 ms





I tried to access http://localhost:8080/alfresco but got the error "The requested resource (/alfresco/) is not available."
I do not know what is the solution here. Can anybody please help and tell me the exact processes to install alfresco with Oracle?

regards,
Arnab
5 REPLIES 5

makoildha
Champ in-the-making
Champ in-the-making
Hi mate,

looks like you may have a jar conflict with OAS and Alfresco.

arnab_thokder
Champ in-the-making
Champ in-the-making
I am following the instructions given in the link http://wiki.alfresco.com/wiki/Installing_on_Oracle_Application_Server_10.1.3.1 while trying to install Alfresco 2.0 with Oracle App Server (as_windows_x86_oim_oif_101401   as well as   soa_windows_x86_101310). I am getting the following error in app server control…

[Jun 1, 2007 12:15:03 PM] Application Deployer for Alfresco STARTS.
[Jun 1, 2007 12:15:03 PM] Copy the archive to D:\product\10.1.3.1\OracleAS_3\j2ee\home\applications\Alfresco.ear
[Jun 1, 2007 12:15:20 PM] Initialize D:\product\10.1.3.1\OracleAS_3\j2ee\home\applications\Alfresco.ear begins…
[Jun 1, 2007 12:15:20 PM] Unpacking Alfresco.ear
[Jun 1, 2007 12:15:36 PM] Done unpacking Alfresco.ear
[Jun 1, 2007 12:15:36 PM] Unpacking alfresco.war
[Jun 1, 2007 12:15:46 PM] Done unpacking alfresco.war
[Jun 1, 2007 12:15:46 PM] Initialize D:\product\10.1.3.1\OracleAS_3\j2ee\home\applications\Alfresco.ear ends…
[Jun 1, 2007 12:15:46 PM] Starting application : Alfresco
[Jun 1, 2007 12:15:46 PM] Initializing ClassLoader(s)
[Jun 1, 2007 12:15:46 PM] Initializing EJB container
[Jun 1, 2007 12:15:46 PM] Loading connector(s)
[Jun 1, 2007 12:15:46 PM] Starting up resource adapters
[Jun 1, 2007 12:15:46 PM] Initializing EJB sessions
[Jun 1, 2007 12:15:46 PM] Committing ClassLoader(s)
[Jun 1, 2007 12:15:46 PM] Initialize alfresco begins…
[Jun 1, 2007 12:15:46 PM] Initialize alfresco ends…
[Jun 1, 2007 12:15:46 PM] Started application : Alfresco
[Jun 1, 2007 12:15:46 PM] Binding web application(s) to site default-web-site begins…
[Jun 1, 2007 12:15:46 PM] Binding alfresco web-module for application Alfresco to site default-web-site under context root alfresco
[Jun 1, 2007 12:16:08 PM] Operation failed with error: Error creating bean with name 'schemaBootstrap' defined in class path resource [alfresco/bootstrap-context.xml]: Can't resolve reference to bean '&sessionFactory' while setting property 'localSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Initialization of bean failed; nested exception is org.hibernate.HibernateException: Errors in named queries: GraphSession.findAllProcessDefinitionVersions, node.GetNodesWithPropertyValuesByActualType, MessagingSession.resumeMessagesForToken, audit.GetLatestAuditDate, GraphSession.selectLogsForTokens, txn.GetLastTxnIdForStore, GraphSession.findTokensForProcessInstance, MessagingSession.findMessages, MessagingSession.suspendMessagesForToken, node.GetChildAssocRefs, SchedulerSession.resumeTimersForToken, GraphSession.findAllProcessInstancesForADefinition, audit.GetAuditSourceByApplication, node.GetTargetAssocs, GraphSession.findTaskInstanceIdsForProcessInstance, store.GetAllStores, node.GetNodeAssoc, TaskMgmtSession.findPooledTaskInstancesByActorIds, GraphSession.findLatestProcessDefinitionQuery, txn.GetTxnChanges, txn.GetLastTxnId, node.GetChildAssocByTypeAndName, server.getServerByIpAddress, txn.GetNextTxns, SchedulerSession.findTimersByDueDate, GraphSession.deleteMessagesForToken, txn.GetNextRemoteTxns, patch.GetAppliedPatchesByDate, patch.GetAllAppliedPatches, txn.GetTxnChangesForStore, SchedulerSession.findTimersByName, node.GetSourceAssocs, permission.GetAccessControlEntriesForAuthority, GraphSession.deleteTaskInstancesById, audit.GetAuditTrailForNode, permission.patch.GetAccessControlEntriesToChangePermissionOn, permission.GetPermission, TaskMgmtSession.findTaskInstancesByIds, SchedulerSession.findSuspendedTimers, LoggingSession.findLogsByToken, node.GetNodeAssocsToAndFrom, TaskMgmtSession.findTaskInstancesByActorId, TaskMgmtSession.findPooledTaskInstancesByActorId, audit.GetLatestAuditConfig, SchedulerSession.suspendTimersForToken, TaskMgmtSession.findTaskInstancesByTokenId, node.GetChildAssocs, txn.CountTransactions, GraphSession.findProcessDefinitionByNameAndVersion, node.patch.GetNodesWithPersistedSerializableProperties, node.updateChildAssocName, MessagingSession.findErrorMessages, SchedulerSession.deleteTimersForProcessInstance, txn.GetTxnUpdateCountForStore, node.patch.GetAssocsAndChildNames, SchedulerSession.findFailedTimers, audit.GetAuditSourceByApplicationServiceMethod, TaskMgmtSession.findTaskInstancesByActorIds, txn.GetTxnDeleteCountForStore, GraphSession.findAllProcessDefinitions


I have tried the same thing with Alfresco 1.4 also….got the same error…
Can anybody please help me with the installation in Oracle App Server…

andy
Champ on-the-rise
Champ on-the-rise
Hi

Did you set the jars and class path at deployment time? See 1.4.x stage 4.
This was required to resolve an issue parsing XML files.

Andy

seraphon
Champ in-the-making
Champ in-the-making
Hi
I have the same problem which is
"The requested resource (/alfresco/) is not available."

I did set a jar( the ojdbc14.jar one ) in tomcat/common/lib and I changed the samples (though the instructions in the wiki are a bit unclear about where we have to insert these changes). But still the problem persist.

But I do think that the problem may come from custom-repository-context.xml:
where I put the modifications about like this:
<beans>
      db.driver=oracle.jdbc.OracleDriver
db.name=alfresco
db.url=jdbcSmiley Surprisedracle:thin:@<baotq>:1521:<database sid>
db.username=alfresco
db.password=alfresco
  
    <!– overriding to point to custom properties –>
    <bean id="repository-properties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="ignoreUnresolvablePlaceholders">

….etc….

I changed nothing in this file except adding the db. instruction right after <beans>
Was I wrong?


here are the error I fing in the .log
org.springframework.beans.factory.BeanDefinitionStoreException: Line 40 in XML document from file [C:\Alfresco\tomcat\shared\classes\alfresco\extension\custom-repository-context.xml] is invalid; nested exception is org.xml.sax.SAXParseException: Content is not allowed in trailing section.

and what is the database sid?


Can anyone anwer ;y questions?

Regards seraphon

Edit:
After some more manipulation I also understood that I am a newbie in xml.
I also found in the log
17:44:45,765 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanDefinitionStoreException: Line 33 in XML document from file [C:\Alfresco\tomcat\shared\classes\alfresco\extension\custom-repository-context.xml] is invalid; nested exception is org.xml.sax.SAXParseException: Element type "machinename" must be declared.
org.xml.sax.SAXParseException: Element type "machinename" must be declared.

Does anyone know the solution to my problem?
If you need more details, just ask.

regards seraphon

seraphon
Champ in-the-making
Champ in-the-making
Hi I got it working
My problem was that the instruction
db.driver=oracle.jdbc.OracleDriver
db.name=alfresco
db.url=jdbcSmiley Surprisedracle:thin:@<baotq>:1521:<database sid>
db.username=alfresco
db.password=alfresco

were to be put in custom-repository-context.properties.

regards
seraphon