2515028 - Bulk copy allows NaN and InF to be inserted into float and real columns - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2515028 - Bulk copy allows NaN and InF to be inserted into float and real columns - SAP ASE

Symptom

  • NaN (not a number) or InF (infinity) was inserted into the primary ASE server using the bulk library routine.
  • ASE does not raise any error.
  • If the data is setup to be replicated into other target server, the following error can be found in the SRS errorlog:
    E. 2017/08/03 08:51:16. ERROR #32061 DIST(104 repASE.baddb) - de/generic/nrm/nrm.c(12604)
    Literal 'nan.0' cannot be converted to native datatype 'float' (val_name 'b')

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Replication Server (SRS)
  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
    • Open Client Client-Library
    • ctlib
    • jConnect
      • JDBC 7.07
      • JDBC 16 (is version 7.07)
    • java

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

CR773230, CR#773230, 773230, 32061, real, datatype, NaN, InF, float, CR813566, CR# 813566, CR#813566, CR813806, CR#813806, CR# 813806 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-SDK , SDK , Bug Filed

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.