i have .net app using bo 3.x's opendocument url open particular instance of webi report, particular set of parameter values. worked brilliantly.
but bo 4.1 , 4.2, whenever use &sinstance=param opendocument open particular instance of report, fails miserably, silently throws java error, , leaves me (almost) blank webpage.
does opendocument work anymore &sinstance=param ?
i received following email on august 6, 2016:
"issue reproducible on bi 4.2 sp2 patch 2. issue has been resolved on bi 4.2 sp2 patch 3. regards..."
september 2016: confirm, latest patch, opendocument (finally) work again, managing open particular instance of webi report.
description of problem (for other bo victims)...
it's been couple of months since posted article, no 1 sap forum has offered help, , i'm still stuck on problem.
here's step-by-step guide of how reproduce issue.
to keep things simple, have "dumb" bo report, merely takes 2 parameters, , shows values in report. nothing more.
i have few instances of report, , i'm trying open specific instance of report, using opendocument url. here's history of dumb report, , can see have 3 instances of it.
if open instance parameters ave;chf see this:
wonderful.
now, want open particular instance of report programmatically. using opendocument. in "real" version of app, these reports refreshed each night, , each instance might take 20 minutes refresh, do not want let opendocument refresh report... merely open existing instance of report.
my report takes 2 parameters called fx type , currency, , try open report using opendocument url (split separate lines, readability) :
http://myserver:6405/boe/opendocument/opendoc/opendocument.jsp? idocid=adf8qlrxtbdegjxipvs8s6q &sidtype=cuid &soutputformat=h &stype=wid &srefresh=n &sinstance=param &lsmfx+type=ave &lsmcurrency=gbp &token=blahblahblah when open url, this, in both chrome , ie11.
notice how right-hand panel shows has got report's details... logged on correctly , managed find correct report, report area blank.
being geek am, used google chrome inspect blank area, , found this..
basically, webi has thrown java error, , webi has decided not tell user.
<body> <script type="text/javascript"> oninvisibleerror({actionid: '4587', message: 'while trying invoke method java.lang.string.length() of null object loaded local variable \'stodecode\''}); </script> </body> removing &sinstance=param url
back in url, if remove section &sinstance=param report does open successfully, , shows parameter values correctly. but, crucially, refreshes report, don't want.
we have instance of report, don't want wait 20 minutes report refresh, when instance exists.
replacing &sinstance=param &sinstance=last
out of interest/desperation, tried opendocument open recent instance of report.
&sinstance=last when did this, worked expected. report opened perfectly, didn't refresh report, but, of course, opened whichever instance last created.
parameter names containing space
when posted article, readers recommended using %20 instead of + in parameter names containing space.
i should say, if take opendocument url, remove &sinstance=param section, , modify fx type parameter &lsmfx+type=ave &lsmfx+type=chf, report refreshes using new fx type value.
so url parsing url correctly, , setting 2 parameter values correct parameter names. falls on when trying find existing instance.
final thoughts
so. in (longwinded) nutshell, if use &sinstance=param, bo v4.2 (and v4.1) quietly throws error , returns blank screen.
it won't let me load existing instance of webi report.
and sap's support seems have gone awol.
has seen problem, or found workaround ?
one day later...
this morning, created second webi report, hyperlink "mikes test" report.
when clicked on link, opened webi report specified parameters. no problem there.
but when changed "target window" setting "current window" "new window"...
...look happens when click on hyperlink...
it's our java error again !
so, think proves is bug in bo 4.2 itself.
even hyperlink urls creates aren't able open specific instance of webi report.
sap... on you...
i think cause of error message haven't specified index value matching prompt value passed (bu cat). have @ section on lsi[name] in opendocument manual.
here's rather easy option compare , check opendocument links: have document link feature in webi create them you. here's do:
- create new webi document (you can use existing 1 if prefer). if create new document, select no data source.
important: make sure you're using html webi client, not java applet (ria) one.
- create single blank cell, right click , select linking > add document link. browse , select document in dialog.
- webi analyze document in background, , list opendocument options along prompts found in target document. specify prompt values , select link document instance, setting most recent - matching prompt values.
remark: take account prompts might require index values along text values (this true bw variables/prompts).
- after configuring different options , prompt values, click ok , inspect cell's content. you'll see contains opendocument url. compare url 1 created , see if there differences.
Comments
Post a Comment