Mapping using substing is not working after upgrade to PI SP13

[Former Member]

Hi all,

In XI SP 14 we had a mapping that used a lot of substing commands to switch around a data time stamp. It basically said, if the node was not blank(its is being passed as blank on occasion instead of null) then run all the substing commands to move the date and time around. Now in PI SP13 it is still trying to run the substing mappings for the records with blank values coming in, even though the IF statment acknowledges that it should be suppressed. This is causing a java exception for the command since the field is not long enough for the substing. Has anyone else run into this problem?

Regards,

Chris

[Former Member]

HI,

Before the If condition just try to add the API SplitByVlaue or maybe concat the field with balnk spaces.

If you could give the exact details of the applied condition then it will be easy to give you the proper way that could achieve with mapping.

Its surprising that if the same mapping is working out for old SP and now its creating problem for the PI SP13.

Thanks

Swarup