Skip to Content
0

Not able to retrieve data when values in optional prompts are not seclected

May 09, 2017 at 01:16 PM

41

avatar image
Former Member

This is happening only in PROD with one WEBI report. Report is fine in DEV. System - BO 4.2 SP3

Tried to migrate the report to PROD from DEV - doesn't work.

Recreated the whole report from scratch and was able to pull only partial data on Friday. When I ran the report on Monday it ran fine(ofcourse with partial data) for the first time, Second time it started throwing "No Data to retrieve". This is inconsistent and really weird.

Any suggestions???

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
May 09, 2017 at 01:58 PM
0

is it happening with optional prompt only? what will happen if you make it as mandatory prompt and run?

check with purging the data/prompt values and re-run again.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amit,

I have 5 optional prompts in the report and running report with no values selected - no data to retrieve.

I did purge data/prompt values - doesn't work.

And this is happening with only one report.

Please advise.

0
avatar image
Former Member May 09, 2017 at 02:03 PM
0

Hi Amit,

I have 5 optional prompts in the report and running report with no values selected - no data to retrieve.

I did purge data/prompt values - doesn't work.

And this is happening with only one report.

Please advise.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 12, 2017 at 09:14 PM
0

Somehow SP4 fixed this issue for us. Thank You!

Share
10 |10000 characters needed characters left characters exceeded