Question

Random wrong results from expression rule in process model

Forum|Forum|1 year ago
September 27, 2024
8 replies
0 views

Hi, we are having a problem executing an expression rule, which contains an a!queryRecordType, where we have:
- 1 grouping field
- 1 measure field
- 4 filters,

on a batchsize of 500 items.
In detail, every time we try the rule from expression rule the result is correct but when we insert it in a script task from process model it randomly gives wrong results (correct measure corresponding to wrong group fields). A delay of 1 minute after last node has also been inserted in the process activity.

What could be the problem?

Thanks,

Francesca

stefanhelzle0001

Such random issues are extremely difficult to find. Especially when we have no details. Can you share some?

F

francescai9347Author

Hi, this is the first part of the expression rule we call from the process, stored in a local variable because is a partial elaboration of the ER.

Saving its result we can see sometime is not correct in DATA field of the map (we have the right number of element in the map, with correct measure but wrong group).

  a!queryRecordType(
    recordType:  'recordType!{8d214138-b859-4710-9cea-02edebba758c}RECORD',
    fields: a!aggregationFields(
      groupings: {
        a!grouping(
          field: 'recordType!{8d214138-b859-4710-9cea-02edebba758c}RECORD.fields.{4aa8d14a-37a8-49b3-83cd-a53638bc83e8}DATA_PAGAMENTO',
          alias: "DATA",
          interval: "DATE"
        )
      },
      measures: {
        a!measure(
          function: "SUM",
          field: 'recordType!{8d214138-b859-4710-9cea-02edebba758c}RECORD.fields.{ce39a834-36e1-4d1e-a837-166a14889542}IMPORTO_PAGATO',
          alias: "IMPORTO"
        )
      }
    ),
    filters: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: 'recordType!{8d214138-b859-4710-9cea-02edebba758c}RECORD.fields.{d8a3e8d0-eebc-4c54-8fbd-8fda411c4502}TIPO_COMMISSIONE',
          operator: "in",
          value: {cons!FET_tipoCommissioneCreditoReteEsternaAssociazioni, cons!FET_tipoCommissioneCreditoReteEsternaAgenti}
        ),
        a!queryFilter(
          field:  'recordType!{8d214138-b859-4710-9cea-02edebba758c}RECORD.fields.{f0d2064b-9f01-44ba-81a0-97ffa82a0ddf}STATO_COMMISSIONE',
          operator: "in",
          value: {"PAGATE"}
        ),
        a!queryFilter(
          field: 'recordType!{8d214138-b859-4710-9cea-02edebba758c}RECORD.fields.{0cd4413f-de42-4a9e-935c-176e414421bd}DATA_CREAZIONE',
          operator: ">",
          value: cons!FET_DataCut
        ),
        a!queryFilter(
          field: 'recordType!{8d214138-b859-4710-9cea-02edebba758d}RECORD.fields.{4aa8d14a-37a8-49b3-83cd-a53638bc83e8}DATA_PAGAMENTO',
          operator: "not null"
        )
      },
      ignoreFiltersWithEmptyValues: true
    ),
    pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: 500
    ),
  ).data ,