BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

BO Connectivity Question


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Tue Sep 15, 1998 8:21 pm 
Post subject: BO Connectivity Question



Mike Malone@CONTEXT
09/15/98 06:21 PM

We have a large user base (800+) and are concerned about the best way to set the universe connections. I have suggested that the connection parameters be set to remain active for 10 minutes (to avoid the overhead of continually connecting and disconnecting). The dba has asked me what happens to those connections if the server or network go down. Will BusinessObjects maintain those connections (even though they are invalid) or will it recognize that the connections have been broken and try to establish new ones when the server comes back up?

Oracle 7.3 BO 4.1.3


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Wed Sep 16, 1998 7:26 am 
Post subject: BO Connectivity Question



Hi Mike,

>From what I observed, if you establish a connection to remain active for 10
min or continually and the system goes down, you will not automatically get reconnected. If you disconnect each time, then you will reconnect.

David Morgan
Managing Consulting
212-626-2626

>Mike Malone@CONTEXT
>09/15/98 06:21 PM

>We have a large user base (800+) and are concerned about the best way to set the universe connections. I have suggested that the connection parameters be set to remain active for 10 minutes (to avoid the overhead of
>continually connecting and disconnecting). The dba has asked me what happens to those connections if the server or network go down. Will BusinessObjects maintain those connections (even though they are invalid) or will it recognize that the connections have been broken and try to establish new ones when the server comes back up?

>Oracle 7.3 BO 4.1.3



_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Thu Sep 17, 1998 2:57 am 
Post subject: BO Connectivity Question



Mike,

I've experienced the following:
When the server goes down (or the oracle proces thats doing the query gets killed by a DBA) you get the "end of file on communication channel". Depending on your connection settings when the server comes up (or immediately after if it was just your proces being killed), you can reconnect immediately if the setting is reconnect every time, but have to wait a while if your connection is expected to be open by BO (until it was due to be closed and you didn't do anything in that time with the server). If you go as far as keeping it open for 10 minutes, the user is faster by exiting BO and restarting, then BO will reconnect normally.

Greetings,
Marianne Wagt
IDETA
The Netherlands


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0278 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0242)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo