System Error when attempting to submit files

[notts01]

Hi,

I was wondering if anyone could help me: When I attempt to submit html and xml files that I have made changes to I get the error message below - does anyone know why I am getting this message and what I can do to fix it?! Thank you in advance!

javax.faces.FacesException: Cannot get value for expression '#{DialogManager.bean.workflowListSize != 0}'
caused by:
org.apache.jasper.JasperException: Cannot get value for expression '#{DialogManager.bean.workflowListSize != 0}'
caused by:
javax.faces.el.EvaluationException: Cannot get value for expression '#{DialogManager.bean.workflowListSize != 0}'
caused by:
javax.faces.el.EvaluationException: Exception getting value of property workflowListSize of base of type : org.alfresco.web.bean.wcm.SubmitDialog
caused by:
javax.faces.el.EvaluationException: Bean: org.alfresco.web.bean.wcm.SubmitDialog, property: workflowListSize
caused by:
java.lang.reflect.InvocationTargetException
caused by:
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.DataException: could not execute query
caused by:
org.hibernate.exception.DataException: could not execute query
caused by:
java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.

[janv]

Are you using Microsoft SQL Server as your DB server ? Please add more details about your environment including exact release / build version of Alfresco, App server, DB server, JDK, O/S etc.

Regards,
Jan

[notts01]

Hi Jan,

This is the information I have about our Alfresco system: Installed on single server running Windows Server 2003 R2 Standard SP2, running SQL 2005 std, Version: Community Network - v2.9.0 (dev 646), java version "1.6.0_18"
Java(TM) SE Runtime Environment (build 1.6.0_18-b07), Java HotSpot(TM) Client VM (build 16.0-b13, mixed mode, sharing)

Thanks very much!

Hannah

[janv]

It appears to me that you may be hitting the following issue (in your case, against Microsoft SQL Server as opposed to Oracle):

http://issues.alfresco.com/jira/browse/ETWOONE-19

This issue is resolved in the Enterprise releases. In terms of Community, this should also be resolved in build 1185 or higher. FYI, the current Community Edition is 3.2r2 (build 2440).

Regards,
Jan

[notts01]

Hi Jan,

Thank you for your reply - we've tried this soluction and have hit a problem in that the latest version of Alfresco does not support our Microsoft SQL Database, which is the same problem as mentioned in this link: https://issues.alfresco.com/jira/browse/ALFCOM-3635 I was wondering if you had any suggestions of a workaround? Thank you again for your help!

Hannah

[janv]

Good point - please refer to the comments against https://issues.alfresco.com/jira/browse/ALFCOM-3635. Options include:

- upgrading to Alfresco Enterprise support
- switching to MySQL (or PostgreSQL, although this may require some additional fix-up work)

Regards,
Jan

[gurj]

Hi Jan,

What is causing the initial "java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers" issue?

Currently we cannot delete files, as that involve clicking submit which then throws up the same exception, Is there a table I can  remove data from so that the parameter list is less than 2000?

I've also upgraded to community edition 3.2r2, and attempted a migration to mySQL, but this appears to be quite a task..is there an easy way to go from 2.9 to 3.2?

Thanks

Gurj.