Impacts of DB Setting Change on Clarity

Products

• Clarity PPM On Premise

Issue/Introduction

Can we alter "max_string"_size of Clarity Database from default which is standard to Extended.

 

Environment

Release : 16.1.1

Resolution

MAX_STRING_SIZE controls the maximum size of VARCHAR2 , NVARCHAR2 and RAW data types in SQL.  

However, clarity java code is expecting the default size for text data types, we do not recommend to change and it may break or cause issues.