Hi,
I’ve found some strange behavior of BODS and I’m not quite sure if this is really a bug/incorrect behavior or not so I want your opinions about it.
I would open a SAP ticket when most of you agree - so please comment.
Imagine a RT-Job where, for whatever reason, your query for creating the response structure returns 0 rows (most of time because of inner-joins returning 0 rows - see "
In this case, BO will create an empty response, just with the root element (see “soupUI.png”).
From my perspective, this is an invalid response as the response can define mandatory fields.
I would expect a soapException in this case.
Background:
I have a RT-Job which calls another RT-Job provided by BODS, so I check AL_ERROR_NUM only if there was an error.
If AL_ERROR_NUM = 0 (as it is even when such an invalid response was sent) I just use my response fields.
As they’re normally filled all the time, I don’t check them for (null)-values (as they are in the invalid response) and I got a nice oracle exception (“you’re not allowed to insert null…”) later.
What do you think about this?
Maybe Manoj/Werner can post an “official” SAP statement.
Thanks in advance.
schaphi (BOB member since 2012-06-04)