Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Working with TransactionNotification stored procedure

Hello all,

Following some threads I've tried to work out a test with the TransactionNotification stored procedure.

However I do not seem to get it to work as I hoped.

- If I add a small test query in the stored procedure and make some changes in SBO, the query is executed perfectly.

- My target query (rather large) can be ran manually and works perfectly.

- If I add my target query to the stored procedure, nothing happens.

- If I addres the same stored procedure through Access it does execute perfeclty (and runs the target query)

What am I missing here?

Thanks for your help

Former Member
Former Member replied

I have found that errors encountered during TransactionNotification are ignored no matter how severe. Try "evolving" from the very simple query that works into your final query slowly to see where the problem begins. Or maybe you can add debug code to your query that inserts rows into a debug table or something so you can see how far your query got before failing.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question