Column Description
pub Current publisher of the database (lets you know at what
databaseit was inserted)
remoteuser Remote user applying the message (lets you know what
databaseit came from)
errormsg Errormessage passed to the Replication_error procedure
Hereis 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
SinceAdaptive Server Anywhere supports calling external DLLs from stored
proceduresyou can also design a paging system, instead of using Email.
Anexample of an error Forexample, if a row is inserted at the consolidated using the same primary
keyas 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
Themessages that arrived in Doe, John and Elton, John’s email each had a
subjectof 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