Register  ::  Login
 
Update : February 07, 2012
Google AdSense Minimize
  
Welcome to Asbuilt-DBA forum ! Minimize

Here you can find a community of professionals who work with INtools® (SPI) and want to interact and exchange information, including problems encountered, offer solutions, and raise new topics.

This forum is composed of two main sections:
1.      Discussions, which is an open discussion forum where you can talk about any related topic to INtools.
2.      FAQ section that offers a variety of questions and answers regarding INtools.
We hope that you will enjoy participating in this forum. Participation in the forum is free of charge.
If you want to start a new forum, please contact the Webmaster.
Add to Google
INtools is trademark of Intergraph corporation
Forum Groups Minimize
SearchForum Home
  Aggregated  Discussions  General  Entity Locked...
 Re: Entity Locked
 
 10/30/2007 1:10:56 AM
User is offlinefba_sen57
73 posts
www.shell.com


Re: Entity Locked

Thanks Ilan.

I take note of your reply.

Just wander, this locking only happen to one same person. I have 100 plus users under my caring in 3 different design consultant and in-house users as well. Consultant connect to INtools server via Citrix connection managed by Oracle team while in-house users connects directly.

From your statement above "If you use Citrix It might the Citrix server terminate the connection when it’s not use for a while. It might also the local machine lost the connection when when it’s not use for a while."  If this is the case, I would have to solve this locking every now and then (non-stop) but this is not the case. It happen only to one same person. What I have done at this time is to advise the user to disable his screen saver and wait if the locking can happen again. If I did not have any news of the locking then I assume it was the screen saver that had caused the locking. Just bear with me and will inform for any recurrences.

 10/30/2007 8:29:18 AM
User is offlineadmin
177 posts
5th


Re: Entity Locked

Since it’s only one problematic  user I like to check if it’s not a problem with ConnectionID

Please connect to the database as in_dbamn/in_dbamn and run the following after the problematic user

Login to Intools:

Select * from intools_connection;

Let  me know what is the problematic user login.

Send the results to as excel file to

admin@asbuilt-dba.com

 

When this user kicked off from Intools run this query again and send me the result.

 

Ilan


Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 10/31/2007 6:17:01 AM
User is offlinefba_sen57
73 posts
www.shell.com


Re: Entity Locked
Ok Ilan. I have send you the excel file. What are you trying to see in that file? Let me know the understanding of it.
 10/31/2007 6:59:49 AM
User is offlineadmin
177 posts
5th


Re: Entity Locked

In version 6 the license and connection manage in the Intools_connection table(ver 7 manage the license in different way)

Connt_2 column is unique ConnectionID from the Registry or Intools.ini

When the user connect to Intools the system add him in the max Connt_Id  column where Connt_Next_Id >0 and add there unique

Connect number.

When the user disconnect from Intools the system change the Connt_Next_Id to 0.

If the user kicked out from Intools the Connt_Next_Id is not change to 0 and the system count this connection

For the number of license.

When the user connect again with the same ConnectionID and Connt_Next_Id >0 the system overwrite the  exist row (same Connt_2).

From the Excel file  that  you sent me looks like the user is not connect right now.

The max number of user who connected to Intools was 22 (If the license number is less then 22 probably the last user kicked out)

 

Ilan


Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 10/31/2007 8:18:44 AM
User is offlinefba_sen57
73 posts
www.shell.com


Re: Entity Locked

Thanks Ilan. She is not connected today. I can check via our Admin -> DBA -> "Connection List" or I can "shadow" through the Citrix Neighbourhood.

Currently our licenses are 27. So if we reach the maximum, the system will obviously as we understand prompt the user of maximum users are reached.

  Aggregated  Discussions  General  Entity Locked...
Intools
 Search   Forum Home     

Search Engine Optimization and SEO Tools
My Google Pagerank