on 03-08-2011 8:15 AM
Hi Experts,
I need a suggestion from you:
We have a requirement where in we have to skip the source records, where the mandatory fields are missing and if possible log it in PI server.
Please advice how can we handle this ?
u can do it in graphical mapping using UDF- check all the values of payload if value is missing then skip that record else generate a record.
chirag
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Query solved with above inputs..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Puneet,
To skip the records, you can achieve it in graphical mapping using exists and createif function.
MandatoryField -> exists -> createIf -> removeContext -> TargetStructureNODE
Regards,
Aravind
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
you can do that with message mapping, just use one of the mandatory fields (or a concatenation of them) to generate the output. as for the logging depends what you want to achieve, but you will need a udf
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Puneet,
In PI 7.0 we read all records into a message. Then we apply java mapping program for validation. This program generally written using DOM parser will go through each record one by one and validate it with a set of requirements. if a set of records does not contain mandatory fields we send error emails to a set of users. this triggering of emails is done by RFC. In your case you can simply move to next record. In case you want to log it in PI server then you can use an ABAP program to log the error messages for each record in a table. The records which are valid can be passed onto next mapping. With use of BPM this becomes simpler to implement.
regards
Anupam
Edited by: anupamsap on Mar 8, 2011 10:11 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Puneet,
Is your mandatory field comming as separate field within source message then you can use the mapping what Aravind has posted. In case it is comming in, as part of a line then you need to post here the source and target mesage structure. Then only code for UDF or java mapping may be suggested. Also if possible include sample input and output.
regards
Anupam
Edited by: anupamsap on Mar 8, 2011 11:27 AM
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.