We have a view that is failing with a 'Cannot perform this operation on
an open dataset' error. Running the query behind the view with the same
WHERE clause works fine. I isolated the problem down to one row in one
table, if the query excludes that row there is no problem. Gfix -v
reports no errors, -l reports no limbo transactions. I ran a sweep and
restarted the database just for grins, but that didn't help.

Our TX info looks good:

Oldest transaction 2900336
Oldest active 2900337
Oldest snapshot 2900337
Next transaction 2900338

I'm stumped. The next step is to delete the offending row and insert it
again.

Rick DeBay
Senior Software Developer
RxStrategies.net