Solution : https://service.sap.com/sap/support/notes/1557321 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues related to data overflow errors occurring in various database systems (HANA, Oracle, MS SQL Server, DB6, SAP MaxDB) during specific BW operations such as rollup, compression, and query execution. It provides detailed guidance on identifying and analyzing the problematic SQL statements and key figures contributing to these errors. The errors commonly result from the processed values exceeding the data type limits of database columns. The solution section of the note outlines a systematic approach to trace and resolve these errors, including SQL statement retrieval, key figure identification, and data type verification. It encourages utilizing SE11 and SE14 transactions to assess data types and limits.
Key words :
/400bw-sys-db-db6 bw db2 universal databasebw-sys-db-inf bw informixbw-sys-db-mss bw microsoft sql serverbw-sys-db-ora bw oraclebw-sys-db-sdb bw maxdbhan-db-eng-bw sap hana bw engine priority recommendations / additional info category, places ----------- ----------------- -------- ----- ---------- key_0tct_c01p rsdimid int4 10 0key_0tct_c01t rssid int4 10 0key_0tct_c011 rssid int4 10 0key_0tct_co12 rssid int4 10 0tcttmeolap /bi0/oitcttmeolap dec 17 3tcttimedm /bi0/oitcttimedm dec 17 3tctdbsel /bi0/oitctdbsel int4 10 0tctdbtrans /bi0/oitctdbtrans int4 10 0factcount /bi0/oifactcount int4 10 0as, pos data type length decimals----------- --- --------- ------ --------key_100481p 1 number 10key_100481t 2 number 10key_1004811 3 number 10key_1004812 4 number 10tcttmeolap 12 number 17 3tcttimedm 13 number 17 3tctdbsel 19 number 10tctdbtrans 20 number 10factcount 21 number 10the data type dec 17, components bw-sys-db bw database platformsbw-sys-db-db2 bw db2, tctdbsel /bi0/oitctdbsel int4 database records selectedtctdbtrans /bi0/oitctdbtrans int4 number, /osbw-sys-db-db4 bw db2, numeric output parameter overflow sql error -10811 performing fet numeric output parameter overflow, olapfactcount /bi0/oifactcount int4 data record counter, sdn blog post bw/db support 101 -, 2417] log bzy=> unexpected return code 4 calling dbacds[dbacds#2 @ 1471] [dbacds 1471 ][
Related Notes :
| 1899734 | |
| 992805 | Overflow during the arithmetical operation (type P) |
| 891740 | Query runtime statistics: Corrections for extractors |
| 579342 | Changing key figures that are used in InfoProviders |
| 460652 | Extending key figures in BW |
| 429805 | SQL error 8115 |