SAP Knowledge Base Article - Preview

2607762 - DA can incorrectly report differences in different time zone - SRS Data Assurance

Symptom

Because all table columns are used as the row key,so any inconsistency between two rows will result in DA finding the source row to be missing and the target row to be orphaned.

Using SAP Replication Server (SRS) Data Assurance Option (DA) in different time zones report different dates like these the two deleted and inserted date/time values:

           busEfftvTS                    checkIssueDate

DELETE   '2008-01-16 10:30:03:603PM'   '2007-08-29 12:00:00:000PM'

INSERT   '2008-01-17 11:30:03:603AM'   '2007-08-30 12:00:00:000AM'

                  ^^ ^^          ^^             ^^             ^^

          2nd value 13 hours ahead       2nd value is 12 hours ahead

 One time zone is 12 hours behind the other (13 hours with daylight savings).


Read more...

Environment

SAP Replication Server (SRS) 15.7 Data Assurance Option (DA)

Product

SAP Replication Server 15.7

Keywords

  time zone, DA, Data Assurance , 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.