Opening database, making connection, taking the contents and closing connection

Robot Framework
1

In my code, I am going through the contents of an email (html content), then I review the content by checking what is inside.

The error code is:
Replacing variables from keyword return value failed: Resolving variable ‘${contents[0][0].read()}’ failed: DatabaseError: DPI-1040: LOB was already closed.

could somebody explain what this means?

2

In my code, I make the connection to the database, receive in the data by doing a query and return from the keyword. then i close the connection.
Am I doing in the wrong order?

3

Hi Bao Tam,

This:

And this:

Seem unrelated, reading values from html content shouldn’t give you a database error?

It would be helpful if you mentioned which library you’re using and also show the line that gave you the error with the preceding lines for context.

So with no context all I can give you is a generic answer, it seems this message is telling you that your trying to read a value from a database after you closed the database connection.

if you load the html email manually do you get this error in the html? if so that would indicate an application issue in which case nothing you do in robot framework will change that.

Hope that helps,

Dave.