Dependency page fails with ERROR 500 while filtering on project obs or dependency or master projects

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

While creating tasks in Projects, if end user copy the text from some other documents with some indentation / formatting, the task name in DB are saved with special characters. We have a process which runs the query using to_char on the task name and it is resulting in below error on Classic UI.

 Error 500

The error observed at DB while running the query manually 

ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.

64203. 00000 - 'Destination buffer too small to hold CLOB data after character set conversion."

• • Cause: An attempt was made to convert CLOB to CHAR, where the LOB size was bigger than the buffer limit for CHAR types or the CHAR buffer was not big enough to hold all data after character set conversion.

Steps to Reproduce: 

1: Login to MUX and select any project on Windows Operating System

2: Use the text i.e.  to create a task with name

3: The task is created

4: Get the task name from the DB using query select * from prtask where prprojectid=<Project_ID>

5: Paste the copied task name to notepad++ and say show all characters(Notepad++ View > Show Symbol > Show All Characters) and NBSP is present

Expected Results: The characters should be encoded/parsed with proper formatting

Actual Results:  The characters are getting saved into DB with special characters.

Environment

Clarity: 16.2.1, 16.2.3 Patch 2 (16.2.3.2)

Operating System: Windows

Database: Oracle (19C or higher)

Cause

DE165512

Resolution

Fixed in v16.3.2

 

Additional Information

Workaround: Remove the special characters before pasting the text in task name using editors like Notepad++, VS Code etc.