Robbie Chandra
Rank: #21408
14Views
2Comments
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?

0
0
on 2020-10-09
Copy link to comment
Shilpa Uppund
Rank: #1324
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

0
0
on 2020-10-13
Copy link to comment

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


0
0
on 2020-10-13
Copy link to comment