SAP Knowledge Base Article - Preview

3029347 - SQL0670N error while performing a Unicode migration + EHP upgrade

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

SAP ERP 6.0 ; SAP NetWeaver all versions

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.