Both addresses are marked as 'primary'

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.

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.

Most likely a conversion issue, which I’ve seen on several occasions.  To fix this issue within Tessitura, try this.  If you only have two addresses and BOTH are marked as Primary.  Add a temporary THIRD address, make this one primary.  It will uncheck the other addresses.  Save the records.  Then check the correct primary and delete the temporary address.

This should work for both Addresses and EAdddresses.

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
Sent: Wednesday, November 10, 2010 3:21 PM
To: Ryan Creps
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.

Thanks!  Could you share the SQL fix with me?  I’m down a DBA at the moment, but want to tuck the solution away for future use.

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 purposes
Our custom script to fix addresses gets run in SQL and changes the address in our database
The box office does not refresh the address screen and changes the primary address back to the original address
They 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