Error in Deserialize JSON activity: Job stopped with an unexpected exit code: 0xE0434352

Help Activities
, ,
1

Hello guys,
I am trying to deserialize JSON text using Deserialize JSON activity but studio throws Job stopped with an unexpected exit code: 0xE0434352.
Its works fine when text size is small but not when huge text.

Please suggest if there is any other way to do the same task and output should be JSON Array.

Thank you in advance…

2

Do you read the JSON in from a text file?
If so then try:

  • File.ReadAllText(“PATHToYourJSONFIle”) - will return the text file string
    OR
  • Buffered Reading
3

Hi @ppr ,

I can able to read all text using VB code but the problem is with deserializing that text.

Thank you

4

ensure to have identified the exact location where it is failing. When the Deserialize JSON Activity is throwing the exception give a try at the following

Assign Activity:
myJObject | DataType: JObject =
Newtonsoft.Json.Linq.JObject.Parse(YourJSONStringVar)

5

I tried it but it was not working. It throws the same error.

6

lets have straighforward discussion. Help us on all relevant facts we cannot derrive from only textual reports.

When JSON is failing, then share a data sample with us, so we can replicate

7

Process Steps,

  1. Reading JSON file by using VB code and store into the string variable.
  2. Using Deserialize JSON activity, deserialize that string and store into the JArray variable.
  3. JArray will be used in further process.

Issue,
Deserialize JSON activity is working fine when text size is small but throwing an error when huge text size (> 10 Lakh lines).

Thank you.

8

Perfect, so lets replicate it can you share json with us, thanks

9

I appreciate your response, but confidentially prevents me from sharing the file. Would you kindly offer an alternative?

10

yes

setup a fake JSON e.g. with repeated non confidential values within a size, which causes a thrown exception. So we can work on this and you will not break any confidetials