topic Re: [SOLVED] Failed deploying alfresco from war in Alfresco Archive

[SOLVED] Failed deploying alfresco from war

bluearth — Mon, 09 Nov 2009 13:14:18 GMT

Hi,Since alfresco installation package for linux requires GUI which not suitable for my current situation, I decided to try and deploy alf from the war package (alfresco-community-war-3.2r.zip). My web container is tomcat 6. So I followed the instruction at "Installing and Configuring Alfresco ECM C

Re: [SOLVED] Failed deploying alfresco from war

mrogers — Mon, 09 Nov 2009 14:30:08 GMT

Yes you have missed setting the class loader for tomcat 6.

http://wiki.alfresco.com/wiki/Install_Tomcat6

Re: [SOLVED] Failed deploying alfresco from war

bluearth — Mon, 09 Nov 2009 16:05:00 GMT

Yes you have missed setting the class loader for tomcat 6.

http://wiki.alfresco.com/wiki/Install_Tomcat6

Thanks for the reply. I dId that but simply forgot to mention it in my original post.

Re: [SOLVED] Failed deploying alfresco from war

mrogers — Mon, 09 Nov 2009 18:12:50 GMT

alfresco-global.properties goes in shared/classes rather than shared/classes/alfresco.

Re: [SOLVED] Failed deploying alfresco from war

bluearth — Tue, 10 Nov 2009 01:54:14 GMT

alfresco-global.properties goes in shared/classes rather than shared/classes/alfresco.

Okay I moved alfresco-global.properties to that location, something seems to happen. The bootstrap process did find my alfresco-global.properties (as shown in the server output), but then it throws a bunch of spring exceptions.

…
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
Nov 10, 2009 2:36:11 AM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
02:36:18,718  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
02:36:18,719  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
02:36:18,720  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/home/barkah.yusuf/apache-tomcat-6.0.20/shared/classes/alfresco-global.properties]
02:36:18,882  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
02:36:27,535  ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'indexerComponent' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean '&indexerAndSearcherFactory' while setting bean property 'storeRedirectorProxyFactory'; nested exception is  […the nested exceptions is quite long, but the line ends with…] Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.sqlmap.client.SqlMapException: The <sqlMap> resource is missing: alfresco/ibatis/#resource.dialect#/locks-insert-SqlMap.xml
…
‍‍‍‍‍‍‍‍‍‍‍‍

I reckon that I'm missing ibatis dialect definition for MSSQL server.
Any other idea?

Thanks

Re: [SOLVED] Failed deploying alfresco from war

dward — Tue, 10 Nov 2009 08:45:13 GMT

Did you say you were using SQL Server? SQL server (and other enterprise databases) are only supported in the enterprise edition. Try an enterprise trial.

Re: [SOLVED] Failed deploying alfresco from war

bluearth — Tue, 10 Nov 2009 10:52:33 GMT

Did you say you were using SQL Server? SQL server (and other enterprise databases) are only supported in the enterprise edition. Try an enterprise trial.

Yes I did.
And after two days straight strugling to figure out what went wrong I can finally rest easy now

Thanks for the clarification.

EDIT: Could you point me to official page/document that saying which RDBMSs Alfresco Community supports?