Assignment 1 Level 3 - "System Data..." in value - Help

#1

Hello all,
I am struggling with this part of the assignment. What I am not understanding is the following:

  1. When I run my robot, I get “System.Data.DataRow” in the Value when assigning to the “out_TransactionItem”. Not sure why. Keep in mind that I have already set both in_WIList and WList as Datarow.
  2. What value should return when in_WIList(in_TransactionNumber-1).ToString?
  3. “so we only need to change the value of TransactionID in the Assign
    activity to “out_TransactionItem(“WIID”).ToString”.” I am very lost here, it throws and an error about integer and string…

Any help is appreciated. I am a little tired. Hopefully my question makes sense.

#2

Hi @RickStar

Welcome to the community!!

So looks like the error is in GetTransactionData.xaml file. Could you share this file with us so we can have a look to identify the issue?

1 Like
#3

Thanks for your response. I am not able to upload files as a new user but here is the attached screen shot of the GetTransactionData.xaml file.

Thanks again!

#4

Hi @RickStar

looks like out_transactionitem data type is wrong. Looks like it should be of DataRow type. Changing that will solve the error in your question.

Additionally, in the invoke activity, out_TransactionItem is not assigned to anything. Make sure you assign the out value to TransactionItem variable…

Let know how it goes…

If this works, please make sure to mark the answer as the solution too :slight_smile:

#5

Thanks for your reply. I made the changes to the out_transactionItem datatype to datarow which throw other data type related errors ( I corrected those). However, when I ran it again, the initial System Data Row error still remains.

By the way. Here is what my Data looks like.
DataRow[19]
{
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“161585”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2018-06-11”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“231845”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2019-01-22”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“467385”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2018-10-19”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“427725”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2019-03-16”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“730195”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2017-03-02”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“389065”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2018-04-14”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“244575”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2017-10-07”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“740275”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2018-04-18”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“908825”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2018-03-27”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“944795”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2017-07-19”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“667015”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2018-09-29”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“861195”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2018-01-04”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“529055”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2017-04-26”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“395875”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2017-09-29”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“776855”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2017-06-06”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“755595”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2018-11-14”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“467905”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2018-02-10”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“710575”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2017-06-08”
},
RowError="",
RowState=Added,
Table=
},
DataRow
{
HasErrors=false,
ItemArray=object[6]
{
“”,
“110585”,
“Calculate Client Security Hash”,
“WI5”,
“Open”,
“2018-07-05”
},
RowError="",
RowState=Added,
Table=
}
}

#6

@RickStar

the data type of the out_Transactionitem should be of type DataRow. not datarow array.

Can you exactly tell me what’s the error that you get? a screenshot? If you are unable to add a screenshot, please type the error message here so I can look for a solution

#7

I corrected the data type to DataRow - It looks better but still not working. see image below

#8

@RickStar

The data looks fine there. but I need to see the actual error message you get there. Can I see a screenshot of that too?

#9

Here is the log exception message:

{
“message”: “Log exception message and End process Executing”,
“level”: “Trace”,
“logType”: “Default”,
“timeStamp”: “12:40:23”,
“processVersion”: “1.0.0”,
“jobId”: “f97b44c3-ad34-4d7d-bc47-0172ac19663a”,
“robotName”: “25501 - opennotepad”,
“machineId”: 127214,
“fileName”: “Main”,
“logF_BusinessProcessName”: “Framework”,
“activityInfo”: {
“Activity”: “System.Activities.Statements.Sequence”,
“DisplayName”: “Log exception message and End process”,
“State”: “Executing”,
“Variables”: {
“ShouldStop”: “False”,
“TransactionItem”: “”,
“SystemError”: “”,
“BusinessRuleException”: “”,
“TransactionNumber”: “1”,
“Config”: “System.Collections.Generic.Dictionary`2[System.String,System.Object]”,
“RetryNumber”: “0”,
“TransactionField2”: “”,
“TransactionField1”: “”,
“TransactionID”: “04/18/2019 12:29:35”,
“TransactionData”: “”,
“WIList”: “System.Data.DataRow
},
“Arguments”: null
}
}

#10

@RickStar it doesn’t explicitly mention the exact error message. but I notice that your transactionitem has no data.

Does it actually throw an error message? in a separate window? If so, can you share a screenshot of that as well?

I’m still trying to locate this… and what it is…

#11

No actual message is thrown , “message”: “Invoke GetTransactionData workflow Faulted”,
The integer and string error has been resolved. Now we just need to figure out why GetTransactionData workflow Faulted and processing ends.

#12

I found this message:

{
“message”: “Error getting transaction data for Transaction Number: 1. Can not convert Object to String. at Source: Newtonsoft.Json”,
“level”: “Fatal”,
“logType”: “User”,
“timeStamp”: “13:05:07”,
“processVersion”: “1.0.0”,
“jobId”: “aa63537d-a5b6-4499-9a29-d8c13afa1d84”,
“robotName”: “25501 - opennotepad”,
“machineId”: 127214,
“fileName”: “Main”,
“logF_BusinessProcessName”: “Framework”
}

#13

hmm… bro, i think its the best if I can see the file. can you email me the file?

#14

Sure!

#15

I guess i located the problem…

image

See the underlined part. It doesn’t look right :slight_smile: because of the double quotation marks. Retype the quotation marks and it should look like this

image

it should work :slight_smile:

if this works, please make sure to mark the answer as the solution too bro!!

Thanks!

#16

No luck even with those changes. Here is my xaml file. Can you see if there is an issue there?

Main.xaml (57.7 KB)

#17

Yes… there is a small problem

Though the errors are corrected, the value of out_transactionitem is not returned to the Main workflow here because it is not assigned to anything. Changed it like below

image

#18

Also, out_TransactionItem should be a DataRow.

#19

Thanks for joining the conversation. This is the message I get when I attempt to assign TransactionItem to it.

#20

It seems like you’re going to have to switch it in a few other places that you have changed it. Your TransactionItem is generally going to be one of two different datatypes: QueueItem or DataRow depending on how you’re using the ReFramework. If you start a new project, it would be type QueueItem because they’re going to rightfully push for people to use the Orchestrator queues.