Program able to get data in Foreground but wasn't able to using Background

[Former Member]

Hi BW Folks,

I have this weird problem wherein whenever I run this custom program that I made during a Background session, the program wasn't able to get any data. But when I tested it and ran it in Foreground, the program was able to get me data.

Now I'm currently clueless on why it's happening as I can't debug the program running in Background.

Do you have similar experiences or do you have clues on where to look at?

Thanks in advance!

Ritz

[Former Member · Accepted solution]

Hi Ritzel,

Please provide more details:

1. What this program is supposed to do?

2. Getting data? Does it mean it is extracting data from Source System or within BW?

3. Does 'PROGRAM' here mean a report to display data from existing table or a report that pulls data from source and writes into any BW object?

4. If code is of few lines, please paste it.

Regards,

Ravi Poluru

Assigning Points = Saying Thanks

[Former Member · Accepted solution]

Hi Ravi,

The program (run via SE38) is customized in such a way it produces an outbound by extracting data in a bex query. Inside the program, it calls the bex query and runs it during runtime. It captures the data and produces a file in text format.

Weird thing here is that it is perfectly working when we tested it in the UAT environment (and still working now there) but when it was transported to Production, that is when the issue occured.

The issue exactly is, in Production, when the program is ran in background, it returns a message "No Applicable data" same like the one when we run a bex query if there are no data extracted. But when the report is ran in Foreground, it is working. Same user id used during background/foreground.

Thanks for the help!

[Former Member · Accepted solution]

Hi Ritzel,

Please try to regenrate the query in RSRT.

1. Is that you are using the query technical name in the program or system generated alpha-numeric one?

2. Are you using any variables in the query? If so, how are you providing values when you run in background?

Regards,

Ravi Poluru

Assigning Points = Saying Thanks

[Former Member]

Hi Ritz,

As you mentioned that you are using same id for both backe and front ground ,

1)Did it has the authorization for for background process ?

2) When execute the program in background what is the log you see or status (active,schedule,released or cancel) if it is cancel check the log for an issue ?

Regards,

Satya

[Former Member]

Could you pls check, whether you are providing proper inputs in variant attributes when you are executing this in back ground.And also check whether u have proper authorization or not.