Latest Contributions by EdwardBlair

ACTUAL UNDO SIZE:               8880 UNDO RETENTION:                    900 OPTIMAL UNDO RETENTION:  101895 I'm not an Oracle wiz - but it would seems my undo retention is much less than optimal. Ed ... View more

Thanks much for the reply.! I'm running Oracle 11.2.0.1.0. Result of SHOW PARAMETER UNDO are undo_management   AUTO undo_retention         900 undo_tablespace       UNDOTBS1 Ed ... View more

One further point of information that I just realized may be important.  There are two datasets in this instance.  One for gas and one for electric.  I had previously successfully created a geometric network for the gas dataset -- as the gas schema owner.  The error is now occurring when I try to create a network in the electric dataset.. as either the electric schema owner or as SDE. Is it possible that I now don't have permission to tables created when the first network was built? Ed ... View more

Just tried it as SDE.. same error. Any suggestions at all would be greatly appreciated. Ed ... View more

So, I've just encountered the same error in oracle with ArcGIS 10.0.  I'm executing this as the schema owner.  Would it be preferred to execute it as SDE? Thanks, Ed ... View more

So, I truncated all of the classes in the source File Geodatabase and then copied/pasted into SDE.  This worked. Then, after putting some data into one of the classes I found problems creating a spatial index on that class.  At one step along the way I got an error message pointing to an issue with the Oracle object sde.st_spatial_index.  I tried granting EXECUTE on this object to all users, including SDE and tried granting permissions to users per the SDE Admin guide.   Still got errors creating a spatial index. It may well be that the spatial index problem was what was preventing me from performing the copy/paste with a populated File Geodatabase in the first place. At any rate I found it best to just start over with the SDE database and so dropped all users and re-created the Enterprise Geodatabase.  Which seems to be working OK. Ed ... View more

I'm not sure that any of those errors are related to your issue, either.  That being said, I don't know enough about the timeline of when these errors occurred and when you attempted the copy/paste where it failed thereafter.  If you're using direct connect, the sdedc_Oracle.log file should be somewhere on your machine.  Are you using direct connect or the ArcSDE application service to connect to your enterprise geodatabase?  It would also be good to get the exact version of your RDBMS and ArcGIS/ArcSDE software before going any further. I don't have SDE installed on this machine. Its ArcGIS Version 10.1 and Oracle 11.2.0 Ed ... View more

I just found the Oracle alert log -- file is named alert_orcl.log.  Near the bottom is the following fragment that may be associated with the "Underyling DBMS Error" I experienced initially: Thread 1 advanced to log sequence 685 (LGWR switch)   Current log# 1 seq# 685 mem# 0: C:\APP\ED\ORADATA\ORCL\REDO01.LOG Thu Mar 20 10:53:07 2014 *********************************************************************** Fatal NI connect error 12638, connecting to: (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))   VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production   Time: 20-MAR-2014 10:53:07   Tracing not turned on.   Tns error struct:     ns main err code: 12638     TNS-12638: Credential retrieval failed     ns secondary err code: 0     nt main err code: 0     nt secondary err code: 0     nt OS err code: 0 Thu Mar 20 10:53:13 2014 AUD: OS Error = 1717 encountered while writing audit record Thu Mar 20 10:53:13 2014 AUD: OS Error = 1717 encountered while writing audit record opidcl aborting process unknown ospid (4676) as a result of ORA-28056 Thu Mar 20 10:53:13 2014 AUD: OS Error = 1717 encountered while writing audit record opidcl aborting process unknown ospid (6924) as a result of ORA-28056 Thu Mar 20 10:53:13 2014 AUD: OS Error = 1717 encountered while writing audit record opidcl aborting process unknown ospid (7624) as a result of ORA-28056 opidcl aborting process unknown ospid (8076) as a result of ORA-28056 Thu Mar 20 10:53:16 2014 AUD: OS Error = 1717 encountered while writing audit record Thu Mar 20 10:53:13 2014 AUD: OS Error = 1717 encountered while writing audit record opidcl aborting process unknown ospid (7164) as a result of ORA-28056 Not sure how to interpret this, though.  Since some of the messages refer the REDO log is it possible I need to increase size allocated to REDO logs? Ed ... View more

As a test I truncated all the tables in the File Geodatabase to see if I am encountering some size-related problem.  This also required that I drop the geometric network present in the FGDB dataset. After dropping the geometric network and truncating all tables in the File Geodatabase I was able to copy/past from the FGDB into the SDE database.  I take from this that my problem IS somehow related to the size of the database I'm trying to copy/paste. Ed ... View more

