Hi there,
We just converted our test environment to v.12 and I'm getting the following error when I try to use the Forgot Login email functionality:
A .NET Framework error occurred during execution of user-defined routine or aggregate "TXP_SEND_CREDENTIALS":
System.Exception: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_T_WEB_SESSION_VARIABLE_t_web_session". The conflict occurred in database "impresario", table "dbo.t_web_session_Session", column 'SessionKey'.
The statement has been terminated.
System.Exception: at TessituraSQLServices.StoredProcedures.SendCredentials(SqlString sAPIAddress, SqlString sOrgName, SqlString sEmail, SqlInt32 iLoginType, SqlBoolean bResetTempFlag, SqlBoolean bUseToken, SqlBoolean bGenerateNewPassword, SqlInt32 iTemplateID)
I'm not seeing any other posts about this error yet. Has anyone gotten this? Seems like we have duplicate session keys? or the tables somehow got out of sync?
any help welcome.
thank you,
frannie
Hi Frances,
We just started testing v12, and I've run into the same error. Did you figure out what the issue was?
Thanks,
Stephen
Hi Stephen,
I think I ended up opening a help ticket with TASK for this one - which I now can't find in my TASK history. We've had a couple different errors around PW resets and we've fixed it before by making sure the entry in T_DEFAULTS for the Web API URL was correct and making sure the Database is set to Trustworthy in SSMS - but I think those were different from this error.
Good luck and I'll let you know if I find anything more helpful..
Frannie