Alfresco 2.1.0R1 with BEA Weblogic Server 10

[jmorata]

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 ?

[jmorata]

Ok,
I fix the last error, but I can't find any solution for this:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeServiceImpl' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'dictionaryService' while setting bean property 'dictionaryService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is java.util.MissingResourceException: Can't find bundle for base name alfresco.messages.avm-messages, locale es_ES


What is the problem now ?
I need help, please !!

[steve]

Hi jmorata,

Could you please post details of how you resolved you first error?

the new error you are getting is because your locale on the machine you are installing Alfresco to seems to be Spanish (es_ES) and one of the Alfresco message bundles can not be found for your locale (avm-messages.properties).

This could be that there has/had not been any translations contributed for this massage bundle at the time you downloaded Alfresco.
You should be able to copy the '\alfresco\WEB-INF\classes\alfresco\messages\avm-messages.properties' file to avm-messages_es_ES.properties to resolve this issue.

Steve

[hodsons]

Hi jmorata,

Did you ever get this issue fixed?  I am just beginning an Alfresco install on WL10 and am getting a similar exception:

Basically, it looks like a hibernate exception, but it originates in a file that you don't have the option to overwrite with the custome extensions.

I first thought is was an issue with a missing library, but it's looking for the "LocalSessionFactoryBean" which is found in spring-2.0.2.jar.

(from hibernate-context.xml)
<!– Hibernate session factory –>
    <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" parent="sessionFactoryBase">
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
    </bean>

Can anybody help?  Thanks.

Error from log below:
…
Error creating bean with name 'nodeDaoServiceImpl' defined in class path resource [alfresco/hibernate-context.xml]:
Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory';
nested exception is org.springframework.beans.factory.BeanCreationException:

Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]:
Invocation of init method failed; nested exception is 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,
…

[hodsons]

From the alfresco.log:

Error in named query: HistoryLink.ByAncestor
org.hibernate.QueryException: ClassNotFoundException: org.hibernate.hql.ast.HqlToken [
    
        from org.alfresco.repo.avm.HistoryLinkImpl hl
        where hl.ancestor = :node
    
    ]
   at org.hibernate.hql.ast.HqlLexer.panic(HqlLexer.java:57)
   at antlr.CharScanner.setTokenObjectClass(CharScanner.java:340)
   at org.hibernate.hql.ast.HqlLexer.setTokenObjectClass(HqlLexer.java:31)
   at antlr.CharScanner.<init>(CharScanner.java:51)
   at antlr.CharScanner.<init>(CharScanner.java:60)
   at org.hibernate.hql.antlr.HqlBaseLexer.<init>(HqlBaseLexer.java:56)‍‍‍‍‍‍‍‍‍‍‍‍‍

So, it can't find the org.hibernate.hql.ast.HqlToken which is in the same jar as the org.hibernate.hql.ast.HqlLexer.

To fix this, I added the antlr-2.7.5H3.jar to the web container's (WebLogic10) CLASSPATH.

[turkuax]

Hi how did u fix the first error? I got the same error again and again…

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 ?

[steve]

Hi,

I have Weblogic 10 working and have added instructions to the Wiki:
http://wiki.alfresco.com/wiki/Install_Weblogic_10_WAR

Steve