SAP Knowledge Base Article - Preview

2488066 - rs_subcmp not execute the convert function of RSELECT statement in replicate database - SRS

Symptom

  • Run rs_subcmp to compare two tables and get some unexpected results.   
  • Convert function convert(char(25),BalanceDate,102) as BalanceDate is used on a datetime column in PSELECT and RSELECT. 
  • The date of 'BalanceDate' is not getting converted in replicate database.

    ./rs_subcmp -f subcmp.cfg
    INCONSISTENT ROWS:
    _________Replicate row________
    IID     Fund  MT  Cost    Cash    TradeCash  Units   BalanceDate         
    --------------------------------------------------------------------------
    267334  01    1   0.0000  0.0000  0.0000     0.0000  Apr 21 2016  1:54PM 

    __________Primary row_________
    IID     Fund  MT  Cost    Cash    TradeCash  Units   BalanceDate 
    ------------------------------------------------------------------
    267334  01    1   0.0000  0.0000  0.0000     0.0000  2013.10.08 

    Please notice BalanceDate which got converted in primary but not in replicate site.    


Read more...

Environment

SAP Replication Server all versions

Product

SAP Replication Server all versions

Keywords

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

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.