Prepared statement needs to be re-prepared ?

[qa-auto]

Hi,

Has anyone seen this error after defining a data source?

All my other data sources use selects without joins just fine.

SQL
SELECT distinct ld.loan_id,
th.effective_due_date
FROM trans_hdr th
INNER JOIN vw_loan_data ld ON th.id=ld.hdr_id
INNER JOIN customer c ON th.customer_id=c.id
WHERE th.status_id in (1)
and th.loan_model_id = 459
and th.store_id = '171' order by rand() limit 1;

image (48).png (8.81 KiB) Viewed 173 times

[vseaver]

If you run this sql statement against the SQL database does it work outside of Ranorex?

[qa-auto]

Yes.

In the meantime, I'm writing a work around by using a MySqlDataAdapter to get the result set and then creating a SimpleDataConnector. Not quite finished yet.

Lorinda

[qa-auto]

Cannot move forward now because of this issue:

viewtopic.php?f=13&t=19351&p=65947#p65947

[Jacob]

To add on to this, I did find an open bug in the MariaDB Jira for a similar issue. It looks like it will be addressed in one of the upstream 10.5 releases of MariaDB, but may have been fixed in later versions already. It does seem possible to increase table_definition_cache to bypass this particular issue for the time being, but it may crop up again.

--Jacob

[OliviaParcker23]

that is, in version 10.5 everything is already fine?

[Jacob]

Hi Olivia,

According to the posts in the Jira defect, it seems as though older versions of MariaDB aren't handling the situation as well as 10.5, but it is still possible to encounter the issue in 10.5. From what I can see, we're still waiting on a fix from the MariaDB team.

--Jacob