Register  ::  Login
Update : April 18, 2019
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...
 Entity Locked
 10/26/2007 2:40:25 AM
User is offlinefba_sen57
74 posts

Entity Locked

Is there any other way to unlock an entity ? We have been experiencing this quite often now. I tried through the admin module to have all the 3 option available to unlock the session but to no avail. The entity is still locked. Anyone... please

Our company is currently using INtools version 6 (

 10/26/2007 7:45:02 AM
User is offlineadmin
179 posts

Re: Entity Locked

I agree with your statement that clear locking is not working very well in admin module.

there are two kinds of locking.

1. Oracle Locking lever – for unlock you need to restart the instance service or restart the Oracle server.

2. Intools Locking – when all the user out run the following command when you connect to domain schema:

    Truncate table current_info;




Ilan Hills
 10/26/2007 9:42:16 AM
User is offlinefba_sen57
74 posts

Re: Entity Locked

Dear Ilan,

In our company, I have no access to the oracle server terminal and therefore I have to inform the right person to restart the server. It normally works. The reason send you the query because I thought you may have other option.

Nonetheless, I run the suggested command and I have the error. See below. Any idea why?


Result Code:
The number of rows affected:
Database vendor's error code:
The database vendor's error message:
ORA-00054: resource busy and acquire with NOWAIT specified

The database-vendor specific:


 10/26/2007 10:50:48 AM
User is offlinewijnand
5 posts

Re: Entity Locked


make sure that everybody hasn't got INtools started up. This means that the table is busy and not available for you at the moment. If everybody left the database, you will be able to perform the truncate.


 10/26/2007 1:09:58 PM
User is offlinefba_sen57
74 posts

Re: Entity Locked
Thanks Wijnand. I have 85 domains for each our facilities. The locking is existed in one of the domain. Do you mean no users should login to that particular domain only or you mean no users should ever login to any of the 85 domains at any time during executing of the truncate statement. Also please explain what is that statement do to the unlocking issue. Have a good weekend to all.
  Aggregated  Discussions  General  Entity Locked...
 Search   Forum Home     

Search Engine Optimization and SEO Tools
My Google Pagerank