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.
You should be able to save filter default of the Department Attribute with as many departments as you need
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
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
Open. Defect is target for resolution in future release.