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
Make sure that the start and end dates for the soure, appeal and campaign are all active. This catches us almost every year (at least now this is the first place I look...).
Hi BoAnn,
Thanks for your response! I have checked the Campaign, Appeal, and Source dates so many times out of paranoia - but that's not it! They are all set about a week prior to and after the beginning and end of the current fiscal year - none expiring any early than 6/30/13!
Let me know if anyone has any other ideas...
Thank you!
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'...
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!