User's Manual

Column Description
pub Current publisher of the database (lets you know at what
database it was inserted)
remoteuser Remote user applying the message (lets you know what
database it came from)
errormsg Error message passed to the Replication_error procedure
Here is a sample insert into the table from the above error:
INSERT INTO cons.replication_audit
( id,
pub,
remoteuser,
errormsg,
"timestamp")
VALUES
( 1,
’cons’,
’sales’,
’primary key for table ’’reptable’’ is not unique (-193)’,
’1997/apr/21 16:03:13.836’)
COMMIT WORK
Since Adaptive Server Anywhere supports calling external DLLs from stored
procedures you can also design a paging system, instead of using Email.
An example of an error For example, if a row is inserted at the consolidated using the same primary
key as one inserted at the remote, the Message Agent displays the following
errors:
Received message from "cons" (0-0000000000-0)
SQL statement failed: (-193) primary key for table
’reptable’ is not unique
INSERT INTO cons.reptable( id,text,last_contact )
VALUES (2,’dave’,’1997/apr/21 16:02:38.325’)
COMMIT WORK
The messages that arrived in Doe, John and Elton, John’s email each had a
subject of SQL Remote Error:
primary key for table ’reptable’ is not unique (-193)
INSERT INTO cons.reptable( id,text,last_contact ) VALUES
(2,’dave’,’1997/apr/21 16:02:52.605’)
248