Unable to see Attributes in Dev environment for project and idea objects.
search cancel

Unable to see Attributes in Dev environment for project and idea objects.

book

Article ID: 244880

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

We are unable to see Attributes in our Dev environment. We did a complete reboot of our dev servers but it still won't populate any results. Can you please advise of what else could be causing this? 

Environment

Release : 15.9.3

Component : Clarity Studio

Cause

ERROR 2022-06-22 15:15:41,920 [https-jsse-nio2-8443-exec-48] niku.xql2 (clarity:some_user:10521037__ABBC50D4-F707-42CB-A19A-DEFC96D1636C:odf.objectAttributes) Internal Processing exception
com.niku.union.persistence.PersistenceException: 
SQL error code: 30004
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-30004: when using SYS_CONNECT_BY_PATH function, cannot have separator as part of column value

Executed:
 WITH OBS_PATHS as ( SELECT id, SYS_CONNECT_BY_PATH(name, '/') path,
                                      level lvl
                              FROM prj_obs_units WHERE 1=1  AND id in (5001002) CONNECT BY PRIOR id = parent_id  order by id,lvl desc )
          select id unit_id,path unit_path
            from OBS_PATHS otable
            where otable.lvl = ( select max(lvl) from OBS_PATHS itable
                                  where itable.id = otable.id) 

Resolution

Lookng at the error in the app-ca.log it seems to indicate that one of the OBS values could be having / in the name.

Customer was working on an automation to update out OBS. The file received from their organization has a “/” between states for some associates that cover multiple areas. This is what was causing the issue. The file will be scrubbed before upload moving forward.