Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

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

asked 17 Sep '23, 08:38

J%20Diaz's gravatar image

J Diaz
1.2k414968
accept rate: 10%


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%20Barth's gravatar image

Volker Barth
40.4k365553826
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
Your answer
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

Question tags:

×60

question asked: 17 Sep '23, 08:38

question was seen: 287 times

last updated: 18 Sep '23, 06:39