Normalization errors

Normalization errors result from transient inconsistencies in the setup of replication objects. For example, if a table has been marked replicated with the sp_setreplicate system procedure, but the replication definition has not yet been created for the table, the RepAgent retrieves log records for an object that is not yet known to the Replication Server. Replication Server error 32032 is displayed in the Replication Server error log:

Message: 32032, ’No table with name ’foo’ is defined for
database with id MY_PDS.MY_PDB1.

Correct this problem by creating the replication definition for the table.

A normalization error can also occur if the replicated stored procedure is declared in the Replication Server for function replication but is marked in the Adaptive Server for table replication. Replication Server error 32047 is displayed in the Replication Server error log:

Message from server: Message: 32047, State 0, Severity
12 -- 'Function 't2' is associated with a function
replication definition, but an invoking stored
procedure was marked for a table replication
definition.'.

See the Replication Server Administration Guide Volume 1 for instructions on setting up replication definitions.