Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-11413

Remove unnecessaries audit extended infos

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.6.0-HF14
    • Fix Version/s: 5.7.1
    • Component/s: Workflow
    • Tags:
    • Impact type:
      Configuration format change
    • Upgrade notes:
      Hide

      Execute the following queries into the database to clean the unnecessary entries into the log tables:

      create table NXP_LOGS_tmp as select LOGS.log_id , LOGS_EXT.log_extinfo_id from nxp_logs LOGS, nxp_logs_extinfo LOGS_EXT, nxp_logs_mapextinfos LOGS_EXT_MAP
      where LOGS_EXT_MAP.log_fk = LOGS.log_id and LOGS_EXT_MAP.info_fk = LOGS_EXT.log_extinfo_id
      AND LOGS_EXT_MAP.mapkey = 'workflowName';
      delete from nxp_logs_mapextinfos where mapkey = 'workflowName';
      delete from nxp_logs_extinfo where log_extinfo_id IN (select log_extinfo_id from NXP_LOGS_tmp);
      delete from nxp_logs where log_id IN (select log_id from NXP_LOGS_tmp);
      drop table NXP_LOGS_tmp;

      Show
      Execute the following queries into the database to clean the unnecessary entries into the log tables: create table NXP_LOGS_tmp as select LOGS.log_id , LOGS_EXT.log_extinfo_id from nxp_logs LOGS, nxp_logs_extinfo LOGS_EXT, nxp_logs_mapextinfos LOGS_EXT_MAP where LOGS_EXT_MAP.log_fk = LOGS.log_id and LOGS_EXT_MAP.info_fk = LOGS_EXT.log_extinfo_id AND LOGS_EXT_MAP.mapkey = 'workflowName'; delete from nxp_logs_mapextinfos where mapkey = 'workflowName'; delete from nxp_logs_extinfo where log_extinfo_id IN (select log_extinfo_id from NXP_LOGS_tmp); delete from nxp_logs where log_id IN (select log_id from NXP_LOGS_tmp); drop table NXP_LOGS_tmp;

      Description

      The following extended infos are never used, so they should be removed to avoid unecessaries inserts into the database. 

        <extension point="extendedInfo"
    target="org.nuxeo.ecm.platform.audit.service.NXAuditEventsService">
    <extendedInfo expression="#{message.properties.attachDocumentID}"
      key="attachDocumentID" />
    <extendedInfo expression="#{source.name}" key="workflowName" />
    <extendedInfo expression="#{source.description}" key="workflowDescription" />
    <extendedInfo expression="#{source.getDocument().dublincore.creator}"
      key="workflowInitiator" />
    <extendedInfo
      expression="#{source.getDocument().getPropertyValue('rnode:startDate')}"
      key="workflowStartDate" />
    <extendedInfo
      expression="#{source.getDocument().getPropertyValue('rnode:endDate')}"
      key="workflowEndDate" />
  </extension>

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: