topic Alfresco Installation problem with Oracle database in Alfresco Archive

Alfresco Installation problem with Oracle database

arnab_thokder — Mon, 28 May 2007 09:53:52 GMT

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/Ind

Re: Alfresco Installation problem with Oracle database

makoildha — Tue, 29 May 2007 14:54:24 GMT

Hi mate,

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

Re: Alfresco Installation problem with Oracle database

arnab_thokder — Fri, 01 Jun 2007 09:41:54 GMT

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…

Re: Alfresco Installation problem with Oracle database

andy — Tue, 05 Jun 2007 12:28:24 GMT

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

Re: Alfresco Installation problem with Oracle database

seraphon — Tue, 12 Jun 2007 08:51:51 GMT

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=jdbcracle: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

Re: Alfresco Installation problem with Oracle database

seraphon — Fri, 15 Jun 2007 03:08:42 GMT

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

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

regards
seraphon