nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Failed to paste <dataset>

BlairServicessLLC

Hello -

I'm trying to copy/paste a File Geodatabase into an Oracle SDE Instance running in Windows 7. There are 61 classes in the FGDB. When it hits about the 6th class I get the error:

Failed to paste <dataset>
Underlying DBMS error

From there I'm trying to find out what kind of error was encountered. I've looked in the Windows Event Viewer but can't find anything there. Is there another location where I could find more details about the error?

Thanks,
Ed

Vind meer berichten getagd met

Accepted answers

All comments

AsrujitSengupta

Ed,

If you are still interested in trying, you can try the "Export XML Workspace Document" tool. It maintains the geometric networks, topologies, relationship classes, etc as well.

Export XML Workspace Document (Data Management)
http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000015s000000

BlairServicessLLC

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

BlairServicessLLC

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

NidhinKarthikeyan

Is it feasible to try this:

Delete the Geometric Network from File Geodatabase, copy-paste the Feature Dataset to ArcSDE Geodatabase, and Create Geometric Network (In ArcSDE Geodatabase).

WilliamCraft

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.

BlairServicessLLC

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

BlairServicessLLC

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

BlairServicessLLC

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

WilliamCraft

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.

JoeBorgione

FeatureDatasets in SDE spell trouble for me. I wonder if somebody is using the data within the featuredataset within the fgdb and that's the cause of your error. Is it published?

I really suggest re-thinking using anything within a featuredataset in SDE. The problem with locks and permissions make them a problem child.

EmadAl-Mousa

when you pasted to the sde geodatabase , what configuration keyword have you chosen ?

BlairServicessLLC

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

JoeBorgione

Hello -

I'm trying to copy/paste a File Geodatabase into an Oracle SDE Instance running in Windows 7. There are 61 classes in the FGDB. When it hits about the 6th class I get the error:

Failed to paste <dataset>
Underlying DBMS error

From there I'm trying to find out what kind of error was encountered. I've looked in the Windows Event Viewer but can't find anything there. Is there another location where I could find more details about the error?

Thanks,
Ed

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.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.