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?
Release : 15.9.3
Component : Clarity Studio
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)
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.