solidDB Help : solidDB reference : SQL: System stored procedures : System stored procedures for Advanced Replication : SYNC_DELETE_REPLICA_MESSAGES
  
SYNC_DELETE_REPLICA_MESSAGES
The SYNC_DELETE_REPLICA_MESSAGES system stored procedure deletes the messages of a specified replica in the master database. There might be several hanging messages if a replica application creates messages and does not check and handle errors properly.
CALL SYNC_DELETE_REPLICA_MESSAGES(
master_catalog_name -- WVARCHAR,
replica_name -- WVARCHAR )
EXECUTES ON: master.
You must have administrator or synchronization administrator access rights to execute this stored procedure.
The master_catalog_name parameter specifies the catalog in the master database from which the messages of the specified replica are searched. If master_catalog_name is set to NULL, the current catalog is used.
This procedure does not return a result set.
The possible return codes are listed in the following table:
 
Code
Text
Description
13047
No privilege for operation
 
13133
Not a valid license for this product.
 
25005
Message is already active.
 
25009
Replica not found.
 
25019
Database is not a replica database
 
25020
Database is not a master database.
 
25035
Message is in use.
 
Go up to
System stored procedures for Advanced Replication