-
Type:
Bug
-
Status: Closed (View Workflow)
-
Resolution: Fixed
-
Affects Version/s: 3.2.1
-
Fix Version/s: 3.2.1
-
Component/s: ZZ_Archive
-
Labels:None
-
Environment:Windows XP (SP3), Alfresco-Community-3.2r-Full-Setup.exe, jdk1.6.0_17
-
Bug Priority:
Category 3
An error occurred following "Getting Started with Web Content Management (WCM)
for Alfresco Community Edition 3.2r" example and creating the web content by bulk importing alfresco-sample-website.war.
10:00:56,906 ERROR [org.alfresco.web.ui.common.Utils] A system error happened during the operation: SqlMapClient operation; SQL [];
— The error occurred in alfresco/ibatis/#resource.dialect#/avm-insert-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.avm.insert_AVMNode-InlineParameterMap.
— Check the statement (update failed).
— Cause: org.postgresql.util.PSQLException: ERROR: inserción o actualización en la tabla «avm_nodes» viola la llave foránea «fk_avm_n_acl»
Detail: La llave (acl_id)=(2509) no está presente en la tabla «alf_access_control_list».; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/ibatis/#resource.dialect#/avm-insert-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.avm.insert_AVMNode-InlineParameterMap.
— Check the statement (update failed).
— Cause: org.postgresql.util.PSQLException: ERROR: inserción o actualización en la tabla «avm_nodes» viola la llave foránea «fk_avm_n_acl»
Detail: La llave (acl_id)=(2509) no está presente en la tabla «alf_access_control_list».
org.springframework.dao.DataIntegrityViolationException: SqlMapClient operation; SQL [];
— The error occurred in alfresco/ibatis/#resource.dialect#/avm-insert-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.avm.insert_AVMNode-InlineParameterMap.
— Check the statement (update failed).
— Cause: org.postgresql.util.PSQLException: ERROR: inserción o actualización en la tabla «avm_nodes» viola la llave foránea «fk_avm_n_acl»
Detail: La llave (acl_id)=(2509) no está presente en la tabla «alf_access_control_list».; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/ibatis/#resource.dialect#/avm-insert-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.avm.insert_AVMNode-InlineParameterMap.
— Check the statement (update failed).
— Cause: org.postgresql.util.PSQLException: ERROR: inserción o actualización en la tabla «avm_nodes» viola la llave foránea «fk_avm_n_acl»
Detail: La llave (acl_id)=(2509) no está presente en la tabla «alf_access_control_list».
...
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
... 116 more
Every time this operation is done, (acl_id)=(2509) value reported is different. However, looking at alf_access_control_list table, rows with acl_id previous values were not created.
Before testing application on PostgresSQL it was tested with My SQL and error doesn't occurred.