laptop and a wrench

Error

The PostgreSQL OLE DB Provider within ArcCatalog's Add OLE DB Connection does not properly translate the objectid of a Postgres database table to the Data Type of OBJECTID.

Última publicación: August 25, 2014 ArcSDE/Enterprise Geodatabase
Número de ID del error NIM074415
EnviadoOctober 21, 2011
Última modificaciónJune 5, 2024
Relacionado conArcSDE/Enterprise Geodatabase
Versión encontrada10.0
EstadoWill Not Be Addressed

Información adicional

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

Solución alternativa

1. In ArcMap select file > Add Data > Add Query Layer.2. When the Make Query Layer dialog box appears, select Connections > New > (Fill in Parameters) > Test Connection > OK > OK. 3. Select the table name you wish to use under "List of Tables".4. Where it reads "Name:", type a name for the layer to be created.5. Under Query type: select * from TableName. Note: replace TableName with the actual name of the table 6. Select Finish. The table should appear within the ArcMap table of contents.7. From within the ArcMap table of contents right-click the table and select Properties > Fields tab and select objectid. You will notice on the right side of the dialog box the Data Type will read ObjectID.

Pasos para reproducir

ID del error: NIM074415

Software:

  • ArcSDE/Enterprise Geodatabase

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga