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

RickStar · April 18, 2019, 2:56pm

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

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.
What value should return when in_WIList(in_TransactionNumber-1).ToString?
“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…

image688×655 20.5 KB

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

Lahiru.Fernando · April 18, 2019, 4:10pm

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?

RickStar · April 18, 2019, 4:45pm

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!

Lahiru.Fernando · April 18, 2019, 4:51pm

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

RickStar · April 18, 2019, 5:12pm

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

Lahiru.Fernando · April 18, 2019, 5:20pm

@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

RickStar · April 18, 2019, 5:32pm

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

Lahiru.Fernando · April 18, 2019, 5:39pm

@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?

RickStar · April 18, 2019, 5:46pm

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

Lahiru.Fernando · April 18, 2019, 6:03pm

@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…

RickStar · April 18, 2019, 6:09pm

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.

RickStar · April 18, 2019, 6:14pm

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

Lahiru.Fernando · April 18, 2019, 6:16pm

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

RickStar · April 18, 2019, 6:25pm

Sure!

Lahiru.Fernando · April 18, 2019, 6:33pm

I guess i located the problem…

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

it should work

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

Thanks!

RickStar · April 18, 2019, 6:41pm

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)

Lahiru.Fernando · April 18, 2019, 6:48pm

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

dmccammond · April 18, 2019, 6:58pm

Also, out_TransactionItem should be a DataRow.

RickStar · April 18, 2019, 7:03pm

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

dmccammond · April 18, 2019, 7:06pm

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.

Topic		Replies	Views
Assignment1 - out_TransactionItem Academy Feedback	16	2556	November 9, 2018
Stuck at GetTransactionData (Assignment 1 Level 3) Academy Feedback	9	1190	April 30, 2019
Assignment 1 WIList Problem Academy Feedback	22	4268	April 12, 2020
Level 3 Assignment 1 - OutTransactionItem Academy Feedback	5	916	December 18, 2019
Client hash security- GetTransactionData Academy Feedback	7	1083	July 3, 2019

Most Active Users - Yesterday
Anil_G
mkankatala
Ayatulla_Middya
Debashrit_Mishra
mkt.scott4
supermanPunch
Raj_esh
More details...

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

Related Topics