How To Slove This Problem Plz...

The inserted value(s) specifies an invalid Status
The transaction ended in the trigger. The batch has been aborted.

Hello Everybody, I want to slove this problem when i want to insert data i check some condition before insert data, if condition is true it's can insert but but if it's false i have a button to click for confirm to insert and have this error.Help me plz....this code behindsql_CheckLog = "SET IDENTITY_INSERT Checklog ON INSERT INTO Checklog(ID,customerID,employeeID,StatusID,Type,RecordID"
sql_CheckLog += ",Allowed,AlertFlags,Date,stationID,clubnumber) Values ('" & No & "','" & lblID.Text & "',"
sql_CheckLog += "'" & Request.QueryString("ID").ToString & "'"
sql_CheckLog += ",'" & StatusID & "'"
sql_CheckLog += ",'" & CInt(Type) & "'"
sql_CheckLog += ",'" & CInt(Record) & "'"
sql_CheckLog += ",'" & CInt(allow) & "',"
sql_CheckLog += "'" & TotalAlertCheck & "','" & DateCheck & "','" & station & "','" & CInt(Session("ClubID")) & "')"