Hi everyone,
We noticed that one of our availability reports was significantly off when calculating capacity and available seat counts. After some investigation I found that seat_num and seat_row in TX_PERF_SEAT were NULL for an extra 1760 seats for all performances attached to a specific facility. These seats don’t ‘exist’ in facility manager.
Counts were made accurate by adding a where clause in the SQL that eliminated them, however I’m a little perplexed as to how/why they got that way and if this is normal. Upon further digging, I found that we have thousands of them across a number of facilities.
Has anyone else ever seen this? Should I be concerned about them?
Natasha
Haha... and now I have discovered it. Tash - did you ever come up with anything?
Or, has anyone else seen this behavior?
Hey Frannie,
I meant to put in a support ticket about this, but didn't end up doing so. They didn't seem to be doing any harm, so I just wrote logic to exclude them. Best to put in a ticket if they are now causing issues.
Tash
Still don't seem to be doing any harm. We found another report calculating capacity using TX_PERF_SEAT but I added logic to fix, so I guess it's still ok.
If I ever figure out how it happened, I will update you!
Frannie