topic Re: System Error when attempting to submit files in Alfresco Archive

System Error when attempting to submit files

notts01 — Mon, 01 Mar 2010 12:18:29 GMT

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 expre

Re: System Error when attempting to submit files

janv — Tue, 02 Mar 2010 09:55:43 GMT

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

Re: System Error when attempting to submit files

notts01 — Wed, 03 Mar 2010 09:01:14 GMT

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

Re: System Error when attempting to submit files

janv — Wed, 03 Mar 2010 09:46:59 GMT

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

Re: System Error when attempting to submit files

notts01 — Wed, 10 Mar 2010 16:09:12 GMT

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

Re: System Error when attempting to submit files

janv — Fri, 12 Mar 2010 09:23:14 GMT

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

Re: System Error when attempting to submit files

gurj — Thu, 18 Mar 2010 12:44:18 GMT

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.