topic Re: Failed to paste <dataset> in Data Management Questions

Failed to paste

EdwardBlair — Thu, 20 Mar 2014 14:25:58 GMT

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

Re: Failed to paste

JoeBorgione — Thu, 20 Mar 2014 14:54:23 GMT

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.

Re: Failed to paste

EdwardBlair — Thu, 20 Mar 2014 14:58:34 GMT

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

Re: Failed to paste

EmadAl-Mousa — Thu, 20 Mar 2014 16:03:43 GMT

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

Re: Failed to paste

JoeBorgione — Thu, 20 Mar 2014 16:29:53 GMT

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.

Re: Failed to paste

WilliamCraft — Thu, 20 Mar 2014 16:53:13 GMT

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.

Re: Failed to paste

EdwardBlair — Thu, 20 Mar 2014 18:43:52 GMT

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

Re: Failed to paste

EdwardBlair — Thu, 20 Mar 2014 18:50:33 GMT

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

Re: Failed to paste

EdwardBlair — Thu, 20 Mar 2014 18:57:22 GMT

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

Re: Failed to paste

WilliamCraft — Thu, 20 Mar 2014 19:21:43 GMT

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.

Re: Failed to paste

NidhinKarthikeyan — Thu, 20 Mar 2014 22:37:27 GMT

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

Re: Failed to paste

EdwardBlair — Thu, 20 Mar 2014 23:03:51 GMT

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

Re: Failed to paste

EdwardBlair — Sat, 22 Mar 2014 14:59:00 GMT

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

Re: Failed to paste

AsrujitSengupta — Sat, 22 Mar 2014 21:39:22 GMT

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