• Replies 10 replies
  • Subscribers 337 subscribers
  • Views 63 views
  • Users 0 members are here
Related

Default Source_no Not Active

Frances O'Connell
$organization

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

  • $organization

    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...).

  • $organization in reply to Boann Petersen

    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!

    Frannie

  • Former Member
    Former Member $organization

    Does your web config file specify the source number any place?

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell
    Sent: Monday, July 23, 2012 5:59 PM
    To: Gloria Ormsby
    Subject: Re: [Tessitura Technical Forum] Default Source_no Not Active

     

    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!

    Frannie

    From: Boann Petersen <bounce-boannpetersen5924@tessituranetwork.com>
    Sent: 7/23/2012 4:45:06 PM

    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...).




    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!

  • $organization in reply to Frances O'Connell

    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'...

  • $organization in reply to Boann Petersen

    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!

  • Former Member
    Former Member $organization

    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!

  • $organization in reply to Former Member

    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!

    Frannie

  • $organization in reply to Frances O'Connell

    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!

  • $organization in reply to Frances O'Connell

    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!

  • $organization in reply to Boann Petersen

    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!

    Frannie