Is the replication_error procedure actually called twice

SQL Anywhere 17.0.10.6160

I am testing the implementation of replication error and replication error piece database options. The docs say replication error procedure is called twice once with the error and then again with the SQL statement which caused the error. In my testing I am only seeing the error no SQL statement. I am also not seeing any information from the replication_error_piece procedure.

Thanks in advance.

Jim

replication

asked 17 Sep '23, 08:38

J Diaz
1.2k●40●49●68
accept rate: 10%

flat view

One Answer:

active answers oldest answers newest answers popular answers

FWIW, there's more info in the documentation:

The procedure is called once with the SQL error message and once with the SQL statement that causes the error. In some circumstances (such as foreign key violations), the SQL statement that caused the error is not available, so the stored procedure can only be called once.

Wild guess: I would assume "some circumstance" happened so there is no SQL statement to share and therefore there's no need to split contents between replication_error and replication_errpr_piece.

Just to add: We have used the replication_error option since v8 and almost always got both the error message and the according SQL statement, say with duplicate PKs, violated check constraints and the like.

permanent link

answered 18 Sep '23, 04:09

Volker Barth
40.2k●362●550●822
accept rate: 34%

edited 18 Sep '23, 04:27

Thanks very much this makes sense. I was testing by causing foreign key failures so no sql statement.

Jim

(18 Sep '23, 06:39) J Diaz

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

replication ×60

question asked: 17 Sep '23, 08:38

question was seen: 247 times

last updated: 18 Sep '23, 06:39

SAP SQL Anywhere

Is the replication_error procedure actually called twice

Follow this question

Related questions