on 08-19-2010 6:04 AM
i have issue with the empty files coming from the sender which are getting processed and getting saved in given file location.
Now the problem is,these files donot contain data and rather just gets outputted with header and trailer with some dummy data usually spaces,some zeros,-- like this...,this makes the file size of some 444 bytes or 834 bytes but as it is not having any data,we need to goto SXMB_MONI everyday,check for files,if its empty,needs to cancel them manually because it appears in red flag.
To avoid this,i was thinking of setting the empty file option in processing of communication channel to SKIp messages or delete messages.
Am i right in this approach?
From other thread:
"Currently when a process fails in PI due to an empty file the process needs to be manually set to u201Ccancelledu201D,where to locate in PI,what could be the problem and how it is to be solved.i have asked a similar question and hope that this error will help."
please reply and show me right way of resolving this.
thanks!
cheers!
Edited by: Prateek Raj Srivastava on Aug 19, 2010 10:54 AM
Nishi,
This can be easily achieved in the mapping. Check for data records, if it is empty then don't create the target node ... it won't throw any error as such but you can raise alert if there is a requirement for that.
Regards,
Neetesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nishi,
It seems that main issue is red flag shown in SXI_MONITOR for empty file.
To avoid this you can create a scenario where in message mapping at header level check whether the header field is having
zero as field value(Check what value is coming in header field in empty file). If that value is present into the message then dont populate any other field so that will help to avoid red flag (As I guess red flag is coming due to data problem)
In receiver determination check this header value and define another dummy receiver and pass the message to that dummy receiver. This will avoid error flag and message gets processed successfully and will not reach to target system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
As per ur req, its nt possible in this way.
The empty file handling means the whole file is empty, the size is 0k.
So in ur req, empty file means Header and Trailer present, but no data Records.
we can achive this in following ways also,
1.write an adapter module, to check if at all there is atleast there is 1 Data record, if not throw exception there itself.
2.In the mapping check if at all there is any Data Record. If no Data Records raise exception and also the Alerts.
Babu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I just noticed that you have raised 2 different threads. Don't raise 2 threads for same question. Read rules of engagement.
For your question, the file should be really Empty to use this option and it seems that your file is not.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.