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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.