Hi In the data dictionary I have run the SQL EXECUTE PROCEDURE sp_CreateEvent( 'schedule_changed', 2 / ADS_EVENT_WITH_DATA / );

On a table called 'schedule.adt' I have added 3 triggers

After Insert = Notification_ScheduleInsert

After Update = Notification_ScheduleUpdate

After Delete = Notification_ScheduleDelete

each have the following trigger defined

EXECUTE PROCEDURE sp_SignalEvent( 'schedule_changed', false, 0);

When a schedule record is updated I get a 5177 error

Can anyone offer advice as to how to resolve this?

I do not know if this has any bearing but we have recently made the following changes 1. Modified the triggers from EXECUTE PROCEDURE sp_SignalEvent( 'schedule_changed', false, 0, ::stmt.trigRowID) to that shown above.

  1. We have run the sp_CreateEvent for a 2nd time.

asked 09 Nov '12, 04:45

Philip%20Jackson's gravatar image

Philip Jackson
402414559
accept rate: 28%

edited 09 Nov '12, 04:47


You can use the SQL debugger in ARC to find out what is causing the 5177 general trigger failure error. This topic in the help file has the detail steps.

link

answered 09 Nov '12, 07:22

Alex%20Wong's gravatar image

Alex Wong
5.3k2488
accept rate: 42%

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×18

Asked: 09 Nov '12, 04:45

Seen: 1,697 times

Last updated: 09 Nov '12, 07:22

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.