CA PPM: Portlet filter default Save System Error when including many Departments

Document ID : KB000071373
Last Modified Date : 10/08/2018
Show Technical Document Details
Issue:
System Error if you try to add many departments to the filter default of the Department Attribute in a Portlet

Steps to Reproduce:
Note: In order to reproduce the issue, you need to use an environment that has more than 120 departments.

In Admin side:
1. Create a Portet based on Project Object. You can add some columns in the List Layout, this doesn't matter which ones.
2. Go to List Filter Section : Layout and add field 'Department' (attribute 'department_code')
Change Lookup style to 'Multiple-select'
Filter Default .. click on the binocular. Select many departments (more than around 120). Click on Add.
Click on Save.

Expected Result: 
You should be able to save filter default of the Department Attribute with as many departments as you need

Actual Result: 
You cannot save filter default of the Department Attribute with as many departments as you need. You get Error: System Error. Contact System Administrator.
 
app-ca log shows:

ERROR 2017-11-09 13:09:14,642 [http-nio-80-exec-26] niku.xql2 (clarity:admin:54222770__BC3116C5-8788-4318-8B9A-D43C4186C744:odf.updateUserObjectFilterField) Internal Processing exception
com.niku.union.persistence.PersistenceException:
SQL error code: 1461
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01461: can bind a LONG value only for insert into a LONG column
 
 
Cause:
Caused by DE37616
 
Resolution:
Open. Defect is target for resolution in future release.