Symptom
While performing a Unicode conversion + EHP upgrade, during phase MAIN_SHDPREPUT/PARMVNT_PRE of the upgrade you encounter sql error SQL0670N.
====================================================================================================
3 ETP000 IN "PSAPBTABD"
3 ETP000 INDEX IN 'PSAPBTABI"
3 ETP000 LONG IN "PSAPBTABD"
2WETP000 12:51:21: Retcode 1: error in DDL statement for GLPOS_N_GL_CT - repeat
2EETP345 12:58:33: Retcode 1: SQL-error "-670-SQL0670N The statement failed because the row size of
2EETP345 the resulting table would have exceeded the row size limit. Row size limit: "4005". Table
2EETP345 space name: "PSAPBTABD". Resulting row size: "4310)". SQLSTATE=54010 in DDL statement for
2EETP345 "GLPOS_N_GL_CT".
====================================================================================================
You attempt to get around the problem by enabling Db2 database parameter EXTENDED_ROW_SZ=ENABLE. But the SQL0670N error persists.
Read more...
Environment
- SAP Netweaver any version
- Db2 (DB6) any version
Product
Keywords
KBA , BC-DB-DB6-UPG , Upgrade SAP System , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.