For replication to Oracle andĭB2 LAN, dsi_newline_escape should be "off". "dsi_newline_escape" may be set through the following Replication Server syntax:Ĭonfigure replication server set dsi_newline_escape to Īlter connection to set dsi_newline_escape to įor replication to MS SQL and ASE, dsi_newline_escape should be "on". The default value is "on" to match current Replication Server behavior. "dsi_newline_escape" valid values are "on"|"off". This behavior resulted inĭuplicated newline characters in some non-ASE databases.
Replicate databases similar to Sybase ASE would not remove them.
Originally, these characters were escaped such that This property controls when newline characters, contained as a part of theĭata, are escaped in order to preserve them. Such configuration cause "rs_stat_populate" to report "Attempt to insert duplicate key row in object 'rs_statreport' with unique index 'rs_key_statreport'".Ī new configuration property, dsi_escape_newline, has been defined at the Replication Server andĭSI (connection) levels. In the following example, see Connection-ID 144, but as well as Connection-ID 170:ġ> select dbid, dsname, dbname, ltype, ptype, ldbid from rs_databases order by dbid Server 'SYBASE_MEDISREP2', Procedure 'rs_stat_populate_netspd', Line 189:Īttempt to insert duplicate key row in object 'rs_statreport' with unique index 'rs_key_statreport'īecause Customer have setting up a Warm/Standby configuration after he have create the Primary (Active) Connection, the Logical-Connection have the same name ("dsname" and same "dbname") but as well the same Database-ID ("dbid). When Customer populate statistics using "rs_stat_popultae", this store proc call "rs_stat_populate_netspd" which report duplicate key error: The default value should remain as an identity datatype.Ĭreate subscription with atomic materialization puts text data to incorrect row.Ĭustomer is RepServer 15.6 GA under AIX platform.Ĭustomer have installed "rs_install_statreport_v1510_ase.sql". When creating a replication definition, the Replication Manager Plugin incorrectly uses the datatype numeric for identity columns. When resuming replication after changing the MICROSOFT SQL SERVER ONLY: Replication AgentĮncounters a
0 kommentar(er)
