We tried adding only one String attribute and we are getting error now running the Load Data Warehouse (DWH) job in Clarity PPM
Excerpt of error from DWH job log:
dwh_db_check_ - An error occurred executing this job entry: Couldn't execute SQL: MERGE INTO DWH_IN_INVESTMENT USING
User Defined Java Class - java.lang.Runtime.Exception: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_INV_INVESTMENT at Process
dwh_etl_intereface_dim - Errors detected
A SQL exception occurred when creating view ODF_IDEA_V. The view will not be recreated. ...[SQLServer]CREATE VIEW failed because column 'attributeID' in view 'odf_temp_view11111111111111' exceeds the maximum of 1024"columns (repeated for multiple columns in project and idea object.
This is due to a limitation in the MSSQL database, 1024 is the database limit on the number of columns a database view can have.
Inactivate some of the custom attributes from the view so the total number of attributes (OOTB + Custom) doesn't exceed 1024. We recommend up to 100 custom attributes per object.