topic New issue in Alfresco 3.2 Enterprise ? in Alfresco Archive

New issue in Alfresco 3.2 Enterprise ?

rtan — Wed, 06 Jan 2010 17:02:45 GMT

Hi thereI am using the new Alfresco 3.2 Enterprise. My environment includes JBoss 5.0.1GA going against SQL Server 2005. My sever log shows that the bootstrap process works until I run into Ibatis XML related exceptions. This is exactly as reported at: https://issues.alfresco.com/jira/browse/ETHREEO

Re: New issue in Alfresco 3.2 Enterprise ?

mrogers — Wed, 06 Jan 2010 17:37:47 GMT

You need to contact Alfresco support. I suspect the first thing they will do is to check exactly which version you have, since you probably have some sort of pre-release.

Re: New issue in Alfresco 3.2 Enterprise ?

homeshoolin — Wed, 20 Jan 2010 19:32:53 GMT

I am getting the exact same error. Trying to set up Alfresco 3.2 Enterprise Edition on Windows server 2003 with Tomcat and MS SQL Server 2005. Alfresco was downloaded with the license this week, so I do not believe it is a prerelease or anything.

I think that this snippet may be key:

— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.content.parameter_ContentUrl.
— Check the statement (update failed)

and am looking to see what can be wrong with this section of content-common-SqlMap.xml:

<parameterMap id="parameter_ContentUrl" class="ContentUrl">
        <parameter property="contentUrl" jdbcType="VARCHAR" javaType="java.lang.String"/>
        <parameter property="contentUrlShort" jdbcType="VARCHAR" javaType="java.lang.String"/>
        <parameter property="contentUrlCrc" jdbcType="BIGINT" javaType="java.lang.Long"/>
        <parameter property="size" jdbcType="BIGINT" javaType="java.lang.Long"/>
        <parameter property="orphanTime" jdbcType="BIGINT" javaType="java.lang.Long"/>
    </parameterMap>

any thoughts?

Re: New issue in Alfresco 3.2 Enterprise ?

bramthielemans — Thu, 21 Jan 2010 09:51:12 GMT

I also had this problem, but got an Alfresco running on a MS SQL Server 2005 database today by using the jtds driver instead of sqljdbc4. Download it from http://jtds.sourceforge.net/

Then change your db.driver and db.url properties:

db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://${db.host}:${db.port}/${db.name}

Re: New issue in Alfresco 3.2 Enterprise ?

homeshoolin — Thu, 21 Jan 2010 15:56:16 GMT

Thanks for the reply!

I tried the driver you mentioned but had the same result. Were there any other things that you changed or did you just add the jar file to the lib dir and update the alfresco-global.properties file?

Re: New issue in Alfresco 3.2 Enterprise ?

bramthielemans — Fri, 22 Jan 2010 08:21:01 GMT

Does the log still mention the com.microsoft driver? If so, remove sqljdbc4.jar from tomcat/lib. You can also try to disable the db.txn.isolation property.

Some JIRA links:
http://issues.alfresco.com/jira/browse/ETHREEOH-3252
https://issues.alfresco.com/jira/browse/ETHREEOH-3992

Re: New issue in Alfresco 3.2 Enterprise ?

sibe — Wed, 03 Mar 2010 17:39:03 GMT

HAVE YOU FOUND THE SOLUTION FOR THIS PROBLEM ?
i have the same problem

THANK

Re: New issue in Alfresco 3.2 Enterprise ?

dward — Wed, 03 Mar 2010 17:55:44 GMT

The error suggests a column is missing that should be there. This suggests an upgrade error.

Were you upgrading your database from a previous version? If so what version?

What do you see for version.build in $TOMCAT_HOME/webapps/alfresco/WEB-INF/classes/alfresco/version.properties?

And if you are an enterprise customer, why haven't you logged this with Alfresco support?

Re: New issue in Alfresco 3.2 Enterprise ?

sibe — Wed, 03 Mar 2010 18:08:36 GMT

There is the version.properties file in TOMCAT_HOME\webapps\classes\alfresco

#
# Alfresco version information
#

# Version label

version.major=3
version.minor=2
version.revision=0
version.label=

# Edition label

version.edition=Enterprise

# Build number

version.build=304

# Schema number

version.schema=3400‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Sorry I have not seen that I was logged as support.
I have found the solution of this problem

thank

Re: New issue in Alfresco 3.2 Enterprise ?

sibe — Thu, 04 Mar 2010 08:18:58 GMT

Please have you a problem for this problem.
Alfesco enterprise 3.2 run with mysql but not with sql server 2005

Re: New issue in Alfresco 3.2 Enterprise ?

sibe — Thu, 04 Mar 2010 13:08:01 GMT

Hello dward

Can you explain me the problem of the column please

Re: New issue in Alfresco 3.2 Enterprise ?

dward — Thu, 04 Mar 2010 14:04:01 GMT

Please answer my questions.

Re: New issue in Alfresco 3.2 Enterprise ?

dward — Thu, 04 Mar 2010 14:18:47 GMT

Your build number confirms you have Alfresco Enterprise v3.2.0.

This looks similar to http://issues.alfresco.com/jira/browse/ETHREEOH-3252

Alfresco Enterprise v3.2.0 was tested against SQL Server 2008 with the Microsoft JDBC driver. Other people seem to have had success with SQL Server 2005 and the JTDS driver, but note this is not officially supported. As this issue concerns an enterprise version, all further issues should be taken up with Alfresco support.

Re: New issue in Alfresco 3.2 Enterprise ?

sibe — Thu, 04 Mar 2010 15:34:20 GMT

Hello dward,

Thank for your answer I test this to see the result with sql server 2008

For your question I have not answer I'm just a user's alfresco for my formation
I'm not working in Alfresco

Re: New issue in Alfresco 3.2 Enterprise ?

sibe — Thu, 04 Mar 2010 17:42:59 GMT

I have finished to test alfresco-enterprise 3.2.0 and alfresco-enterprise-3.2r, but I have the same problem

I remember you that I've used ms-sql server 2008 and ms-sql driver .

Re: New issue in Alfresco 3.2 Enterprise ?

rtan — Fri, 05 Mar 2010 18:49:26 GMT

People have asked me what the solution is for this. It is simple, replace the Microsoft JDBC connector with this open source one.
http://jtds.sourceforge.net/
Alresco engineers have been using it for quite a while. So do we and it seems to work finer than Microsoft's.

Re: New issue in Alfresco 3.2 Enterprise ?

dward — Fri, 05 Mar 2010 20:09:46 GMT

Enterprise customers please note that this is not the certified stack for Alfresco v3.2 and you should consult Alfresco support before adopting a different driver.

Re: New issue in Alfresco 3.2 Enterprise ?

sibe — Tue, 16 Mar 2010 10:44:50 GMT

Hello, I want just say you that alfresco enterprise 3.2 work succes with

1. jtds driver (http://jtds.sourceforge.net) you move this in tomcat_home\lib
2. use sql server 2008
3. create database alfresco and user
4.edit the file alfresco_home\tomcat\shared\alfresco-global.proporties and add the following lones
dir.root=./alf_data
db.username=alfresco
db.password=alfresco
db.name=alfresco
db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://BCNSDBA042:1433;databaseName=alfresco;user=alfresco;password=alfresco

Thank and good luck

Re: New issue in Alfresco 3.2 Enterprise ?

sibe — Thu, 18 Mar 2010 17:29:09 GMT

This problem is close if you want a solution use the following configuration:

1. Sql sever 2008
2. jtds.jar as driver
And normally your alfresco server run
thank