Hi guys,
I've two alfresco 2.1.0 enterprise in cluster with Oracle DB.
I've install WCM on both nodes.
When I create a Web Project on first node I haven't problem and I see new web project on second node, but if I create a new Web Project on second node I have this error on the last page when click Finish:
Please correct the errors below then click Finish.
* A system error happened during the operation: Could not execute JDBC batch update
and in catalina.out I've:
13:43:55,598 ERROR [ui.common.Utils] A system error happened during the operation: Could not execute JDBC batch update
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
….
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (ALFRESCO.SYS_C0012181) violated
I've test cluster with MySQL DB and error is:
14:03:39,461 ERROR [ui.common.Utils] A system error happened during the operation: Could not execute JDBC batch update
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
. . .
Caused by: java.sql.BatchUpdateException: Duplicate entry '107' for key 1
Can you help me?
Thanks,
FEj