Unable to XOG Out Project instances

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• Following error is obtained while trying to XOG Out a Project instance
  • SQL Exception with error code : 511
message: Cannot create a row of size 8286 which is greater than the allowable maximum row size of 8060.
• This happens only when the following option is used in the XOG Read file:
  • <args name="include_custom" value="true"/>
• When running the following query directly in the DB, the same error as the one mentioned above is obtained:
  • select * from odf_project_v2

Environment

• SQL Server DB

Cause

Over 400 custom attributes are defined in the 'inv' and 'project' objects

Resolution

• It is recommended not to define more than 100 custom attributes in any object
• If there is a need to have more custom attributes, split them logically and create them under multiple sub-objects.