End-user receives a System Error if the partition is deactivated after they have configured an attribute from that partition as a sort column.

Document ID : KB000023029
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

If a partition is disabled after an end-user has used the personal configuration option to add an attribute built on that partition to the list view on an object and then configures it as a sort attribute as well, he will receive the following error:

 ! Error 
System error. Contact system administrator. 

Steps to Reproduce:

  1. Login as an administrator user 
  2. Configure a partition model with at least two partitions : Partition A and Partition B 
  3. Go to the Idea Object and add it to your partition model 
  4. Create 2 custom attributes under Partition A on the Idea object. I named them Att1 and Att2, chose the string attribute type and gave them default values of "Att1" and "Att2" 
  5. Assign a user to both partitions. Make sure he has sufficient rights on your object to create/edit object instances on your chosen object. I named my user Test1 
  6. Login as Test1 and go to the Idea list. Click on Configure and add the Att1 and Att2 to your Selected column. Save your changes 
  7. In the same screen set your first sort column. Click on Save and Exit 
  8. Log out of the application 
  9. Log in as an administrator user 
  10. Deactivate Partition A 
  11. Login as Test1 and navigate to the Idea list 

NOTE: If Step 7 is left out, the idea list will draw as expected.

Expected Results: The Idea (object) list should draw successfully without the Att1 and Att2 columns.

Actual Results: The user receives the System Error described above.

Error from app-niku.log under MSSQL:
ERROR 2014-11-05 10:02:09,142 [http-99-Processor13] niku.xql2 (admin_user:39654974__6573cc37:pma.ideaList) Internal Processing exception com.niku.odf.griphendor.GriphendorException: com.niku.union.persistence.PersistenceException: SQL error code: 207 Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid column name 'cnn_idea_reqdt'. SQL error code: 8180 Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
 
Error from app-niku.log under Oracle:
ERROR 2014-11-09 16:09:06,061 [http-80-Processor58] niku.xql2 (admin_user:5073240__2279d19e:projmgr.applications) Internal Processing exception com.niku.odf.griphendor.GriphendorException: com.niku.union.persistence.PersistenceException: SQL error code: 904 Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "ATT_1": invalid identifier
 

Solution:

WORKAROUND:
Publish Views to all users or restore individual user's personalized view.
  
STATUS/RESOLUTION:
Our sustaining team reviewed CLRT-52592 and closed it as they are not planning to make any changes to this area of the product.
For more details please review the Customer Reported Defect Resolution Policy for Clarity