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 for Me (Login required).

Search for additional results

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