AnsweredAssumed Answered

Deploying Alfresco in Oracle App Server with Oracle database

Question asked by arnab_thokder on Jun 1, 2007
Latest reply on Jun 12, 2007 by andy
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 deploy Alfresco 2.0 (war) 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…

Outcomes