Failed to paste <dataset>

[EdwardBlair]

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

[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).

[EdwardBlair]

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

[EdwardBlair]

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

[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