DE53442 Error message java.lang.NumberFormatException on creating/saving an Action with a Type Process

Products

• Clarity PPM SaaS

Issue/Introduction

DE53442 Error message java.lang.NumberFormatException on creating/saving an Action with a Type Process

1. Connect to Clarity - Administration - Objects
2. Select Object Z_Test
3. Go to Actions - New
4. Enter name/ID
5. Select Type Process, click on Browse for Process
6. Now pick any process in the list
7. Click Add. Note that it shows the internal ID only
8. Now hit Save


Expected Results: The new action to save successfully

Actual Results: ERROR Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

Error in app-ca.logs:

ERROR 2020-02-21 13:20:02,309 [http-nio-1550-exec-21] object.ActionInsertService (clarity:admin:82369929__C3AB5B80-90C7-4820-9F1B-B2930F05F184:odf.saveObjectAction) Error occured while retreiving attributes

java.lang.NumberFormatException: Error parsing number Test_process

              at com.niku.union.utility.DataFormatUtil.parseNumber(DataFormatUtil.java:249)

              at com.niku.union.utility.DataFormatUtil.parseInt(DataFormatUtil.java:109)

              at com.niku.odf.service.object.ActionInsertService.processActionProcess(ActionInsertService.java:651)

              at com.niku.odf.service.object.ActionInsertService.doProcess(ActionInsertService.java:141)

              at com.niku.odf.service.ODFActionService.processRequest(ODFActionService.java:113)

              at com.niku.union.service.binding.ServiceControlBindingJava.processRequest(ServiceControlBindingJava.java:58)

              at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:914)

              at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:212)

              at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:219)

Environment

Release : All Clarity releases

Component : CA PPM SAAS BUSINESS PROCESS MANAGEMENT

Resolution

Lookup query was modified which caused the issue. 
For BROWSE_ACTIVE_VALIDATED_PROCESSES lookup we changed the dynamic query :

It was taking process name as hidden field , so was unable to parse as a number. We reset the Dynamic query accordingly and this resolved the problem. 

SELECT 
       @SELECT:bdpv.id:[email protected],
       @SELECT:ccn.name:[email protected],    
       @SELECT:bdp.process_code:[email protected],
       @SELECT:bdo.object_type_code:[email protected],
       @SELECT:ccn_object.name:[email protected],
          @SELECT:ccn.LAST_UPDATED_DATE:[email protected],
          @SELECT:l.ID:[email protected],
          @SELECT:ccn.LANGUAGE_CODE:[email protected]
  FROM CMN_CAPTIONS_NLS ccn
     , BPM_DEF_PROCESSES bdp
     , CMN_LANGUAGES l
     , BPM_DEF_PROCESS_VERSIONS bdpv LEFT OUTER JOIN
       BPM_DEF_OBJECTS bdo
    ON bdo.pk_id = bdpv.id
   AND bdo.table_name = 'BPM_DEF_PROCESS_VERSIONS'
   AND bdo.manual_start = 1
   AND bdo.is_visible = 1
   AND bdo.is_system = 0 LEFT OUTER JOIN
       ODF_OBJECTS oo
    ON oo.code = bdo.object_type_code LEFT OUTER JOIN
       CMN_CAPTIONS_NLS ccn_object
    ON ccn_object.table_name = 'ODF_OBJECTS'
   AND ccn_object.pk_id = oo.id
   AND ccn_object.language_code = @WHERE:PARAM:[email protected]
 WHERE ccn.pk_id = bdp.id
   AND ccn.table_name = 'BPM_DEF_PROCESSES'
   AND bdpv.process_id = bdp.id
   AND bdpv.USER_STATUS_CODE = 'BPM_PUS_ACTIVE'
   AND ccn.language_code = @WHERE:PARAM:[email protected]
   AND ccn.LANGUAGE_CODE = l.LANGUAGE_CODE
  AND @[email protected]