Integrity constraint error

Hi @all

I am facing an error when I click on create button.

See the attachment of server action values mapping and error msg.

How to solve this problem? What should I do?


errorcreatebutton.PNG

Solution

Hello Rohan,

I hope you are great mate.

Adding to the Jose answer please refer below link for more information,

https://www.outsystems.com/forums/discussion/63883/oracle-error/

ORA-02291 is typically accompanied with the message, “integrity constraint <constraint name> violated – parent key not found”. This means that you attempted to execute a reference to a certain table using a primary key. However, in the process of doing so, the columns that you specified failed to match the primary key. 

http://www.dba-oracle.com/t_ora_02291_integrity_constraint_string_string_violated_parent_key_not_found.htm

Kind Regards,

Ajit kurane.

Hi Rohan,

at first glance, it looks like you are assigning a CampaignId value that doesn't exist in the database.

That may happen if you are calling a Service Action after inserting the CampaignId. Since the Service Action will happen in a different transaction, that newly created Campaign still doesn't exist inside Service Action transaction.

Regards

Solution

Hello Rohan,

I hope you are great mate.

Adding to the Jose answer please refer below link for more information,

https://www.outsystems.com/forums/discussion/63883/oracle-error/

ORA-02291 is typically accompanied with the message, “integrity constraint <constraint name> violated – parent key not found”. This means that you attempted to execute a reference to a certain table using a primary key. However, in the process of doing so, the columns that you specified failed to match the primary key. 

http://www.dba-oracle.com/t_ora_02291_integrity_constraint_string_string_violated_parent_key_not_found.htm

Kind Regards,

Ajit kurane.

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