report error with same table name and different mysql databases

[1257661467]

I created two report from two Ad Hoc Views, A and B. The two Ad Hoc Views are created from two domains base on MySQL data source which have different database names and same table name. The two table have same structure but different data.

Different data are showed when showing the two Ad Hoc Views. However, if I showed Ad hoc Report A first, and then showed  Ad hoc Report B, the two report showed same data from Ad hoc View A.

how to show different data from different Ad hoc Report without cleaning cache.

[1257661467]

temp solution is to clean ad hoc cache, but it is not confortable to use for client.

[yama818]

I was having the same problem.

It used to work correctly in the past (at least up to 6.2.0) because it included information about the data source to determine whether to use the cache or not.
However, from some version, the decision was made based on SQL only.
A patch has been released for the current commercial version 7.5.1, so applying the latest patch should solve the problem.
It may also be resolved by upgrading to 7.8.0 or higher.

I hope this is helpful.

 

[1257661467]

How to get and apply the patch for current commercial version 7.5.1? Recently, we have no plan to upgrade to version 7.8.0 and keep version 7.5.1.

[yama818]

If you have a maintenance contract, you should be able to receive the hotfix release email.
I received it on 2021/07/14.
You can download it from the link in the email.
(hotfix_JRSPro7.5.1_cumulative_20210712_1319.zip)
If you have any questions about hotfix, it would be better to contact TIBCO staff.