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
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
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 .
I did try loading using the Simple Data Loader . Still I am getting same error message
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
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?
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.
GEOGRAPHY are Microsoft datatypes. Best practice is to avoid SRID 0, and to use
the proper SRID value.
- V