search cancel

% Complete field on PM Views throws 500 Error when used in Power Filter


Article ID: 214467


Updated On:


Clarity PPM On Premise


When used the field in PM Views as power filter, we are getting 500 Error message on Save and Return. We built a portlet based on NSQL where we are pulling % Complete field and converting to String from inv_projects table but the field is of % data type in Project Object.


Using input: 
{is_active=1, percentage_complete=100%, @[email protected]= ( @[email protected](pp.percent_complete*100.00 || '%') != 100 ) , nsql.execFlag=1}
Using dynamic SQL: 
tag: @[email protected] SQL: ( @[email protected](pp.percent_complete*100.00 || '%') != 100 ) 
tag: @[email protected] SQL:1 = 1
tag: @[email protected] SQL: order by id asc

 at com.niku.union.persistence.PersistenceController.createException(
 at com.niku.union.persistence.PersistenceController.handleSQLException(
 at com.niku.union.persistence.PersistenceController.processSql(
 at com.niku.union.persistence.PersistenceController.processStatement(
 at com.niku.union.persistence.PersistenceController.processStatements(
 at com.niku.union.persistence.PersistenceController.doProcessRequest(
 at com.niku.union.persistence.PersistenceController.processRequest(
 at com.niku.union.persistence.nsql.NSQLQuery._execute(
 ... 77 more
Caused by: java.sql.SQLDataException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01722: invalid number


Release : 15.9

Component :


Do not convert % Compete field to String because when NSQL portlet is executed and it is attempting to filter it's expecting a number so error is thrown.