Export DSE to Excel Issue : Error accessing data store entity?

HI All,

Seeing below error when i try to export DSE to Excel.

 

Background: We have a UI and we use a CDT to pass the filters into PM to call the DSE to Excel Smart Service. When we try to export without any filters I was able to export the date(16000 Rows), but when I use a created by filter which which returns (8000 Rows), I'm seeing the above error in PM.

Below is the query filter logic

a!queryFilter(
      field:"referralCreatedBy",
      operator:"=",
      value:ri!xxxxx.createdBy,
      applyWhen: not(
        rule!AF_RULE_General_isBlank(
          ri!xxxxx.createdBy
        ))
    ),

Thanks in Advance. Any suggestions appreciated.

  Discussion posts and replies are publicly visible

  • a!queryLogicalExpression(
    operator:"AND",
    filters: {
    a!queryFilter(
    field:"primaryBranch",
    operator:"=",
    value:ri!settingJson.primaryBranch,
    applyWhen: not(
    rule!AF_RULE_General_isBlank(ri!settingJson.primaryBranch)
    )
    ),
    a!queryFilter(
    field:"statusDesc",
    /* Goldfish TCO-23312 Updated the operator to "in" for multi dropdown */
    operator:"in",
    value: a!forEach(
    items: ri!settingJson.status,
    expression: trim(fv!item)
    ),
    applyWhen: not(
    rule!AF_RULE_General_isBlank(ri!settingJson.status)
    )
    ),
    a!queryFilter(
    field:"statusCategory",
    operator:"=",
    value:ri!settingJson.stage,
    applyWhen: not(
    rule!AF_RULE_General_isBlank(
    ri!settingJson.stage
    )
    )
    ),
    a!queryFilter(
    field:"relationshipOwner",
    operator:"=",
    value:ri!settingJson.roName,
    applyWhen: not(
    rule!AF_RULE_General_isBlank(
    ri!settingJson.roName
    )
    )
    ),
    a!queryFilter(
    field: "teamCode",
    operator: "in",
    value: ri!settingJson.teamCode,
    applyWhen: not(
    rule!AF_RULE_General_isBlank(
    ri!settingJson.teamCode
    )
    )
    ),
    a!queryFilter(
    field:"referralCreatedBy",
    operator:"=",
    value:ri!settingJson.createdBy,
    applyWhen: not(
    rule!AF_RULE_General_isBlank(
    ri!settingJson.createdBy
    ))
    ),
    a!queryFilter(
    field: "createdDate",
    operator: if(
    and(
    not(rule!AF_RULE_General_isBlank(local!fromDate)),
    rule!AF_RULE_General_isBlank(local!toDate)
    ),
    ">=",
    if(
    and(
    rule!AF_RULE_General_isBlank(local!fromDate),
    not(rule!AF_RULE_General_isBlank(local!toDate))
    ),
    "<=",
    "between"
    )
    ),
    value: if(
    and(
    not(rule!AF_RULE_General_isBlank(local!fromDate)),
    rule!AF_RULE_General_isBlank(local!toDate)
    ),
    local!fromDateToDateTime,
    if(
    and(
    rule!AF_RULE_General_isBlank(local!fromDate),
    not(rule!AF_RULE_General_isBlank(local!toDate))
    ),
    local!toDateToDateTime,
    {
    local!fromDateToDateTime,
    local!toDateToDateTime
    }
    )
    ),
    applyWhen: or(
    not(
    rule!AF_RULE_General_isBlank(ri!settingJson.applicationCreatedDateFrom)
    ),
    not(
    rule!AF_RULE_General_isBlank(ri!settingJson.applicationCreatedDateTo)
    )
    )
    )

    }

    )

  • It's working when i use a!exporttoDSE, can you have any suggestion on deleting the exported file or  all the files in the folder at once? Which is the requirement for my story and i am not saving the doc id in DB

  • What I have done before is to make sure I always put the file in a temporary folder I make. Then I have a process running nightly or weekly which deletes all documents in the folder.