Symptom
- Comparing data between Oracle View and Hana Table should work but Data Assurance (DA) does not differentiate between tables and views.
- DA appears to be having problems obtaining the metadata for the Oracle view columns
- show compareset columns types confirms that the datatypes are in fact missing for the view
- show compareset <cs_name> columns types
TYPE CONNECTION OWNER TABLE MAPID COLUMN KEY DATA SERVER TYPE PRECISION SCALE KEY/INDEX
---- -------------------------------------- --------- ------------------------ ----- --------------------- --- ------------- -------- --------- ----- --------------
S conn__ORACLE <owner> <Table> 1 MYID #1 <Unavailable>
Read more...
Environment
SAP Replication Server Data Assurance Option 16.0
Product
SAP Replication Server 16.0
Keywords
SRS DA view; compareset; O2H , 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.