• Replies 5 replies
  • Subscribers 337 subscribers
  • Views 53 views
  • Users 0 members are here
Related

SQL translation

Darrell Jones
$organization

Hello all,

I'm attempting to TEST a rollover and get this error message.  Can some translated it for me please?

Select Error: SQLSTATE = 2300

Microsoft OLE DB Provider for SQL Server

Cannot insert the value NULL into column 'appeal_no',table 'impresario.dbo.T_PROMOTION';column does not allow nulls.INSERT fails.

Parents
  • $organization

    Hi Darell,

     

    You can leave the source and appeal blank when you do a rollover.  In fact I think that’s the best option because it allows you to enter the appropriate source as each renewal is processed.  Are you sure you have the (leave blank) option selected for both the appeal and source fields on your rollover set? If you do and you are receiving that error you should open a help ticket as something is not working like it should.  If you have the (create on demand) option selected, though, you will definitely get an error.  (create on demand) is an option that really almost no one uses and requires having pre-populated some tables with source information that the rollover uses.

     

    Hope that helps,

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Darrell Jones
    Sent: Friday, September 10, 2010 2:42 AM
    To: Kevin Sheehan
    Subject: RE: [Tessitura Technical Forum] SQL translation

     

    Hi Ben

     

    I can read the words but it’s the intended meaning  that needs translating – I don’t SQL and have no idea what a sql

    profiler is -  I was testing a rollover. does appeal_no  relate to the Appeal field in rollover manager? In which case I

    would expect it to be null because “leave blank” is one of the options in the Appeal field and in the Source field, and

    that’s what I intended.

    I am not familiar with t_promotion I thought it might be a system table I could add to my user group  so that I could

    at least see it but that doesn’t seem to be an option.

     

     

    Darrell Jones

    Assistant Box Office Coordinator

     

    Tasmanian Symphony Orchestra

    GPO Box 1450

    HOBART

    Tasmania 7001

    (03) 6232 4404

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ben Gu
    Sent: Friday, 10 September 2010 3:51 PM
    To: Darrell Jones
    Subject: Re: [Tessitura Technical Forum] SQL translation

     

    Hi Darrell,

    Good day.

    it means you tried to insert a null value into t_promotion table. because in t_promotion table, field appeal_no is a  (int not null) field, then you got this error message.

    if you open a sql profiler try to catch the sql statement, then you can see what had happened.

    have fun

    Ben

     

     

    From: Darrell Jones <bounce-darrelljones8445@tessituranetwork.com>
    Sent: 9/9/2010 10:50:29 PM

    Hello all,

    I'm attempting to TEST a rollover and get this error message.  Can some translated it for me please?

    Select Error: SQLSTATE = 2300

    Microsoft OLE DB Provider for SQL Server

    Cannot insert the value NULL into column 'appeal_no',table 'impresario.dbo.T_PROMOTION';column does not allow nulls.INSERT fails.




    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!




    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!

Reply
  • $organization

    Hi Darell,

     

    You can leave the source and appeal blank when you do a rollover.  In fact I think that’s the best option because it allows you to enter the appropriate source as each renewal is processed.  Are you sure you have the (leave blank) option selected for both the appeal and source fields on your rollover set? If you do and you are receiving that error you should open a help ticket as something is not working like it should.  If you have the (create on demand) option selected, though, you will definitely get an error.  (create on demand) is an option that really almost no one uses and requires having pre-populated some tables with source information that the rollover uses.

     

    Hope that helps,

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Darrell Jones
    Sent: Friday, September 10, 2010 2:42 AM
    To: Kevin Sheehan
    Subject: RE: [Tessitura Technical Forum] SQL translation

     

    Hi Ben

     

    I can read the words but it’s the intended meaning  that needs translating – I don’t SQL and have no idea what a sql

    profiler is -  I was testing a rollover. does appeal_no  relate to the Appeal field in rollover manager? In which case I

    would expect it to be null because “leave blank” is one of the options in the Appeal field and in the Source field, and

    that’s what I intended.

    I am not familiar with t_promotion I thought it might be a system table I could add to my user group  so that I could

    at least see it but that doesn’t seem to be an option.

     

     

    Darrell Jones

    Assistant Box Office Coordinator

     

    Tasmanian Symphony Orchestra

    GPO Box 1450

    HOBART

    Tasmania 7001

    (03) 6232 4404

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ben Gu
    Sent: Friday, 10 September 2010 3:51 PM
    To: Darrell Jones
    Subject: Re: [Tessitura Technical Forum] SQL translation

     

    Hi Darrell,

    Good day.

    it means you tried to insert a null value into t_promotion table. because in t_promotion table, field appeal_no is a  (int not null) field, then you got this error message.

    if you open a sql profiler try to catch the sql statement, then you can see what had happened.

    have fun

    Ben

     

     

    From: Darrell Jones <bounce-darrelljones8445@tessituranetwork.com>
    Sent: 9/9/2010 10:50:29 PM

    Hello all,

    I'm attempting to TEST a rollover and get this error message.  Can some translated it for me please?

    Select Error: SQLSTATE = 2300

    Microsoft OLE DB Provider for SQL Server

    Cannot insert the value NULL into column 'appeal_no',table 'impresario.dbo.T_PROMOTION';column does not allow nulls.INSERT fails.




    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!




    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!

Children
No Data