SAP Knowledge Base Article - Preview

2654265 - Data Assurance is not comparing floats correctly - SRS

Symptom

In Data Assurance (DA), comparing data sets from SAP Adaptive Server Enterprise (ASE) to SAP IQ (IQ), float data with high precision is not reconciled.

  • From IQ:

select * from test_float
go

         id                                  a                                       b                                          c                         d
----------- --------------------------- -------------------------------      ----------------------------   ------------------
          1                     182.27972          182.27972650000000         182.279726499999980           182.27972

  • From ASE:

select * from test_float
go

       id                                  a                                       b                                            c                         d
----------- --------------------------- -------------------------------      ----------------------------   ------------------
           1                  182.279726           182.27972649999998         182.279726499999980         182.279724

  • After the comparison, the data in IQ is not reconciled.
  • The same problem may exists with other systems, for example:
    • ASE to ASE on a different Operating System Platform
    • ASE to Oracle


Read more...

Environment

SAP Replication Server (SRS) Data Assurance (DA) Option, version 15.7.1 SP 306

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed

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.