AnsweredAssumed Answered

Alfresco 2.1.0R1 with BEA Weblogic Server 10

Question asked by jmorata on Jul 26, 2007
Latest reply on Dec 18, 2007 by steve
Hi,

I follow all instructions found in this forum and the wiki:

1. Create a new domain 'alfresco'
2. Copy mysql-connector-java-5.0.3-bin.jar to {DOMAIN_HOME}/lib
3. Deploy WAR file
4. Extract ${DOMAIN_HOME}/servers/AdminServer/tmp/_WL_user/alfresco/hp7x2s/war/WEB-INF/lib/_wl_cls_gen.jar to ${DOMAIN_HOME}/servers/AdminServer/tmp/_WL_user/alfresco/hp7x2s/war/WEB-INF/classes
5. Delete _wl_cls_gen.jar
6. ${DOMAIN_HOME}/servers/AdminServer/tmp/_WL_user/alfresco/hp7x2s/war/WEB-INF/classes/repository.properties: Set dir.root to an absolute path (C:/Alfresco/alf_data)


Installed alfresco.war ok, but when I going to run app, it fails with the followed error:

####<26-jul-2007 14H08' CEST> <Warning> <Deployer> <w2k3se-1> <examplesServer> <[STANDBY] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1185451685344> <BEA-149078> <Stack trace for message 149004
weblogic.application.ModuleException:
   at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:950)

…..

org.hibernate.HibernateException: Errors in named queries: HistoryLink.ByAncestor, VersionRoot.GetVersionRoot, GraphSession.deleteJobsForProcessInstance, GraphSession.findAllProcessDefinitionVersions, GraphSession.findAllRunningProcessInstances, AVMNode.GetNewInStore, node.GetNodesWithPropertyValuesByActualType, GraphSession.findAllProcessInstances, audit.GetLatestAuditDate, GraphSession.selectLogsForTokens, txn.GetLastTxnIdForStore, GraphSession.findTokensForProcessInstance, MergeLink.ByFrom, node.GetChildAssocRefsByQName, node.GetChildAssocRefs, node.GetPrimaryChildNodeStatuses, FindOrphans, JobSession.getFirstAcquirableJob, GraphSession.findAllProcessInstancesForADefinition, GraphSession.findSubProcessInstances, PlainFileNode.GetContentUrls, audit.GetAuditSourceByApplication, node.GetTargetAssocs, GraphSession.findTaskInstanceIdsForProcessInstance, node.GetParentAssocs, store.GetAllStores, node.GetNodeAssoc, txn.GetLastRemoteTxnId, JobSession.resumeJobs, VersionRoot.VersionByID, node.GetChildAssocIdByShortName, GraphSession.findAllRunningProcessInstancesWithProcessName, GraphSession.findActiveNodesByProcessInstance, TaskMgmtSession.findPooledTaskInstancesByActorIds, GraphSession.findLatestProcessDefinitionQuery, txn.GetTxnChanges, txn.GetLastTxnId, TaskMgmtSession.findTaskInstancesByProcessInstance, node.GetChildAssocByTypeAndName, server.getServerByIpAddress, JobSession.deleteExecuteNodeJobsForProcessInstance, TaskMgmtSession.findTaskForNode, txn.GetNextTxns, txn.GetNextRemoteTxns, JobSession.suspendJobs, patch.GetAppliedPatchesByDate, patch.GetAllAppliedPatches, txn.GetTxnChangesForStore, permission.FindNodesByPermission, AVMNode.GetMergedTo, node.GetSourceAssocs, permission.GetAccessControlEntriesForAuthority, GraphSession.deleteTaskInstancesById, audit.GetAuditTrailForNode, node.GetChildAssocsByAll, permission.GetPermission, permission.patch.GetAccessControlEntriesToChangePermissionOn, TaskMgmtSession.findTaskInstancesByIds, JobSession.deleteTimersForProcessInstance, JobSession.getFirstDueJob, LoggingSession.findLogsByToken, GraphSession.findAllSwimlaneNames, node.GetNodeAssocsToAndFrom, TaskMgmtSession.findTaskInstancesByActorId, GraphSession.findProcessInstanceByKey, AVMNode.GetDescendents, GraphSession.findAllProcessInstancesWithProcessName, TaskMgmtSession.findPooledTaskInstancesByActorId, GraphSession.calculateAverageTimeByNode, audit.GetLatestAuditConfig, JobSession.getTimersByName, TaskMgmtSession.findTaskInstancesByTokenId, node.GetChildAssocs, txn.CountTransactions, GraphSession.findProcessDefinitionByNameAndVersion, TaskMgmtSession.findOpenTasksOfProcessInstance, node.patch.GetNodesWithPersistedSerializableProperties, JobSession.findExclusiveJobs, node.updateChildAssocName, txn.GetTxnUpdateCountForStore, node.patch.GetAssocsAndChildNames, GraphSession.findAllTokensOfProcessInstance, JobSession.getFirstDueJobExlcMonitoredJobs, ChildEntry.DeleteByParent, permission.GetAllAccessControlEntriesForAuthority, audit.GetAuditSourceByApplicationServiceMethod, TaskMgmtSession.findTaskInstancesByActorIds, GraphSession.findAllProcessDefinitions, txn.GetTxnDeleteCountForStore
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:364)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1291)

….

Any clues about it ?

I don't know where put the 'extension' folder, I think it must be into \tmp\_WL_user\alfresco\kid63e\war\WEB-INF\classes\alfresco.
For testing porpuses I change 'repository.properties' with db.url property as:

# Database configuration
db.schema.update=true
db.driver=org.gjt.mm.mysql.Driver
db.name=alfresco
db.url=jdbc:mysql://ES-BYSM92J.es.int.atosorigin.com/alfresco
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20

and hibernate-dialect.properties file:

hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

Anyone can help me ?

Outcomes