Blue Prism Product

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.

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?

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.

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

Original Message:
Sent: 03-03-2023 17:49
From: Steve Boggs
Subject: Fatal error

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

Original Message:
Sent: 03-03-2023 16:15
From: Sornakumar V
Subject: Fatal error

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

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

Original Message:
Sent: 03-03-2023 19:46
From: Sornakumar V
Subject: Fatal error

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

Original Message:
Sent: 03-03-2023 17:49
From: Steve Boggs
Subject: Fatal error

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

Original Message:
Sent: 03-03-2023 16:15
From: Sornakumar V
Subject: Fatal error

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

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

Original Message:
Sent: 03-03-2023 19:46
From: Sornakumar V
Subject: Fatal error

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

Original Message:
Sent: 03-03-2023 17:49
From: Steve Boggs
Subject: Fatal error

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

Original Message:
Sent: 03-03-2023 16:15
From: Sornakumar V
Subject: Fatal error

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

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

Original Message:
Sent: 03-03-2023 20:29
From: Mukesh Kumar
Subject: Fatal error

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

Original Message:
Sent: 03-03-2023 19:46
From: Sornakumar V
Subject: Fatal error

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

Original Message:
Sent: 03-03-2023 17:49
From: Steve Boggs
Subject: Fatal error

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

Original Message:
Sent: 03-03-2023 16:15
From: Sornakumar V
Subject: Fatal error

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

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

Original Message:
Sent: 03-03-2023 19:46
From: Sornakumar V
Subject: Fatal error

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

Original Message:
Sent: 03-03-2023 17:49
From: Steve Boggs
Subject: Fatal error

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

Original Message:
Sent: 03-03-2023 16:15
From: Sornakumar V
Subject: Fatal error

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