I have recently upgraded to BO5.1.6/webi2.7.2 from BO/webi SP3. I have a report with prompts. When I refresh the report, the prompt page displays normally. The buttons have ‘Show Values’ label. Now when I click on the ‘Show Values’ button in order to let the user choose from a LOV, The prompt page does not get refreshed and stays blank. I tried to refresh the page using ‘Refresh / F5’ from IE. The original prompt page displays. Now I again click on the ‘Show Values’ button. This time the label for the button changes to ‘Refresh List’ but the test box does not change to a list box(option box). The same report used to work in SP3.
I tried looking up the source for the prompt page and the ‘Show Values’ button seems to call /wi/bin/iswi.dll/cookie/wiqt/queryTechnique/GetDocWithParam. I guess this function(?) is in the WIQT exe.
Any ideas/suggestions wil be greatly appreciated. else I’ll open up a case.
First of all, welcome to Bob. It’s great to have you here.
Question: Is the LOV set to refresh on every use? The Designer may have left it blank, intending to set it to refresh on every use, but forgot to check that box. That’s where I would look first.
The LOV is not set to refresh before use. Even after setting that, it still doesnt give me the desired result. The whole purpose of the show values/refresh list button in the prompt screen is to allow dynamic refresh of the LOV, and moreover the same report with the prompts was working as intended in BO 5.1.3/webi 2.6.3. I am also getting some erratic behavior after clicking on the show values/Refresh list button. Sometimes only one prompt is shown (if there were 3 in total), sometimes the html file thats returned is not complete, i.e, I get the plain html code in place of the button and when I look at the source code fr the page, its incomplete.
Since I am working with a custome universe, I cannot reproduce this outside my environment. I will try to find some similar behavior with the beach universe and let you know.
I dont know if its a bug or not but here is what I found.
Whenever a user logs into webi, a new session folder is created in \bo\bo5.0\temp\sessions. When I refresh the document and the prompt page comes up, after clicking the show values button, an LOV file is supposed to get created in the \sessions folder. I tried using the beach univ and it works - i.e an LOV file is created and I am able to choose the values from the list. In my other report - which was not working - an LOV file does get created but the size is 0KB i.e, there is nothing inside that file. If you look into the LOV file, it contains the sql to retrieve the lov apart from the security things and the values themselves.
It seems that somehow even though the file is created, webi cannot create the data that is supposed to be in that file. and that is why I cannot get the LOV.
Then I used bo fat client to run the report and get the lov values. This is created in the \userdocs\universe\uniname folder. I copied the lov file to the webi session folder where the 0KB file exists. Then I ran the report and the prompt works perfectly - I get the LOV and can choose the value.
I also have the asp version of infoview. I tried the same report using the asp sdk app. It is also able to create the LOV file without any problems. My initial thought was that the user did not have create rights in the BO folder but the rights did exist. So it is not a question of rights.
I did these steps ensuring that there is no previously existing data in any of the folders inside the BO install directory.
The thing that confuses me is that it worked in case of the beach universe (local file) but is not working with my universe( repository based). and that is the reason why I cant say whether its a bug or not?
The problem is solved. It seems that Webi does not like async connections. Initially, my connections were sync but I had changed it to async. Due to this, the problem was occuring.
I had opened a case for this and the tech support guy mentioned this to me. Once I changed my connection back to sync, the problem was gone. So with Webi, ASYNC is NO-NO. He also mentioned that the next release of Webi/ZABO will probably suppot async connections (next year).
Using Designer, go to Tools…Connections…
Choose your connection.
Go to the Advanced tab.
Under Connection Mode you will see the setting for Synchronous and Asynchronous.
Well, actually, the setting is in the Connection’s setting – which the universe then uses.
In our case, most of our universes are built on a common connection. So if we change it for one, we’re actually changing it for all of those universes.
I’d have to presume that if the connection is sync for one universe, and async for another, that those universes must be built using different connections?
In Supervisor, you can set up a different connection for different users, or groups, for a specific universe. It would be nice if you could do the same for different applications. For example, if I want to access a universe using full client, it would use one connection, and if I access the same universe using Webi, it would use a different connection.
Yes, they were 2 different universes/connections…one is async, the other sync.
We did find that the problematic universe (the one with the sync connection) existed within 2 separate domains. When we deleted it from one domain, it worked in the other. Any idea why this has happened? And why is it the Async/Sync made no difference?
It’s great to have you here.
(BOB member since 2002-08-08)
and that is why I cannot get the LOV.
(BOB member since 2002-08-08)
(BOB member since 2002-07-10)
(BOB member since 2002-06-17)