on 05-29-2009 3:14 PM
Hi,
Trying to run BOXI 3.1 Web Intelligence report against a Oracle 11g database
and receiving a connection error:
A database error occured. The data error text is: (CS)
"Error on Connect". (WIS 10901)
Universe works fine in Rich Client and Desktop Intelligence whether run from the
server itself or from own desktop, but fails in Web Intelligence.
BOXI 3.1 is installed on Windows Server 2003 SP2 64bit and using
Oracle 11g (11.1.0.6) 32 bit client.
Any ideas?
Thanks.
Hi David,
Following solution might be helpful in resolving the issue.
Goto the Business Objects installation folder under .\Business Objects\Business Objects Enterprise 12.0\win32_x86\dataAccess\connectionServer
Make a copy of the file cs.cfg
Edit the file cs.cfg
Inside the section <JavaVM> </JavaVM> Add the following lines
<Options>
<Option>-xmx1024 </Option>
</Options>
Save the file
Restart Business Objects Services
Regards,
Sarbhjeet Kaur
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello everybody
Hello David
We have had a similar problem (SAP Forum
able to solve our issue with this solution.
Taken Steps to solve our issue:
-Uninstallation of the Oracle 11g (11.1.0.6) 32 bit client
-Installation and configuration of the Oracle 11g (11.1.0.7) 32bit
Client
Tests:
We have tested the Business Objects installation (especially WebI over
InfoView and the WebI Rich Client)
All tests were successful and we now also receive data with WebI over
InfoView.
Thanks for this information David.
Best regards,
Marc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for the response - but unfortunately it doesnt help.
Have discovered that 32bit InstallClient 11.1.0.7 works fine, so I'm assuming that
we've got something wrong with the install procedures/settings for the full client.
Thanks for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
First thing to know is that the BusObj Suite of products still is 32-bit software (except for HP-Ithanium) and uses 32-bit Client software to ALL databases.
So make sure you have installed and configured 32-bit database middleware properly, even on 64-bit OSes.
FullClient (DesktopIntelligence) uses different connection techniques thatn WebI does, so make sure you have properly configured (both on server and clinet) your database middleware.
Server processes run under specifig accounts, so make sure these accounts also have the DB-middleware configured properly...
hth, Walter
Having re-read your mail above, I think it has something to do with the services-account, which seems to not have configured the middleware, so check this first.
This means: use a specific service account for the SIA service. To check connectivity log in with the serice account and check connectivity by re-running the reports directly on the server (Rich Clint/DeskI).
Edited by: Walter Müllner on Jun 8, 2009 6:18 PM
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.