SAP Knowledge Base Article - Preview

2490803 - Data Column with timestamp Type inserted with NULL in a Replication Warm Standby environment using HAVAR option

Symptom

  • Warm Standby Environment
  • HVAR enabled
  • Table defined in source SAP ASE Server without timestamp datatype
  • Table defined in replicated SAP ASE Server with a timestamp datatype
  • Massive insert into Table with number of rows inserted above the limit defined in "dsi_bulk_threshold" SAP RS parameter
  • Result Set from Table in replicated database:

 1> select * from tbl1
 2> go
 a           b                    c                 
 ----------- -------------------- ------------------
           1 a                    NULL              
           2 b                    NULL              
           3 c                    NULL              
           4 d                    NULL              
           5 e                    NULL              
           6 f                    NULL              
           7 g                    NULL              
           8 h                    NULL              
           9 i                    NULL              
          10 j                    NULL              
          11 a                    NULL              
          12 b                    NULL              
          13 c                    NULL              
          14 d                    NULL              
          15 e                    NULL              
          16 f                    NULL              
          17 g                    NULL              
          18 h                    NULL              
          19 i                    NULL              
          20 j                    NULL              
          21 a                    NULL              
          22 b                    NULL              
          23 c                    NULL              
          24 d                    NULL              
          25 e                    NULL              
          26 f                    NULL              
          27 g                    NULL              
          28 h                    NULL              
          29 i                    NULL              
          30 j                    NULL

(30 rows affected)


Read more...

Environment

  • SAP Replication Server (RS) 15.7
  • SAP Adaptive Server Enterprise (ASE) 15.0 or higher

 

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

warm standby HVAR timestamp replication dsi_bulk_threshold dsi_compile_enable , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.