topic Error when copying data from SDE 9.3 to 10.2.1 in Data Management Questions

Error when copying data from SDE 9.3 to 10.2.1

VikramS — Fri, 28 Feb 2014 16:13:27 GMT

Hello,

I am getting below error when trying to copy sde data from 9.3.1 to sde 10.2.1 .

Underlying DBMS error [HY104:[Microsoft][Sql Server Native Client 11.0] Invalid precision value][Feature Class Name]

Can anyone tell me how can i fix this ?

Thanks

Re: Error when copying data from SDE 9.3 to 10.2.1

WilliamCraft — Fri, 28 Feb 2014 16:22:21 GMT

Is your data stored as low precision? You can check this by looking at its properties from ArcCatalog. I would think that copying and pasting the data would automatically create the data at high precision in the 10.2.1 database, though. What happens if you create an empty feature class in the 10.2.1 database with the same exact field structure as what's stored in 9.3.1 and then use the Simple Data Loader to import the records?

Re: Error when copying data from SDE 9.3 to 10.2.1

VikramS — Fri, 28 Feb 2014 16:40:46 GMT

Thanks William for replying quickly 🙂

Source : 9.3.1 SDE
Target : 10.2.1 SDE

Source Storage type is High Precision using ESRI Binary Spatial Type

Target Storage type is High Precision using ESRI Geometry spatial Type (SRID 0)

The weird thing is I am able to copy another feature class from source to target withoout any problem .

Re: Error when copying data from SDE 9.3 to 10.2.1

WilliamCraft — Fri, 28 Feb 2014 16:43:17 GMT

So it's just that one feature class causing issues; might be something with one or some of the records in that feature class. Can you try loading the data using the method I described above for that one feature class? In ArcCatalog, right click the 10.2.1 feature class and click Load, then pick your source 9.3.1 fature class and map the fields. Usually, if there are issues with specific records, the Simple Data Loader will list the OBJECTIDs so you know what needs to get fixed.

Re: Error when copying data from SDE 9.3 to 10.2.1

VikramS — Fri, 28 Feb 2014 16:51:31 GMT

Hello William,

I did try loading using the Simple Data Loader . Still I am getting same error message

Re: Error when copying data from SDE 9.3 to 10.2.1

WilliamCraft — Fri, 28 Feb 2014 16:51:34 GMT

One more thing, please provide the exact version of SQL Server you are using (Express 2008R2, Enterprise 2012, etc.). Hopefully you are not using SQL Server 2005. ArcGIS 10.2.1 supports versions of SQL Server 2008 and 2012 but does not support SQL Server 2005.

Re: Error when copying data from SDE 9.3 to 10.2.1

VikramS — Fri, 28 Feb 2014 16:55:32 GMT

William,

Target (10.2.1) is using SQL Server 2012 . Source (SDE 9.3) is using SQL Server 2005 .

Is that a problem then ? But it is able to copy another feature class from source to target

Re: Error when copying data from SDE 9.3 to 10.2.1

WilliamCraft — Fri, 28 Feb 2014 17:01:37 GMT

It might be a data type issue with that particular feature class whereby SQL Server 2012 doesn't like something from SQL Server 2005. For the problematic feature class, perform an SDELAYER -O DESCRIBE_LONG in 9.3.1 SDE command line:

sdelayer -o {describe | describe_long} [{-O <owner | -l <table,column>}]
[-i <service>] [-s <server_name>] [-D <database>]
-u <DB_User_name> [-p <DB_User_password>] [-q]

Maybe do another describe_long on a feature class that you know copies fine to see what the difference could be.

Also, what does SQL Server 2005 say its backend data types are for the various columns in the problematic table?

Re: Error when copying data from SDE 9.3 to 10.2.1

VikramS — Fri, 28 Feb 2014 18:27:13 GMT

William,

This is gonna sound weird .

Initially I was using Arcmap 10.2.1 (System A) but now I tried in another system with Arcmap 10.1 . It worked . I think it is because of the different sql server native client.

Re: Error when copying data from SDE 9.3 to 10.2.1

WilliamCraft — Fri, 28 Feb 2014 18:44:48 GMT

This isn't surprising, actually. Glad you got things working. After the initial copy, you should be able to manage all of your data moving forward with the 10.2.1 client and your SQL Server native client on 'System A'.

Re: Error when copying data from SDE 9.3 to 10.2.1

VinceAngelo — Fri, 28 Feb 2014 20:03:02 GMT

FYI: There is no such thing as an "Esri Geometry spatial Type" -- GEOMETRY and
GEOGRAPHY are Microsoft datatypes. Best practice is to avoid SRID 0, and to use
the proper SRID value.

- V