SAP Knowledge Base Article - Preview

2671397 - Data Assurance fails to compare Oracle view with HANA table - SRS

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.