Bug
Reconcile fails with error "Invalid Column Data Type".
| Bug ID Number | NIM047192 |
|---|---|
| Submitted | July 31, 2009 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 9.3.1 |
| Operating System | Windows OS |
| Operating System Version | 2003 |
| Status | Will Not Be Addressed |
Description
When attempting to perform a reconcile with ArcMap, the operation fails with the following error message:“The version could not be reconciled
Invalid column data type”.
Cause
The cause of the problem is ArcGIS does not support all database types. For example, ArcGIS does not support the ArcSDE datatype 'SE_INT64'. ArcGIS never creates any objectclasses and attribute types as SE_INT64.If the ArcSDE server configuration parameter INT64TYPES is set to true, then specific operations in ArcGIS, such as reconcile, will encounter invalid 'SE_INT64_TYPE' data types, and the operation will fail with the error message referenced above.
For more information on data types, see the link in the Related Information section below.
Workaround
Never enable the 'INT64TYPES' server configuration parameter. Always keep the value set to 0 (False).Steps to Reproduce
Bug ID: NIM047192
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App