Latest Contributions by EdwardBlair

crafty (Hope its ok to use that name) - I would love to buy you a beer if I ever get the chance.   The network build completed with the results I was expecting/hoping for. Thanks a million! Ed ... View more

This is not a production instance... I'll give it a try and keep you posted. Thanks again! Ed ... View more

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