A constituent brought to my attention a strange issue: SendCredentials() is throwing the following error:
TESSITURA_DUPLICATE_LOGIN_EXCEPTION: The login submitted is already associated with an existing account. System.Data.SqlClient.SqlException: New Login is already in use. Please select another login
While SendCredentials() should look up a login based on an email address, it instead seems to be complaining that a login exists for the email address, and then the SqlException implies that it attempted to create a new login.
But besides that, the email address submitted exists only once in T_EADDRESS, its associated customer (via customer_no) only has one login in T_CUST_LOGIN, and that login is the only one with the email's "eaddress_no". I can't figure out what's wrong. Why else would SendCredentials() throw a DUPLICATE_LOGIN_EXCEPTION?
Bryan
In the v10 database it is possible that there are logins in the database with the same login and type. This generally occurs when there is a background process which adds logins. To determine if that is the issue you can run the following SQL on your database. If you get rows returned you have duplicate logins.
select cl1.login, MIN(isnull(cl1.last_login_dt,''))
from [dbo].T_CUST_LOGIN cl1 (nolock)
group by cl1.login, cl1.login_type
having COUNT(*) > 1
This issue is part of the data check for the Migration Toolkit for v11 which was released yesterday. If you look at the Migration Toolkit documentation in Appendix 3 you will find two possible resoultions for this issue.
If you find you do not have duplicate logins then I would put in a help ticket on TASK.
Best,
Anna
Anna E. Wessely
Director Special Projects/Senior Application Specialist
Tessitura Network
awessely@tessituranetwork.com