Deploying Alfresco in Oracle App Server with Oracle database

[arnab_thokder]

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…

[lakshmi]

Hi,

Even i followed the steps given in WIKI http://wiki.alfresco.com/wiki/Installing_on_Oracle_Application_Server_10.1.3.1

Did you solve this error. I got this error initially, but when i added the cyptrix.jar and oracle.xml from the shared library while deployment, i ended up with the following exception.



[Jun 11, 2007 4:10:49 PM] Application Deployer for Alfresco STARTS.
[Jun 11, 2007 4:10:49 PM] Copy the archive to D:\product\10.1.3.1\OracleAS_2\j2ee\home\applications\Alfresco.ear
[Jun 11, 2007 4:11:04 PM] Initialize D:\product\10.1.3.1\OracleAS_2\j2ee\home\applications\Alfresco.ear begins…
[Jun 11, 2007 4:11:04 PM] Unpacking Alfresco.ear
[Jun 11, 2007 4:11:20 PM] Done unpacking Alfresco.ear
[Jun 11, 2007 4:11:20 PM] Unpacking alfresco.war
[Jun 11, 2007 4:13:17 PM] Done unpacking alfresco.war
[Jun 11, 2007 4:13:17 PM] Initialize D:\product\10.1.3.1\OracleAS_2\j2ee\home\applications\Alfresco.ear ends…
[Jun 11, 2007 4:13:17 PM] Starting application : Alfresco
[Jun 11, 2007 4:13:17 PM] Initializing ClassLoader(s)
[Jun 11, 2007 4:13:17 PM] Initializing EJB container
[Jun 11, 2007 4:13:17 PM] Loading connector(s)
[Jun 11, 2007 4:13:18 PM] Starting up resource adapters
[Jun 11, 2007 4:13:18 PM] Initializing EJB sessions
[Jun 11, 2007 4:13:18 PM] Committing ClassLoader(s)
[Jun 11, 2007 4:13:18 PM] Initialize alfresco begins…
[Jun 11, 2007 4:13:18 PM] Initialize alfresco ends…
[Jun 11, 2007 4:13:18 PM] Started application : Alfresco
[Jun 11, 2007 4:13:18 PM] Binding web application(s) to site default-web-site begins…
[Jun 11, 2007 4:13:18 PM] Binding alfresco web-module for application Alfresco to site default-web-site under context root alfresco
[Jun 11, 2007 4:13:35 PM] Operation failed with error: Error registering bean with name 'internalEHCacheManager' defined in class path resource [alfresco/cache-context.xml]: Class that bean class [org.alfresco.repo.cache.InternalEhCacheManagerFactoryBean] depends on not found; nested exception is oracle.classloader.util.AnnotatedNoClassDefFoundError: Missing class: net.sf.ehcache.CacheException Dependent class: org.alfresco.repo.cache.InternalEhCacheManagerFactoryBean Loader: Alfresco.web.alfresco:0.0.0 Code-Source: /D:/product/10.1.3.1/OracleAS_2/j2ee/home/applications/Alfresco/alfresco/WEB-INF/lib/repository.jar Configuration: WEB-INF/lib/ directory in D:\product\10.1.3.1\OracleAS_2\j2ee\home\applications\Alfresco\alfresco\WEB-INF\lib The missing class is available from the following locations: 1. Code-Source: /D:/product/10.1.3.1/OracleAS_2/j2ee/home/applications/Alfresco/alfresco/WEB-INF/lib/ehcache-1.2.2.jar (from WEB-INF/lib/ directory in D:\product\10.1.3.1\OracleAS_2\j2ee\home\applications\Alfresco\alfresco\WEB-INF\lib) This code-source is available in loader Alfresco.web.alfresco:0.0.0.

Help out if anybody knows solution to this….If needed i can post the detailed stack trace from log file….

[andy]

Hi

The first error should not occur if you follow the steps on the wiki.

This is an error parsing hiberntae queries. When you deploy the app you must not take all the classes from the container (a check box) and you must select the jars indicated including oracle.xml


4 In the final step the class loading needs to be configured:
   1 Select Configure Class Loading
   2 Deselect Inherit parent application's shared library imports
   3 Import the following libraries
        - Cryptix as previously loaded into the shared library area
        - The JDBC driver
        - oracle.xml

Have you done this?


As far as I know, Alfresco 1.4 is the only release to have been deployed on OAS. There are still isues to resolve for 2.0 and later.

The EhCache jars are in the alfresco.war so it sounds like you have a class loader issue, you are finding the wrong jar or no jar.

Andy