I am currently sitting in a training class for BO, using MS SQL Server 6.0…monitoring so that nothing goes wrong. I was just paged by our DBA stating that the server had 24 connections to the universe domain (which is the number of students in the class), but 54 connections to the security domain???
Is there any reason why this is the case? All users are not doing anything at this point…shouldn’t it release the connection?
Tim
Tim K Heuer
PacifiCare Health Systems
(714) 825-5702 - office
(800) 946-4645 pin 1404017 - pager heuer_tk@exchange.phs.com
Is there any reason why this is the case? All users are not doing anything at this point …shouldn’t it release the connection?
I think you need to define your repository connection to disconnect after each transaction if that is what you want. I believe BusinessObjects will create a separate connection for the universe domain, but if that is on the same box it will create a second connection when it imports the universe. That way you could have more connections than people.
When you create the connection to the repository for the bomain.key, in the same window where you input the login parameters, go to the Advanced tab, and choose the Connection Property ‘Disconnect after each transaction.’
This should help keep the number of open connections to a minimum.
Regards,
Luis Gonzalez
From: Heuer Tim K [SMTP:Heuer_TK@EXCHANGE.PHS.COM] Sent: Monday, June 15, 1998 10:36 AM
I am currently sitting in a training class for BO, using MS SQL Server 6.0…monitoring so that nothing goes wrong. I was just paged by our DBA stating that the server had 24 connections to the universe domain (which is the number of students in the class), but 54 connections to the security domain???
Is there any reason why this is the case? All users are not doing anything at this point…shouldn’t it release the connection?
Unfortunately, you will have to recreate and redistribute the bomain.key. All the connections saved by BusinessObjects are encrypted, so the only ways to modify a connection are:
Through Supervisor/Tools/Repository for universe/document domain connections, and
Through Safe Recovery for the Security domain.
Regards,
Luis Gonzalez
From: Heuer Tim K [SMTP:Heuer_TK@EXCHANGE.PHS.COM] Sent: Monday, June 15, 1998 12:38 PM
How can I do this for the security domain without having to recreate the bomain.key. Is there a value in M_GEN_PAR that I can change?
Cc: ‘BUSOB-L@LISTSERV.AOL.COM’
In designer click “tool” then “connection”. Select your ODBC connection and “edit”. This is where you will find your advanced tab and make the changes!
From: Heuer Tim K [SMTP:Heuer_TK@EXCHANGE.PHS.COM] Sent: Monday, June 15, 1998 2:19 PM
What if the connection is already created and you already have a lot of users installed…is there any way to change it now?
When you create the connection to the repository for the bomain.key, in the same window where you input the login parameters, go to the Advanced tab, and choose the Connection Property ‘Disconnect after each transaction.’
This should help keep the number of open connections to a minimum.
Regards,
Luis Gonzalez
ass for BO, using MS SQL Server
6.0…monitoring so that nothing goes wrong. I was just paged by our DBA stating that the server had 24 connections to the universe domain (which is the number of students in the class), but 54 connections to the security domain???
Unfortunately, you will have to recreate and redistribute the bomain.key. All the connections saved by BusinessObjects are encrypted, so the only ways to modify a connection are:
Through Supervisor/Tools/Repository for universe/document domain connections, and
Through Safe Recovery for the Security domain.
Regards,
Luis Gonzalez
How can I do this for the security domain without having to recreate the bomain.key. Is there a value in M_GEN_PAR that I can change?
What if the connection is already created and you already have a lot of users installed…is there any way to change it now?