You're using direct connect to establish the connection to your enterprise geodatabase, right?  We need to capture the Oracle error code before knowing what the issue might be according to your database.  What does the following log file say? C:\Users\<your_user_ID>\AppData\Local\Temp\sdedc_Oracle.log What do your Oracle database Alert log files show? Typically located at C:\oracle\diag\rdbms\<db_name>\<db_name>\alert\log.xml Typically located at C:\oracle\diag\rdbms\<db_name>\<db_name>\trace\alert_<db_name>.log Note: Replace <db_name> with the name of your Oracle database SID. Thanks much for the suggestion! I am using direct-connect to connect to the Geodatabase.  However I don't see a file named "sdedc_Oracle.log" under \AppData\Local\Temp".  In fact, I searched my whole C:\ drive and can't find a file by that name. Ed ... View more

Copying and pasting a FGDB into SDE seems like a lot to ask.  My suggestion is  to import your feature classes from the FGDB into SDE with the import multiple feature classes utility. Joe - Thanks for the reply.   I've actually done this with success in the past.  Don't know why I'm getting the error now -- except that the dataset I'm trying to paste this time is a bit larger than others I've done in the past.   And I think I need to since the source FGDB has a geometric network that I'd like to keep - and not have to re-build in the Oracle database. Ed ... View more

Just to be clear.  What made the big difference in performance for me were two things: 1.  I reverted my target feature classes to core Esri objects.  They had inadvertently been left defined as custom object classes as required by the ArcFM application. 2.  Made use of a FeatureBuffer and InsertCursor to create the new features.  I flush the buffer after each 2,000 features. With these two changes the process that completes in 4 minutes for 120,000 features in a File Geodatabase completes in (about) 4 minutes in the Oracle database. Thanks again for the responses. Ed ... View more

A file gdb will almost always outperform an entreprise gdb.  The model is much, much simpler, you are just writing to a file on your hard drive.  As long as on-access scanner isn't killing the performance it will be much faster. For the code side, I would consider not using an edit session or at least not use an edit operation if you can get away with it.  The option to turn off the undo/redo doesn't always work (Note that the supression of undo/redo logging is not supported for remote database workspaces.)  I would consider using an insert cursor and calling flush every so many records (100? something to experiment with.)  CreateFeature for sure will create an objectId for each call when it is called so, right there sql statements are being generated one at the time... I suggest you look at the following link and avoid creating the features one by one.  There are more direct ways of doing this.  If you need to process the data, you can do that in the fgdb and then load. http://help.arcgis.com/en/sdk/10.0/arcobjects_net/conceptualhelp/index.html#//0001000003rp000000 From the database side, a lot can be done tweak the performance.  The trick is to know what is holding you up.  Do you have versioning?  How big is the user temp space?  What is going on with the roll back log?  Do you have replication?  These are some of the  many things you need to master to get performance out of your database. A good orace DBA can be invaluable in figuring out performance on the Oracle side.  You can also consider using spatial SQL to insert the features directly through the SQL geodatabase API http://resources.arcgis.com/en/help/main/10.1/index.html#//006z00000008000000 I have also dabbled in exporting recordsets into XML and importing them as a new featureclass in Oracle, maybe that can work for you.  Variable size sample sets, some good metrics and some experimentation, I think you will find an efficient way of doing this. Alexander - Thanks very much for your comments and suggestions.  While investigating some of the options you put forth I had a breakthrough.  I tried to use the ArcCatalog simple data load and found it to fail.  At that point I realized my classes were registered for use with the ArcFM software -- custom GeoObjects.  I unregistered the classes and found performance improve dramatically.  I'm not quite at the speed of the FGDB -- but pretty close to it. Thanks again - you pointed me in the right direction! Ed ... View more

Using IFeature.Store is the slowest way to save changes to a gdb if you're making large numbers of edits.  Instead, use IFeatureclass.Update to get an update cursor and call IFeatureCursor.UpdateFeature where you would normally call Store.  For creating new features, use IFeatureClass.Insert to get the cursor and IFeatureCursor.InsertFeature.  Also, before you start, place the feature classes you're writing to into LoadOnly mode using IFeatureClassLoad.  Take them out of LoadOnly mode when you're done. Neil - Thanks for the reply.  As my post says, I'm not using IFeature.Store.  I've tried using an insert cursor, as well as WriteFeature and WriteFeatures from the IFeatureClassWrite interface.  All are equally slow.  My example also shows that I'm using LoadOnly mode. Forgot to mention that I've removed all indexes from the target class -- except that for ObjectID.  And I've remove all relationships.  The target is also a simple point feature class - no network or topology defined. Ed ... View more