Question Advanced Training Assignment 2 - Report Year 2017 or 2016?


#42

okay great, that was worth a try


#43

In comments section, please write only the Upload ID. No need to mention “Uploaded with ID XXXXXX”


#44

Hi , I am facing similar problem as well where the in_WIList.Count.ToString when printed in the GetTransaction workflow turns out to be null.
So the issue seems array data not getting passed from the System1_ExtractData workflow to the GetTransaction. Please help.

Have done below:

  1. Created WIList variable of DataRow type in Main-Init section
  2. Created OUT argument in_WIList in System1_ExtractData to get the Datatable value in Datarow using the select query to filter Type=WI5 and type as Open
  3. On invocation of Get Transaction Data workflow , passed the arguments in_WIList with IN type and setting its value as (WIList - the init variable)

Still GetTransaction Data workflow is not getting the Datarow array data. Hence I am stuck since long. please help.


#45

Please verify in Init State that you are getting rows in Extracted Table, if yes then have you sent that DataTable or Filtered Data Row array to get transaction data via arguments.

Thanks,
Prankur


#46

Hi , Yes in the init state the System1_ExtractData Workflow is giving me the results of the row count as 16. Also the this datarow in_WIList is passed to the GenerateData Workflow as argument, bt on printing found data is not getting received.
Please find the images attached to help understand my setup.


#47

“message”: “Assign Transaction item: Index was outside the bounds of the array.”,
“level”: “Error”,
“logType”: “Default”,
“timeStamp”: “17:14:53”,
“processVersion”: “1.0.0.0”,
“jobId”: “4e6a8723-61be-4195-9b54-f6df661a4d91”,
“robotName”: “NAM\RPEERANNAW001”,
“machineId”: 0,
“fileName”: “GetTransactionData”,
“logF_BusinessProcessName”: “Framework”

{
“message”: “Error getting transaction data for Transaction Number: . Index was outside the bounds of the array. at Source: Assign Transaction item”,
“level”: “Fatal”,
“logType”: “User”,
“timeStamp”: “17:14:53”,
“processVersion”: “1.0.0.0”,
“jobId”: “4e6a8723-61be-4195-9b54-f6df661a4d91”,
“robotName”: “NAM\RPEERANNAW001”,
“machineId”: 0,
“fileName”: “Main”,
“logF_BusinessProcessName”: “Framework”
}

Not sure how to resolve this issue