Fatal error

[SornakumarV]

Hi,

While reading the data from database using blueprism we are facing the below issue. Please if any chance to help this one.

Error: "fatal error encountered attempting to read the result"

Thanks for advance.

------------------------------
Sornakumar V
RPA Developer
Iopex technologies
Chennai
------------------------------

[SteveBoggs]

More information would be useful to determine some troubleshooting suggestions here. What software is throwing the error, i.e. Blue Prism, SQL Server, an Oracle database, etc.? Is this a Blue Prism Process that reads a database, or are you querying a database directly? What are the exact steps to reproduce the error? What is the exact error message seen, along with any accompanying error stack details?

------------------------------
Steve Boggs
Senior Product Support Engineer
Blue Prism
Austin, TX
------------------------------

[SornakumarV]

Hi Steve,

Thanks for reply.

Here I mentioned your asked details 

What software is throwing the error,

Ans : Blue Prism

 Is this a Blue Prism Process that reads a database,

Ans : Yes

What are the exact steps to reproduce the error?

Am using SQL object in blueprism

Set connection

Begin transaction

Commit transaction

Then get CSV 

While executing the query, facing above mentioned issue.

I used select query.

What is the exact error message seen, along with any accompanying error stack details?

"fatal error encountered attempting to read the result"

------------------------------
Sornakumar V
RPA Developer
Iopex technologies
Chennai
------------------------------

[Mukeshh_k]

Hi Sornakumar,

This seems to be a case of timeout - Your query is getting timed out without a response while executing, please try setting and increasing the timeout.

cmd.CommandTimeout = Number of seconds;

For better clarity and reference please refer Microsoft Documentation : https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.commandtimeout?view=dotnet-plat-ext-3.1 

------------------------------

Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS England, United Kingdom, GB

------------------------------

[SornakumarV]

Thanks Mukesh.

I will try and then update.

------------------------------
Sornakumar V
RPA Developer
Iopex technologies
Chennai
------------------------------

[SornakumarV]

Hi Mukesh,

I checked with database administrator and found the error. Now sorted.

Error in database, initially character set is utf8mb4. Then they changed utf8mb3. due to this character set throwed exception from blueprism. 

------------------------------
Sornakumar V
RPA Developer
Iopex technologies
Chennai
------------------------------

[Mukeshh_k]

Thanks for coming back onto this thread and sharing the useful info/update around this - Sornakumar V. I am glad it is sorted now.

Cheers !!

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS England, United Kingdom, GB
------------------------------

[SophiaKhan]

Hi Friend,
Thank you very much for giving such nice information.

------------------------------
Sophia Khan
------------------------------