Skip to main content
October 18, 2023
Question

Error when trying to click link field to edit/update user

  • October 18, 2023
  • 5 replies
  • 0 views

I am getting this error screenshotted above when trying to click a link field setup for editing/updating a user. I will show the block of code from Line 52 and on within TB_QE_getPodCodes that it says it is complaining about. Does anyone know why this might be occurring or point me in the right direction? Thanks in advance!

a!queryEntity_22r2(
      entity: cons!TB_ENTITY_PODS,
      query: a!query(
        selection: if(
          a!isNullOrEmpty(ri!selectionList),
          null,
          a!querySelection(
            columns: a!forEach(
              items: touniformstring(ri!selectionList),
              expression: { a!queryColumn(field: fv!item) }
            )
          )
        ),
        logicalExpression: if(
          not(local!checkAllFilterNull),
          a!queryLogicalExpression(
            operator: "AND",
            filters: {
              a!queryFilter(field: "id", operator: "in", value: ri!id),
              a!queryFilter(
                field: "podCode",
                operator: "in",
                value: ri!podCode
              ),
              a!queryFilter(
                field: "podCode",
                operator: "includes",
                value: ri!podCodePicker
              ),
              a!queryFilter(
                field: "podCode",
                operator: "in",
                value: ri!podCodeFilters
              ),
              a!queryFilter(
                field: "podTag",
                operator: if(ri!isFilter,"includes","="),
                value: ri!podTag
              ),
              a!queryFilter(
                field: "podName",
                operator: if(ri!isFilter,"includes","="),
                value: ri!podName
              ),
              a!queryFilter(
                field: "podGroupCode",
                operator: "in",
                value: ri!podGroupCode
              ),
              a!queryFilter(
                field: "compressType",
                operator: "in",
                value: ri!compressType
              ),
              a!queryFilter(
                field: "pmCode",
                operator: "in",
                value: ri!pmCode
              ),
              a!queryFilter(
                field: "aimAccount",
                operator:if(ri!isFilter,"includes","="),
                value: ri!aimAccount
              ),
              a!queryFilter(
                field: "region",
                operator: "in",
                value: ri!region
              ),
              a!queryFilter(
                field: "strategyDesc",
                operator: if(ri!isFilter,"includes","="),
                value: ri!strategyDesc
              ),
              a!queryFilter(
                field: "complianceTag",
                operator: "in",
                value: ri!complianceTag
              ),
              a!queryFilter(
                field: "specialityStrategy",
                operator: "=",
                value: ri!specialityStrategy
              ),
              a!queryFilter(
                field: "podTagAimId",
                operator: "=",
                value: ri!podTagAimId
              ),
              a!queryFilter(
                field: "podClosed",
                operator: "=",
                value: ri!podClosed
              ),
              a!queryFilter(
                field: "aimTradingDayCheck",
                operator: "=",
                value: ri!aimTradingDayCheck
              ),
              a!queryFilter(
                field: "orchestradeEnabled",
                operator: "=",
                value: ri!orchestradeEnabled
              ),
              a!queryFilter(
                field: "sodPositionSource",
                operator: "in",
                value: ri!sodPositionSource
              ),
              a!queryFilter(
                field: "isActive",
                operator: "=",
                value: ri!isActive
              ),
              a!queryFilter(
                field: "createdBy",
                operator: "=",
                value: ri!createdBy
              ),
              a!queryFilter(
                field: "lastModifiedBy",
                operator: "=",
                value: ri!lastModifiedBy
              ),
              a!queryFilter(
                field: "id",
                operator: "not in",
                value: ri!excludeId
              ),
              
            },
            ignoreFiltersWithEmptyValues: true
          ),
          null
        ),
        pagingInfo: if(
          a!isNullOrEmpty(ri!pagingInfo),
          a!pagingInfo(
            startIndex: 1,
            batchSize: - 1,
            sort: a!sortInfo(field: "id", ascending: true())
          ),
          ri!pagingInfo
        )
      ),
      fetchTotalCount: if(
        a!isNullOrEmpty(ri!fetchTotalCount),
        false,
        ri!fetchTotalCount
      )
    )

5 replies

stefanhelzle0001
Brainy
October 18, 2023

Such an error in a query typically points towards a timeout. I suggest to check the tomcat log file for details.

October 18, 2023

The tomcat log files are typically located right here in this screenshot right?

stefanhelzle0001
Brainy
October 18, 2023

Should be there, yes. Is this an on-premise setup?