- Do you receive the error — The current thread does not have an open read transaction — when trying to Refresh a table with prompt?
I am currently seeing the error shown below in Spotfire 7.9.1 when I try to Refresh tables with prompt.
I’ve spent a lot of time on the phone with TIBCO support on this issue. We have finally figured out the culprit is the Replace Values transformations that I added via the Data Panel. In case you aren’t familiar with this feature (now a bug), double-click on a cell of data. You may double-click in either the Data Panel, the Details on Demand Panel, or a Table Visualization. A menu will appear allowing you to replace that value. I’ll put up a more detailed post on this feature shortly with a link, but for now, here are the screenshots after double clicking to change a value.
The temporary workaround is to remove the transformation and use a case or If statement in an expression instead. Now that TIBCO knows about this error, hopefully, they will deploy a hotfix shortly. When they do, I will update the post.
Guest Spotfire blogger residing in Whitefish, MT. Working for SM Energy’s Advanced Analytics and Emerging Technology team!