Error — Current thread does not have an open read transaction

  • Do you receive the error — The current thread does not have an open read transaction — when trying to Refresh a table with prompt?

Problem

I am currently seeing the error shown below in Spotfire 7.9.1 when I try to Refresh tables with prompt.

Error message

Cause

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.

Cause of error

And here, you can see the Replace value transformation in the Data Panel Source View.  Error in data panel

 

Workaround

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!

2 thoughts on “Error — Current thread does not have an open read transaction

    1. Support says they may NOT put out a hotfix because the issue is fixed in 7.11, but that’s not definite, just a possibility.

Leave a Comment

Your email address will not be published. Required fields are marked *