I have a record on which both addresses on the address tab are marked as primary. I have also seen records where multiple email addresses are marked as primary. How does this happen? The account I am looking at has been merged but it's hard to tell from the audit what exactly happened.
I need to inactivate one of the addresses...but the system will not allow me to inactive the primary address.
Has anyone encountered this before?
Becci Brace - TN PAC
Thanks for the quick reply!
When I click on the primary address checkbox, nothing happens. I am unable to uncheck the primary address flag and I am in system admin user group.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei Sent: Wednesday, November 10, 2010 2:21 PM To: Becci Brace Subject: Re: [Tessitura Technical Forum] Both addresses are marked as 'primary'
The rules which enforce the "one primary address per constituent" are built into the application itself but are not enforced in the SQL database. In the past when I've seen this pop up it is because a script was run in the database itself which set the primary flag incorrectly.
If you have a Tessitura admin around who has access to the database they should be able to provide a list of records that are affected by the problem.
To correct it from within Tessitura, you should be able to uncheck the primary flag on the affected address (or email) and then save the record. Then you would edit the record a second time to inactivate that address.
From: Becci Brace <bounce-beccistrickland7719@tessituranetwork.com> Sent: 11/10/2010 2:06:23 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Becci -
We have this happen to us when the following scenario occurs:
Our box office creates a new address and changes the primary address for credit card billing purposesOur custom script to fix addresses gets run in SQL and changes the address in our databaseThe box office does not refresh the address screen and changes the primary address back to the original addressThey get an error message about needing to refresh the address data as it is more current in the database
Presto, we have multiple primary addresses.
The way I fix it is through SQL. Unfortunately, we've not found a way to do it through the front end (I could write a custom report, but it's just easier for me to quickly fix it).
Heather