14
Views
2
Comments
Solved
Room Service Booking Assigments eror request
Question

Why its when press request button it says "The INSERT statement conflicted with the FOREIGN KEY constraint "OSFRK_OSUSR_OCK_ROOMSERVICE_OSUSR_OCK_ROOMSERVICETYPE_ROOMSERVICETYPE". The conflict occurred in database "HHWW7G029", table "dbo.OSUSR_OCK_ROOMSERVICETYPE", column 'ID'. The statement has been terminated. "

did you know why this?

Rank: #2371
Solution

Hi Robbie,

I think its because there is no value passed for RoomServiceType and it is expecting a value for it.

Can you provide more details.


Regards,

Shilpa Uppund

Hi Robbie,

Like Shilpa Uppund said, I think it might be that ou are trying to create a record in the entity, but this entity (ROOMSERVICE) has a mandatory Foreign Key (ROOMSERVICE TYPE) that likely is not being provided, or the value provided does not match one in the RoomServiceType entity.

Check your action flow and see what information you are passing for the RoomServiceType of that record.

Hope it helped,

Clarisse