18
Views
6
Comments
Solved
Error in Database when i try to upload a new item on my page.
Question
Service Studio Version
11.54.21 (Build 62708)

Hello there, I am trying to solve this problem, but I'm creating new problems, so I need some help. This occurs when I try to post a new item with a different user than mine. It's supposed that the new item is related to the user who is uploading. 

Solution

Have you tried to debug?

Have you tried to see which value are you passing?

Are you passing the right user ID?

Check if you are not passing 0 or if you are trying to create something which is already there if you are using just the create function.

Let me know! or share an OML to have a look

also, there's lots of these errors in the forums, you can take some idea on how to tackle this


Solution

Hello,

The foreign key in your entity is missing here that's why this error.

Try to search the create or update logic of this entity  and its assignement, you may not assigned the user id to this entity's foreign key of user id.

Assigne this and error will go.

Hope this helps,

Komal

thank you, this is exactly what was wrong.

Glad you got the issue and its sorted now.

Solution

Have you tried to debug?

Have you tried to see which value are you passing?

Are you passing the right user ID?

Check if you are not passing 0 or if you are trying to create something which is already there if you are using just the create function.

Let me know! or share an OML to have a look

also, there's lots of these errors in the forums, you can take some idea on how to tackle this


hello,  the problem seems to be on useridentifier column, the value that she has does not exist on the dbo_ossys_user column id

Solution

Hello,

The foreign key in your entity is missing here that's why this error.

Try to search the create or update logic of this entity  and its assignement, you may not assigned the user id to this entity's foreign key of user id.

Assigne this and error will go.

Hope this helps,

Komal

thank you, this is exactly what was wrong.

Glad you got the issue and its sorted now.

Hi Francisco Pére,

Look like you have missed the Identifier value if not the data may be not exist in the user table

Check your assign statement of the entity server action create or update part. The Identifier properly mapped. . 


Regards,

Seetha Saravanan.


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.