SQL translation

Kevin

Thank you for the reply. We tested all our rollovers again this morning and everything has worked!! 

So I have no idea what all that was about now.

 

Cheer

 

(03) 6232 4404

 

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,

 

 

 

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

 

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

 

 

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!

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!

Kevin

Thank you for the reply. We tested all our rollovers again this morning and everything has worked!! 

So I have no idea what all that was about now.

 

Cheer

 

(03) 6232 4404

 

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,

 

 

 

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

 

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

 

 

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!

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!