Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-4258

Impossible to create web content (bulk import)

    Details

    • 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

      Description

      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.

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs
                  Reporter:
                  kbeltda Enrique Martinez Bonilla (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel