XOG broke change request object

Products

• Clarity PPM SaaS

Issue/Introduction

Xogging change request object changes from Dev environment to QA and output file shows error

XOG-3360: Custom attribute record has not been inserted java.lang.Exception: System error. Contact system administrator.
 at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:75)

Environment

Release : 15.6.1

Component : CA PPM SAAS XML OPEN GATEWAY (XOG)

Cause

those special characters highlighted were in the formula were present in the input file and needed to be cleaned

<customAttribute active="true" calculationExpression="(nyl_fpc_bgt-nyl_chg_fpc+nyl_fpc_cr1+nyl_fpc_cr2)&#xd;&#xa;" code="nyl_fpc_rebas" column="nyl_fpc_rebas" constant="false" currencyConnected="false" custom="true" dataSize="20" dataType="number" dwEnabled="false" editable="false" extendedType="calculated" multiValued="false" partitionCode="NIKU.ROOT" partitionMode="PARTITION_AND_ANSTRS_DESDNTS" presenceRequired="false" private="false" required="false" unique="false" virtual="true">

Resolution

it was a CR / LF at the end of the formula which had to be removed.