SAP Knowledge Base Article - Preview

2329204 - Arithmetic overflow occurred when calling two user define functions - SAP ASE

Symptom

  • Run the two SQL statements in the following order, different errors are reported on ASE 15.7 SP136 and ASE 16.0:

select dbo._validate_iban(' ')
select dbo._validate_iban('BE58973134698779')

1. in ASE 15.7 SP136, the second call gives the 'arithmetic overflow' error.
2. in ASE 16 SP02PL03, the second call encounter signal 11 and ASE server crashed with this signal 11.

  • For ASE 15.7 SP136:

1> select dbo._validate_iban(' ')
2> select dbo._validate_iban('BE58973134698779')
3> go
                                                                                                     
 ----------------------------------------------------------------------------------------------------
 Fout

(1 row affected)
Msg 3606, Level 16, State 0:
Server 'test_157', Procedure '_validate_iban', Line 20:
Arithmetic overflow occurred.

    • For ASE 16 SP02 PL03:
              
            Receive "Infected with signal 11" in the com__exctnume_copy() module with stack trace:

Current process (0x250013) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001f4f8c7 (com__exctnume_copy+0x77), siginfo (code, address) = (1, 0x0x0000000151702000)

Modules seen on the ASE stacktrace include:

com__exctnume_copy
mod_numeric
LeRun


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7 SP136
  • SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

com__exctnume_copy,Msg 3606,Arithmetic overflow , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.