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