topic RE: Fatal error in Product Forum

Fatal error

Sornakumar92 — Fri, 03 Mar 2023 16:16:00 GMT

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

RE: Fatal error

steven.boggs — Fri, 03 Mar 2023 17:49:00 GMT

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

RE: Fatal error

Sornakumar92 — Fri, 03 Mar 2023 19:46:00 GMT

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

RE: Fatal error

Mukeshh_k — Fri, 03 Mar 2023 20:29:00 GMT

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

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

RE: Fatal error

Sornakumar92 — Wed, 08 Mar 2023 16:48:00 GMT

Thanks Mukesh.

I will try and then update.

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

RE: Fatal error

Sornakumar92 — Fri, 24 Mar 2023 22:10:00 GMT

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

RE: Fatal error

Mukeshh_k — Fri, 24 Mar 2023 23:41:00 GMT

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

RE: Fatal error

SophiaKhan — Sat, 25 Mar 2023 11:28:00 GMT

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

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