Post to WIP fails when called on a process

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A few transactions have been created, but when processing those Post To WIP is failing.

The bg-ca.log file shows the following error:

ERROR 2024-04-03 13:37:30,714 [Dispatch Post to WIP : bg@mytenant (tenant=clarity)] niku.njs (clarity:[email protected]:9356555__E98D2A9D-D87A-4890-B153-A2C27F951023:Post to WIP) () Error executing job: 5391836
com.niku.union.persistence.PersistenceException:
SQL error code: 0
Error message: ERROR: invalid input syntax for type bigint: "<attribute dataType="string" name="param_res" referencedObjectId="LOOKUP_FIN_RESOURCES" referencedObjectCardinality="2" isActive="true" isRequired="false" operation="add" xmlns="">
  <data/>
</attribute>"
  Where: PL/pgSQL function pac_prc_posttowip_job_sp(timestamp without time zone,timestamp without time zone,text,text,text,bigint,text,double precision,double precision,double precision,double precision,text,text) line 107 at FOR over cursor
Executed:
call PAC_PRC_POSTTOWIP_JOB_SP (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

In this case scenario, there is a custom workflow that:

1. Loads the Clarity transactions via XOG

2. Does a  few verifications for the transactions loaded

3. The Post Transactions to Financials, Post TO WIP, and Import Financial Actuals are being invoked at a process step by calling a subprocess.

 

Cause

The Post to WIP job was being called by a process and the job ID referenced was not correct

Resolution

Edit the custom workflow and call the Post To WIP as Run Job action on its own.