Error inserting form into ticket
Problem reported by Brian Davidson - 6/19/2020 at 4:07 AM
I am testing the latest version of SmarterTrack and have a bizarre issue. I can not insert a form into a new ticket. When I try to do so I get an error window with the title "Send Form" and a reference to the logs. However, if we have an existing ticket and reply, inserting the form works as expected. 

The error message is, in part: 

System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_st_FormOffered_st_Tickets". The conflict occurred in database "smarterTrack", table "dbo.st_Tickets", column 'TicketID'.
The statement has been terminated.
Since we are trialing ST, I even tried a complete re-installation with a new database and get the same result. it seems the system needs an existing ticket number before it can insert a form?

Reply to Thread