Jump to content
  • 0
Sign in to follow this  
Carioca

Record cannot be saved because an error was encountered in Triggered Actions

Question

I am creating an on insert trigger for my table but upon testing, I got this error.

image.png.ac46b17b8a811177a56f46651b67cd49.png

 

Modified the trigger to a simple insert like this:

image.png.b33b9e6fb337b09acd50877f686f4664.png

 

However, the error still persists.

Does anyone encounter the same issue? Any help would be greatly appreciated.

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 1

Please ensure that you don't have referential integrity enabled in you table relationship.

According to the note in https://howto.caspio.com/tables-and-views/triggered-actions/:

Quote

In the case of referential integrity enabled in a relationship, if a trigger executes on an insert event to the parent table, and inserts a record to the child table, the Triggered Action will fail. This is due to the action of inserting a record to the child table occurring first, thus failing the integrity check as the parent record does not yet exist.

 

Share this post


Link to post
Share on other sites
  • 0

Thank you! You're right, I have referential integrity enabled in my table relationship. I've disabled it and not receiving the error anymore.

1 hour ago, AtayBalunbalunan said:

Please ensure that you don't have referential integrity enabled in you table relationship.

According to the note in https://howto.caspio.com/tables-and-views/triggered-actions/:

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...