on 2023 Sep 17 9:38 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
9 | |
8 | |
8 | |
7 | |
7 | |
6 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.