Latest Contributions by WilliamCraft

Anytime, Ed.  I am only sorry I couldn't help to resolve the issue.  Enjoy your weekend! ... View more

Obvious question... but I need to ask... are you certain that this feature class was behaving correctly before the server crash?  If the answer is yes, then it looks like you should restore from a backup. ... View more

Do you get the same error if you try to export the feature dataset with the corrupt feature classes to a file geodatabase? ... View more

Is this a test or production database?  If it's a test database, make a complete backup and then let's try deleting the rows in the locks tables if you're comfortable doing that.  If it's a production database, then your safest bet is to use caution and open a support ticket with Esri.  Assuming this is a test database and you're comfortable with taking a full backup first, run the following in SQLplus after restarting your database once again (ensuring no ArcGIS client connections exist): TRUNCATE TABLE SDE.STATE_LOCKS; TRUNCATE TABLE SDE.TABLE_LOCKS; Then try to view the "bad" feature class(es) again in ArcCatalog.  ** Once again, I only suggest this on a test database after a full backup has been taken. ** ... View more

Ok, thanks.  Make a connection to your geodatabase now using ArcCatalog as the SDE user.  Once connected, right click the connection, open the Administration menu and pick Administer Geodatabase.  When the Admin UI opens, select the Locks tab and check if any locks are listed.  If they are (other than yours), right click then and pick Disconnect User.  Let me know the results. ... View more

Ok, let's do this... restart your Oracle database: SQLPLUS SYS/password@DATABASENAME as sysdba SHUTDOWN IMMEDIATE STARTUP Once the database is back up, make sure there are no ArcGIS connections from any clients including services.  You need to be absolutely sure there are no user or service connections.  Then re-run those 4 queries against the locks tables and let me know if the results are different. ... View more

Now that you've posted the additional info, can you disconnect all sessions from your geodatabase and then run the following queries in SQLplus and post the results? SELECT * FROM SDE.SDE_TABLE_LOCKS; SELECT * FROM SDE.SDE_LAYER_LOCKS; SELECT * FROM SDE.SDE_OBJECT_LOCKS; SELECT * FROM SDE.SDE_STATE_LOCKS; ... View more

Hi again, Ed.  I'm not sure if I'll be much help on this one, but let's see if we can at least try to get some more error reporting.  A few questions first though... Which version of Oracle? Which version is the geodatabase? Which version of ArcGIS Desktop? Which operating systems are involved?  One quick thing I'd like to verify is if you can actually query the tables in Oracle after making a SQLplus connection.  Open up a command prompt (I'm going to assume you're on Windows) and type the following; then let me know if the query returns a result: SQLPLUS username/password@DATABASENAME SELECT * FROM SDE.VERSION; ... View more

Hi William, I'm sorry to confuse you. I would like to secure services and expose them, over the internet, to users that do not have a user account in my network's windows active directory. I added them as a user in IIS, which provides them access to the web app, but what you're saying is that it's not possible to somehow pass the IIS windows log-in credentials to the secured services then, correct? When you say you added them as users in IIS, what are you referring to?  You might be able to achieve all of this, but I am curious to know why you wish to secure services yet expose them over the internet while trying to pass Windows credentials through.  It might be possible using impersonation and/or changing the application pool identity in IIS.  If those external users are not part of your organization or domain, and you want them to not have to input credentials when accessing the services, then I don't see how you can separate specific people from the rest of the world in terms of accessing the services.  Are you saying you want to set up named Windows accounts on the domain and allow those to be used as pass-through accounts when users make external requests to the website? ... View more

I'm unclear as to whether you're trying to secure services and expose them only on your internal network or if you're trying to make those secured services available over the internet.  When you say external users, are you talking about users who do not have a user account on your network's domain or are you talking about domain users who have an account but are working from a remote location (e.g., working from home) which is not part of a WAN?  For the former, you can't use secured services and expect anyone without a domain account to be able to access those services... on or off the network.  For the latter, users who are logged into the domain with a valid account should be able to see the services... they could do this by way of VPN.  I'm not sure who you consider to be 'external'. ... View more

So here is what I have gathered so far.  Can you please tell me if this is correct? Production Environment RDBMS: Oracle 11.2.0.1 ArcGIS for Desktop: 10.2.1 Geodatabase Version: 10.1 Test Environment RDBMS: Oracle 11.2.0.1 ArcGIS for Desktop: 10.2.1 Geodatabase Version: 10.1 (it would have to be the same since you're importing from production) From production, you export SDE schema into one or more Oracle dump files using EXP.  Then, you import the dump file(s) into your test database using IMP and no errors occur.  Is this right?  Please note that your Geodatabase version is not necessarily the same thing as your version of ArcSDE.  For example, you could have 10.2.1 ArcSDE command line tools but still have a 10.1 SP1 geodatabase.  I just to make sure that when you said "10.1" you are referring to your Geodatabase version and not ArcSDE tools.  ... View more

The process you described is something we follow as well, and it works fine for us.  The error you showed suggests the absence or invalidity of a particular package which is part of the SDE schema.  I am not sure why that is happening.  However, one thing to note is that Oracle 11g R2 (11.2.0.1) is no longer supported beginning at ArcGIS 10.2.1.  The 10.2 release of ArcGIS was the last supported release with your version of Oracle database.  What is the ArcGIS version of your geodatabase?  From what you posted initially, it looks like it could also be 10.2.1 in addition to your desktop software.  Are both Oracle databases at the same Oracle release? ... View more

Yes, you need to import the packages along with the data from the dump file before you can compile them.  The privileges above for the SDE user are system privileges and can be granted before the dump file is imported, with the exception of the GRANT EXECUTE lines which need to be run after the import completes but before the compiles are done.  I looked at your export command that you provided earlier and it seemed like you exported the entire SDE schema; but can you confirm that is the case? ... View more

Leo, is it possible that the user pasted a duplicate feature into layer X instead of setting layer Z as the target layer?  Maybe you already checked this and that's what you meant when you said it's not in either place from your perspective.  I would think that layer X would have shown 2 inserts if that were the case, but I just wanted to ask in case this might be the issue.  Do you have a way of checking layer X for a duplicate feature? ... View more

Awesome glad to hear it.  I was going to suggest a NETSTAT to check what app is using the port.  Can you please mark my post above as a correct answer? ... View more