Copy Feature SQL DBMS Error Invalid Precision Value

[HollyZhang1]

I am using ArcSDE 10.2. I can only copy or export the line features from the feature dataset. And I got an error below as I copy the point features from the same feature dataset:

---------------------------
Paste Failed
---------------------------
Failed to paste route.DBO.RN_TollPoint
Underlying DBMS error [HY104:[Microsoft][SQL Server Native Client 11.0]Invalid precision value] [Road_Public.DBO.RN_TollPoint]
---------------------------
OK
---------------------------

Anyone can help?

Thanks,

[WilliamCraft]

I wonder if explicitly creating a 64-bit system DSN would help using the ODBC Administrator.  See the steps at the link below for the 64-bit ODBC tool:

http://technet.microsoft.com/en-us/library/cc645931.aspx

Use localhost\SQLEXPRESS as the instance name and see if it works. 

When connecting to SDE to copy the data, try using the DSN name.