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)

Question

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
 }
 )

Chris · Answer

So, customCellPositions and customCellValues can only be used when you have an exact set of say, 50 values and 50 specific cells you want them in - they do not work as "starting cells" essentially, for a set of rows. As you are returning multiple rows, the values multiply to 900, so you cannot use this configuration for multiple rows. However if you want the data to start at a specific cell, you can use your single startingCell parameter, such as "A2". 
 Unfortunately as the a!exportDataStoreEntityToExcel() function exports data directly from the database, you will need to update the logic there. Assuming you are using a view to export under cons!FAS_DSE_VW_QUALITY_WORK_EXPORT, the view will need to be adjusted with something such as case() statements to check for empty values and add defaults. Or, if the view is used in different functions, duplicate the view to one that is used only for this purpose with the modifications. Hopefully that is possible in your environment..

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)

Top Replies