Question Re: CPI: SubString Function Issue while mapping target field in Technology Q&A

CPI: SubString Function Issue while mapping target field

babruvahana — Mon, 22 Jun 2020 15:57:47 GMT

Hi Experts,

I working on a mapping where I need to restrict the char length of the source field.

If the character length is less than the character count defined in the substring function, the mapping fails with String out of index

The same mapping workings in PI. But it failed in CPI.

Is it a normal behavior or I am doing wrong with my mapping or any other ways to achieve this simple mapping in CPI?

Any pointers would be of great help.

Re: CPI: SubString Function Issue while mapping target field

jorgeh — Mon, 22 Jun 2020 16:17:49 GMT

Is the normal behaviour

Concatenate after string some blank values and then use trim function

If node doesn't exist force with standard function mapwithdefault

Re: CPI: SubString Function Issue while mapping target field

babruvahana — Mon, 22 Jun 2020 16:49:19 GMT

Hi jorgehnga

Thanks for the response.

I did the following change, but still, it is failing with the same error. Do I need to change anything else?

Re: CPI: SubString Function Issue while mapping target field

jorgeh — Mon, 22 Jun 2020 17:08:49 GMT

Add the trim function after substring not before

Re: CPI: SubString Function Issue while mapping target field

babruvahana — Mon, 22 Jun 2020 17:42:23 GMT

I did the changes, but no luck. Mapping still fails when the character length is less than the character count defined in the substring function.

Re: CPI: SubString Function Issue while mapping target field

bhalchandrasw — Mon, 22 Jun 2020 17:58:16 GMT

Hi babruvahana,

Use function ifS instead of function if.

Function 'if' evaluates all expressions before assigning the value. Function 'ifS' evaluates the condition first and then evaluates the required expression.

You are getting the error because when length is less than 30 the expression substring is evaluated anyhow.

SAP Note 1090369 explains the difference. In your PI system, the note might not have been applied, therefore it worked.

In general, always use ifS and ifSWithoutElse instead of if and ifWithoutElse.

Hope this helps,

Bala

Re: CPI: SubString Function Issue while mapping target field

MateuszAdamus — Mon, 22 Jun 2020 18:04:14 GMT

Hello babruvahana

Is the IF (or IF$) even required here? Same goes for LENGTH.

Can't you CONCAT 30 spaces at the end of the input string, then take the first 30 characters of the resulting string with SUBSTRING and then TRIM the result of SUBSTRING?

Kind regards,
Mateusz

Re: CPI: SubString Function Issue while mapping target field

Sriprasadsbhat — Mon, 22 Jun 2020 18:16:15 GMT

Hello Pacan,

If above solutions are not working then write a custom function ro handle both cases(it would be tiny and could be easily written) . Will keep a note on this query and get back to you in case any difference in CPI function behavior compared to SAP PI/PO.

Regards,

Sriprasad shivaram Bhat

Re: CPI: SubString Function Issue while mapping target field

babruvahana — Wed, 24 Jun 2020 09:36:46 GMT

Hi jorgehnga , bhalchandra.wadekar, mateuszadamus, sriprasadshivaramabhat

The issue has been resolved by : con-cat{empty space} - substring - trim - ifS

Before writing a custom function I just deployed and ran the iFlow, it worked.

Display Queue failed when the character length is less than the character count defined in the substring function.

The issue seems to be with the Display queue rather than the SUBSTRING function.

Regards,

Pavan G

Re: CPI: SubString Function Issue while mapping target field

former_member666312 — Wed, 24 Jun 2020 17:43:06 GMT

Hi ,

Somehow it is working fine for me, can find the below screen show which is working fine for me.

May be you can provide your input to check .