2216593 - SQL0670N error when unarchiving/duplicating/updating a repository in a DB2 database

Symptom

The unarchive operation fails when using a DB2 database.
On the MDS_logs the following error can be seen:

SQL_ERROR SQLSTATE= 54010, ErrorCode= -670, Msg=[IBM][CLI Driver][DB2/NT64] SQL0670N The statement failed because the row size of the resulting table would have exceeded the row size limit. Limit: "32677". Table space: "". SQLSTATE=54010

In Update/Unarchive report (<MDS Home>/Reports folder):

"Cannot modify field 'FEATURENAME_LB' in table A2i_FV_5.",Horizontal@Database,BranchedSchemaUpdates.cpp,

When duplicating the repository, the same error will be issued but the duplicate operation may complete. However you will find that the duplicated repository cannot be started.

Environment

SAP Netweaver MDM 7.1 on a DB2 database.

Product

SAP NetWeaver Master Data Management 7.1

Keywords

KBA , MDM-FN-MDS-DB , DB Layer , 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.