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
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.
SAP Knowledge Base Article - Preview