E.g.:
If it helps, my response was submitted for Version 15.1.13.
Hi Gawain -
For what it's worth the database ships with no index on that column. Not sure why it would exist (twice?) in your database.
Thanks,Patrick
My suspicion is that it won't be version specific. We're 15.1.17.
Yeah: Brian Pedaci somehow zeroed in on this while researching extreme blocking happening on our system (Thanks Brian!). If I had to guess I would say that having two was the issue. Unfortunately, there's nothing in the way of an audit trail on indexes, so we have no idea when they were created, or by whom. I'm idly guessing that one of our third-party integrators did it, but I have no clear evidence. That said, issues started appearing mid-morning yesterday, although they weren't crippling until this morning. Either it was a change then, or perhaps it was only now catching up with us.
None for me on 15.1.16. Looks like something/someone added it first with a typo, then fixed the typo and re-executed, causing the duplication.
That seems like a good possibility, although if you create indexes through the GUI I think they may do some of that awkward truncation as well.
Well this is fun... The database really doesn't ship with an index on that column?
Nancy Sheleheda (She/Her/Hers) (What's this?)Sr. Director of Application Development and Support ServicesPittsburgh Cultural Trust803 Liberty Avenue, Pittsburgh, Pa 15222412-456-1387 Sheleheda@trustarts.org | TrustArts.org
Here we go! Jennifer, I sent you a message with some of my suspicions, in case we share any particular integrations.
So, Jennifer and I seem to share two extensions: both Tessitura:
Also, I know that our Entitlements installation has been...fraught. We were an early adopter, and recently requested an update, but that update has been interrupted on numerous occasions, and we are still trying to square away the Entitlements TNEW plugin.
[EXTERNAL] Update from Tessitura Network Gawain Lavers So, Jennifer and I seem to share two extensions: both Tessitura: TNEW Education Customization (for booking classes and camps)Entitlements Also, I know that our Entitlements installation has been...fraught. We were an early adopter, and recently requested an update, but that update has been interrupted on numerous occasions, and we are still trying to square away the Entitlements TNEW plugin. View online You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here. Flag this post as spam/abuse.
View online
You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here.
Flag this post as spam/abuse.
Marty Jones, who's updating our Entitlements TNEW Plugin did some digging and found no reference to index generation (outside of custom tables) in any of the Entitlement installation scripts he had.
Does anyone know of a way to figure out any creation information (user, date) for indexes through SSMS?
Interesting... Has anyone looked at the education customization, per chance?