Symptom
- You are migrating your SAP BW system to SAP ASE 160 SP02 via SUM DMO
- During the Downtime Phase - "EU_CLONE_MIG_DT_RUN" - one or more CREATE INDEX stmts fail with Error 702:
Fatal Error SQL 702 Memory request for 16512 bytes exceeds the size of single page of 16384 bytes
A1 ESYB 003 /BIC/FZSS_C04~020 dropped
A1 ESQL 004 index /BIC/FZSS_C04~020: SQL overridden by 'DFACT.SQL', line 30729-30740
A1EEIMP 007 Task failed with error: (SYB) DDL statement failed
A1EEIMP 007 (IF EXISTS(SELECT 1 FROM sysindexes i, sysobjects o WHERE i.name = '/BIC/FZSS_C04~020' AND o.name = '/BIC/FZSS_C04' AND i.id = o.id AND o.uid = user_id()) DROP INDEX "/BIC/FZSS_C04"."/BIC/FZSS_C04~020" ; CREATE INDEX "/BIC/FZSS_C04~020" ON "/BIC/FZSS_C04" ("KEY_ZSS_C04T") LOCAL INDEX ;)
A1EEIMP 007 DbSlExecute: rc = 99
A1EEIMP 007 (SYB) (SQL error 21)
A1EEIMP 007 Error message returned by DbSl:
A1EEIMP 007 (SYB) DbSlErrorMsg rc = 0 'everything went well'
A1EEIMP 007 (SYB) [ASE Error SQL21][SAP][ASE ODBC Driver][Adaptive Server Enterprise]WARNING - Fatal Error 702 occurred at Mar 27 2018 6:26AM. Please note the error and time, and contact a user with System Administrator (SA) authorization
- The failing CREATE INDEX is on a F table of an Infocube
- The ASE errorlog contains the same corresponding Error 702 - without an accompanying stacktrace
If the Error 702 is encountered during runtime on SAP Solution Manager or SAP BW systems, see SAP KBA 2626359.
Read more...
Environment
-
SAP Adaptive Server Enterprise (ASE) 16.0 SP02 for Business Warehouse
-
SAP NetWeaver (all versions)
Product
Keywords
SUM, DMO, compress, 702, migration, migrate, partitions, partitioned, "fact table", Infocube, CR 814361 , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview