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.
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
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!
As we don't do rollover process, I don't know how to do this.
but I think since the process involved t_promotion, and this table do need an appeal_no.
so I think you do need to put something in the appeal name field.
also based on help file, t_promotion table is on the list.
so maybe what you should do is fill the blank and try again.
Column
Table
Action
Formula
All
T_PROMOTION
Insert
if no promotion record exists for the selected source_no