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 for Me (Login required).

Search for additional results

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