Cannot insert duplicate key row in object with unique index . The duplicate key value. The statement has been terminated

Solution 1:

Open the Indexes tree under your table. You will find an Index named 'OSIDX_OSUSR_6SL_RIDER_4NAME'.

Script out that Index and you will see that it is a UNIQUE index on a "name" column that you are trying to create a duplicate value in.

You must either change that Index to include Route and Bus ID, or you must abandon your attempt to create a new row with a duplicate name.