Business Objects deployment in citrix metaframe 1.8

[chunfo65]

Currently testing how Business Objects (5.1.6) works in Citrix (Metaframe 1.8), and have run into the following errors:
"Cannot acess network layer. (USR0046)"
and
Server Error (USR0057) " Cannot access the connection driver (SBO0009)Oracle OCI

Allows initial user to logon and work ok, but as soon as a second user tries to logon to it, they get the messages.

Anyone have any suggestions?

 

[burkek]

Sounds like an Oracle Call interface problem. Is your OCI setup properly on Citrix. I believe your oci.h file needs to be linked properly with your oci.lib?
Typically, the type of error message you recieved indicates a problem with this?
Hope if points you in the right direction?
Here is a link to Oracle's Tech Net documentation:

http://technet.oracle.com/doc/server.804/a58234/toc.htm

 

[chunfo65]

Thanks for the quick reply, i'll check into the Oracle stuff.

 

[Subhashab]

Hi ,
Check with the Oracle issues. But can u clarify this for me. U have installed BO on the Citrix server and the user are accessing BO from the server right.

 

[chunfo65]

Hello Subhashab,
Yes we have BO installed on a citrix server, and the users are accessing it through citrix.
I was reading some of the documentation that BO sent us, and found that according to them:
Citrix Metaframe 1.8 is not supported with BusinessObjects 5.1 / WebIntelligence 2.7 through "Windows 2000 Professional, Server and Advanced Server".
which is how we have it set-up, so we might just have to use Metaframe XP for the test instead.

 

[Subhashab]

when each user loins into BO they modify the .lsi file. The second user is getting the error because it is not able to lock the .lsi file for it use. U have to install Bo using shared setup this will create the file necessary to share BO.

In one of my client site I had installed BO on the NT server. And i would load the Bo registery node created from the server on each individual PCs. create a local bo folder with locData, universe and userdocs. the i would run setup and moify the entries to point to the local folders. this was done using 4.1.3.
only problem was i had to copy bomain.key to all clients.

 

[deaco]

Subhashab is right about the file permissions and has got the right idea to fix this. Although BOj says that 1.8 isn't supported it does work with the later versions of BOj. You need to set-up Business Objects on the server with a Shared setup because of the LSI file problem. Can't have two people using the same file. You'll also get a lot of other problems with amoung other a Message 'Updating Security Settings'. This is again all to do with the .Key and .LSI files.

 

[JeffersonH]

I do got to ask...is there some reason you're not using WebI with ZABO? tmp.Worldwide
Business Objects 5i
Systems Integrator
Pfizer Global Research and Development

 

[deaco]

Because WEBI is far to limited an application I would imagine. It was for us so we choose Full Client. We have a mix of application in the business anyway. The application that fits the task is one we use, we don't try and make something fit if there is the application there already.

If V6 WEBI is as good as they say it is (not not just in their demonstration databases, Yes I have seen it and read the paperwork on it and played with it) then we will migrate fully but as you wrote (JeffersonH) in another thread it takes them 3 releases to get something that works. Based on a 6 monthly release rate of SP's. That's another 18 months so that takes it to end of 2004/start of 05 before we get a version that has more working than not working in it.

 

[bob1000]

What I have done is write a logon script that copies all the relevant user files to the users H drive (if they are not there already)- this means the users have all their own 'stuff'. This also requires for the location of these folders to be changed under the server LOCAL_MACHINE key to H:\Business Objects (or whatever). We have deployed to 150 users over the last 4 months and have encountered no issues whatsoever, and these users are heavy duty. The only question still remains is how many users we can get onto each Citrix server because the application uses a lot of memory (to store queries) and processing when running queries. Hope this isn't too late to help!!

 

[JeffersonH]

deaco...

ZABO is the full client, invoked from WebI. The benefit is that by going through WebI and invoking ZABO you can share resources, better optimize database access, and manage the look, feel, and presentation of user elements.

By using a WebI server with ZABO you can manage user personal docs from a file share rather than relying on their unbacked up local folders. We're on 5.1.3, making a slow ramp up to 5.1.7 and the WebI/ZABO interface works very well.

But our main reason for using ZABO is the same as yours: the limits on WebI presentation. But using WebI for the interface is a major performance boost.

You can package and SMS the ZABO package so that you don't need to take activex through the firewall.

tmp.Worldwide
Business Objects 5i
Systems Integrator
Pfizer Global Research and Development

 

[deaco]

This a really long reply sorry folks

JeffersonH

I probably didn't make it all that clear from my messages but they were from experience from a much earlier version of the bespoke application that we use.

We originally had a full client system not Zabo or WEBI that was driven by a web screen that had document links essentially.

We have moved since then to a WEBI interface with Full Client/ WEBI interface with Zabo (Which although took a lot of issue away was still far to slow)
, then onto Full client reports refreshed through BCA producing HTML versions of the reports(Not necessarily actually producing the html though
, in this case the html is produced on request but the cube has already been refreshed),
the last process is very fast as all you are ever doing from a user point is opening a html page,
but there is the BIG issue of BCA servers, can't get enough of them for the batch window.(will explain situation at the end).
With all of these you have the presentation available from Full Client,

Then we moved onto Refresh on Open Full Client reports that produce the html on request as well.
This works well but is a strain on the webi server.
So then onto WEBI,
so now we have WEBI reports, some of which are refreshed on open, along with some of the other systems that will eventually be phased out.

Full Client Refresh on Open with the right work and the same data cube IS as quick as a Webi report that is refresh on open,(within 1 second on a webi report that takes 10 seconds).
With the consideration that 80% of Business Users are not bothered about functionality as long as they can drill down to the report level that they want,
they don't want to be able to rank, sort, place their own alerters, put on their own filters etc, etc, etc. they just want the figure to be there as quickly as possible why use WEBI,
use Full Client with either refresh on open or through BCA, that way you get all the functionality available to developers and the presentation of Full Client.
(This only works for the right situation, and no work place will fit 100% to this model so you have to have be-spoke systems that allow different users different abilities)

So lets get this right, WEBI NO quicker, less functionality for developers within WEBI, no presentation qualities.
So what is better with WEBI than with Full Client reports, the only thing that I have found when just viewing reports (not users creating them) is that you can fit easily
25 -> 50 (in some instances upto 100) WEBI users to every one Full Client User, business objects quote I think 1000 WEBI to 1 Full Client, I haven't seen this in the real
world though

It's all about getting the right mix of application for the type of user, most people in this forum have got this though you being one of them.

Just to give you some stats:
We have about 2000 view only users
about 500 WEBI report creators and advanced users
about 250 Full Client view and amend users
about 150 Full Client complete functionality users
about 10 Business User developers no designer though
about 5 Full time Business Objects Developers with Designer
3 application specialists covering the bespoke WEB application, Business Objects (all the strains of the application from Full Client thru webi and supervisor etc etc) and the BO infrastructure, so configuration and initial deployment of hardware)
I am one of the three.

All of that is just BO nothing to do with Database users and the support of the users

Our BCA servers run approx 1000 reports most nights and produce about 1.6 million pages of HTML in about 5-6 hours. That's why we are going more refresh on open and more webi
only trouble is that about 1500 of the 2000 view only users work off the end of what is essentially a 56kps modem connection so the performance is critical.