Skip to main content
sivanagamalleswarit0003
sivanagamalleswarit0003
September 7, 2022
Question

Interface Definition: Expression evaluation error: An error occurred while executing a smart service: The custom cell positions and custom cell values arrays must have the same length. (APNX-1-4505-035)

  • September 7, 2022
  • 12 replies
  • 0 views

Hello there,

I am receiving error "Interface Definition: Expression evaluation error: An error occurred while executing a smart service: The custom cell positions and custom cell values arrays must have the same length. (APNX-1-4505-035)" even though i have exact count on position and values which are 50 columns in count.

Any help to fix this issue??

a!exportDataStoreEntityToExcel(
              entity: cons!VW_ENTITY,
              selection: a!querySelection(
                columns: {
                  a!queryColumn(
                    field: "count"
                  ),
                  a!queryColumn(
                    field: "case_id"
                  ),
                  a!queryColumn(
                    field: "case_source"
                  ),
                  a!queryColumn(
                    field: "parent_case_id"
                  ),
                  a!queryColumn(
                    field: "master_account_number"
                  ),
                  a!queryColumn(
                    field: "fund"
                  ),
                  a!queryColumn(
                    field: "account_number"
                  ),
                  a!queryColumn(
                    field: "client_type"
                  ),
                  a!queryColumn(
                    field: "transaction_type"
                  ),
                  a!queryColumn(
                    field: "transaction_sub_type"
                  ),
                  a!queryColumn(
                    field: "reconciliationType"
                  ),
                  a!queryColumn(
                    field: "rejected_flag"
                  ),
                  a!queryColumn(
                    field: "adjustment"
                  ),
                  a!queryColumn(
                    field: "case_status"
                  ),
                  a!queryColumn(
                    field: "case_task"
                  ),
                  a!queryColumn(
                    field: "case_task_status"
                  ),
                  a!queryColumn(
                    field: "monetary"
                  ),
                  a!queryColumn(
                    field: "current_assignee"
                  ),
                  a!queryColumn(
                    field: "lt_qt_lmt"
                  ),
                  a!queryColumn(
                    field: "amount_estimated"
                  ),
                  a!queryColumn(
                    field: "amount_dollars"
                  ),
                  a!queryColumn(
                    field: "request_received_on"
                  ),
                  a!queryColumn(
                    field: "sorting_complete"
                  ),
                  a!queryColumn(
                    field: "sorting_completed_by"
                  ),
                  a!queryColumn(
                    field: "sorting_completed_on"
                  ),
                  a!queryColumn(
                    field: "processing_completed_by"
                  ),
                  a!queryColumn(
                    field: "processing_crew_id"
                  ),
                  a!queryColumn(
                    field: "processing_completed_on"
                  ),
                  a!queryColumn(
                    field: "nigo"
                  ),
                  a!queryColumn(
                    field: "selected_audit_count"
                  ),
                  a!queryColumn(
                    field: "audit_decisons_by"
                  ),
                  a!queryColumn(
                    field: "audit_complete"
                  ),
                  a!queryColumn(
                    field: "audit_completed_on"
                  ),
                  a!queryColumn(
                    field: "audit_return_count"
                  ),
                  a!queryColumn(
                    field: "audit_return_reasons"
                  ),
                  a!queryColumn(
                    field: "decided_by_IA"
                  ),
                  a!queryColumn(
                    field: "ia_risk_score"
                  ),
                  a!queryColumn(
                    field: "ia_reason"
                  ),
                  a!queryColumn(
                    field: "reason_for_audit"
                  ),
                  a!queryColumn(
                    field: "approval_decisons_by"
                  ),
                  a!queryColumn(
                    field: "approval_complete"
                  ),
                  a!queryColumn(
                    field: "approval_return_count"
                  ),
                  a!queryColumn(
                    field: "approval_return_reasons"
                  ),
                  a!queryColumn(
                    field: "cycle_time"
                  ),
                  a!queryColumn(
                    field: "sorting_time"
                  ),
                  a!queryColumn(
                    field: "preprocessing_time"
                  ),
                  a!queryColumn(
                    field: "processing_time"
                  ),
                  a!queryColumn(
                    field: "audit_time"
                  ),
                  a!queryColumn(
                    field: "approval_time"
                  ),
                  a!queryColumn(
                    field: "correction_review_time"
                  )
                }
              ),
              startingCell: "A2",
              customCellPositions: {"A1","B1","C1","D1","E1","F1","G1","H1","I1","J1","K1","L1","M1","N1","O1","P1","Q1","R1","S1","T1",
              "U1","V1","W1","X1","Y1","Z1","AA1","AB1","AC1","AD1","AE1","AF1","AG1","AH1","AI1","AJ1","AK1","AL1","AM1","AN1","AO1","AP1",
              "AQ1","AR1","AS1","AT1","AU1","AV1","AW1","AX1"},
              customCellValues: {
                local!qwrExportData.count,
                local!qwrExportData.case_id,
                local!qwrExportData.case_source,
                if(
                  isnull(
                    local!qwrExportData.parent_case_id
                  ),
                  local!qwrExportData.case_id,
                  local!qwrExportData.parent_case_id
                ),
                local!qwrExportData.master_account_number,
                local!qwrExportData.fund,
                local!qwrExportData.account_number,
                local!qwrExportData.client_type,
                local!qwrExportData.transaction_type,
                local!qwrExportData.transaction_sub_type,
                local!qwrExportData.reconciliationType,
                local!qwrExportData.rejected_flag,
                local!qwrExportData.adjustment,
                local!qwrExportData.case_status,
                local!qwrExportData.case_task,
                local!qwrExportData.case_task_status,
                local!qwrExportData.monetary,
                local!qwrExportData.current_assignee,
                local!qwrExportData.lt_qt_lmt,
                local!qwrExportData.amount_estimated,
                local!qwrExportData.amount_dollars,
                local!qwrExportData.request_received_on,
                local!qwrExportData.sorting_complete,
                local!qwrExportData.sorting_completed_by,
                local!qwrExportData.sorting_completed_on,
                local!qwrExportData.processing_completed_by,
                local!qwrExportData.processing_crew_id,
                local!qwrExportData.processing_completed_on,
                local!qwrExportData.nigo,
                local!qwrExportData.selected_audit_count,
                local!qwrExportData.audit_decisons_by,
                local!qwrExportData.audit_complete,
                local!qwrExportData.audit_completed_on,
                local!qwrExportData.audit_return_count,
                local!qwrExportData.audit_return_reasons,
                local!qwrExportData.decided_by_IA,
                local!qwrExportData.ia_risk_score,
                local!qwrExportData.ia_reason,
                local!qwrExportData.reason_for_audit,
                local!qwrExportData.approval_decisons_by,
                local!qwrExportData.approval_complete,
                local!qwrExportData.approval_return_count,
                local!qwrExportData.approval_return_reasons,
                local!qwrExportData.cycle_time,
                local!qwrExportData.sorting_time,
                local!qwrExportData.preprocessing_time,
                local!qwrExportData.processing_time,
                local!qwrExportData.audit_time,
                local!qwrExportData.approval_time,
                local!qwrExportData.correction_review_time
              }
              )

    12 replies

    csteward
    csteward
    September 7, 2022

    As a quick test, have you tried removing your startingCell input, since you are defining customCellPositions anyway?

    sivanagamalleswarit0003
    sivanagamalleswarit0003Author
    September 7, 2022

    yes i tried that as well and receiving same error

    csteward
    csteward
    September 7, 2022

    Another idea might be to ensure null values are not creating funky behavior in in customCellValues by reducing the value count, to test I would comment out your local variables there and try:

    a!forEach(
  items: enumerate(50),
  expression: "test"
)

    If this works, check/replace each line for null values with blank "".

    Additionally, if any of the local values are multiple, this could cause issues by raising the count of values.

    Otherwise, we have seen issues with exporting over 50 columns in some situations, but your message is not related to this - still could cut the list by 1 to see if 49 shows the same issues, if this is not due to nulls.

    Terms & ConditionsAccessibility statement