Hi there,
I recently changed our Default Source_no for the new Fiscal Year Campaign in T_DEFAULTS. Our web developers have created a new page for Subs on sale and receive the following code:
Exception caught. Message: [System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Default Source_no value is not an Active Source_no%0a at Tessitura.WebAPI.Tessitura.LoginDirect(String sSessionKey, String sUID, String sPwd, Int32 iLoginType, LoginAttemptHeader& loginHeader)%0a at Tessitura.WebAPI.Tessitura.Login(String sSessionKey, String sUID, String sPwd, Int32 iLoginType)%0a
The Source and Appeal are both Open and Active. Is there another area that is affected or needs to be updated to make the source valid for the web?
Funny thing is I changed this about 2.5 weeks ago and it hasn't been a problem until now the launch of the new page...
Thank you!!
Frannie
First, there are two source numbers in the T_DEFAULTS. One is for the web. Make sure that is the one you look at.
Your web config file is located at the root of your website. Maybe you can ask your developer if you’re not familiar with it.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell Sent: Tuesday, July 24, 2012 12:18 PM To: Gloria Ormsby Subject: Re: [Tessitura Technical Forum] Default Source_no Not Active
Boann - yes, it is the same source number as in T_DEFAULTS. I've checked it about 20 times to make sure, knowing how stupid I would feel if I was off a digit - but I'm, 100% it's one and the same...
Gloria - can you explain what you mean by web config file?
Thanks both!
From: Boann Petersen <bounce-boannpetersen5924@tessituranetwork.com> Sent: 7/23/2012 5:06:23 PM
Here is one of those 'is it plugged in' quetions, but have you confirmed that you have the correct source in t_defaults? I often suffer from 'fat fingers'...
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!
Ah yes - I see what you mean about the two default source numbers - I did get the Web one though so that is not the problem.
I will go to our web developers - they are out of house - to see if they can check the config file.
Thank you so much!
This still plagues us - our Web Developers have come back to me with a new error when running tests against our API -
X-DEBUG: IsSiteOnline:Begin X-DEBUG: IsSiteOnline:End. Result True X-DEBUG: [2012-07-29T09:03:06.4482500-04:00] - Calling USer.login with [ASLMB8KNJRB1172L127HLICR8ROXO8GSWG15BIIJ9D9E9SMR4HUI7PQU0EJB8711], [anonymous@nycopera.com],[cb45rfh6xz],[1] X-DEBUG: [2012-07-29T09:03:06.5576250-04:00] - Exception caught. Message: [System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Default Source_no value is not an Active Source_no%0a at Tessitura.WebAPI.Tessitura.LoginDirect(String sSessionKey, String sUID, String sPwd, Int32 iLoginType, LoginAttemptHeader& loginHeader)%0a at Tessitura.WebAPI.Tessitura.Login(String sSessionKey, String sUID, String sPwd, Int32 iLoginType)%0a --- End of inner exception stack trace ---] X-DEBUG: [2012-07-29T09:03:06.5576250-04:00] - Calling : this.Validator.Add(SignIn,Connect); [SignIn]
Any ideas still welcomed.. thank you all!
Can you log in as the web user and sell a ticket with your default source code? If you can then there is a setting somewhere on the web side that is still referring to an old source. If you can't then there is something about the new source that the web account does not like. It is not a definitive answer, but at least will point you to which side of the application to look in.
Good luck!
I think I fixed it by changing our default source number in Test Tess to the new Campaign. We haven't copied over the database since last season and the source number hadn't been changed in T_DEFAULTS. Not sure why Test would affect what they were doing, but I told our developer I changed it and he said it now works...
Anyway, thanks to all for all the input!