SAP Note 339932 - Termination with invalid BCD number in developer trace

Component : DB Independent Database Interface - Oracle

Solution : https://service.sap.com/sap/support/notes/339932 (SAP Service marketplace login required)

Summary :
This SAP Note addresses two main issues related to incorrect handling of NUMBER data types in SAP applications, causing system terminations with 'DBIF_RSQL_INVALID_REQUEST' errors. The problems are primarily due to the improper conversion between ABAP's packed numbers (type 'P') and Oracle's internal number format. Those conversions fail when the application tries to process invalid packed or decimal numbers. SAP versions prior to Kernel Release 4.6D lack a rigorous validation during these conversions, resulting in unnoticed erroneous data handling. Solutions include updating the database library for older versions and employing provided SAP reports ('SDBI_CHECK_ORANUMBERS', 'ZNUMCHECK') to identify and correct records with invalid data, ensuring data integrity and operational consistency during migration and transport processes.

Key words :
software component   sap_basis                      sap basis compo, #recordsp_corr      automatically correctp_tables    tablep_verbos     detailed log, log byk=> current sql statement exceeds, 46d database library patch level 241, 003 invalid numbers found in004 tables, error => number -> bcd conversion failed, type012 sql error occurred, 0xd denotes negative numbers, 014 numbers in015 rows checked, valid bcd number consists

Related Notes :

1605351SDBI_CHECK_ORANUMBERS: Short dump due to conversion exit
1364196DBIF_RSQL_INVALID_RSQL when converting T5D1M
700486Testing tables for incorrect BCD numbers
428491Copy Management: Error due to automatic data enhancement
420828
416106Termination w/ upgrade in program DEPRECIATION_METHODS_FILL
400818Information about the R/3 database library
392453
206523CC-RELEASE: Client copy errors in 4.6C and 4.6D
161495CC-RELEASE: Error in client copy in 4.6A and 4.6B
96296CC-ERROR: Database problem in client copy
22514CC-INFO: Error analysis for client copy