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
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.