SAP Knowledge Base Article - Preview

2420658 - Alter compareset is not updating as expected - Data Assurance

Symptom

Data Assurance (DA) 'alter compareset' is not updating:

1> show compareset p_titles
2> go
TYPE CONNECTION     OWNER TABLE  WHERE CONSTRAINT
---- -------------- ----- ------ ----------------
S    conn_server1          dbo     titles
T    conn_server2          dbo     titles

1> alter compareset p_titles
2>         add target conn_server3 dbo titles tr_titles
3>         map
4>         source.title_id=tr_titles.title_id set key=true
5>                 and source.title=tr_titles.title
6>                 and source.type=tr_titles.type
7>                 and source.pub_id=tr_titles.pub_id
8>                 and source.price=tr_titles.price
9>                 and source.advance=tr_titles.advance
10>                 and source.total_sales=tr_titles.total_sales
11>                 and source.notes=tr_titles.notes
12>                 and source.pubdate=tr_titles.pubdate
13>                 and source.contract=tr_titles.contract
14> go
The compareset "p_titles" is referenced by job/comparison(s)
"job_titles/cmp_titles".
(0 rows affected)

1> show compareset p_titles
2> go
TYPE CONNECTION     OWNER TABLE  WHERE CONSTRAINT
---- -------------- ----- ------ ----------------
S    conn_server1          dbo     titles
T    conn_server2          dbo     titles

 


Read more...

Environment

SAP Replication Server (SRS) Data Assurance all versions

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.