cancel
Showing results for 
Search instead for 
Did you mean: 

Is the replication_error procedure actually called twice

JimDiaz
Participant
0 Kudos
422

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

Accepted Solutions (0)

Answers (1)

Answers (1)

VolkerBarth
Contributor

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.

JimDiaz
Participant
0 Kudos

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

Jim