Select to view content in your preferred language

Error when publishing layers in bulk from data store - Invalid column data type

436
0
10-25-2022 09:35 AM
Strahanjen
Frequent Contributor

We are running ArcGIS Enterprise 10.9.1 and are connecting to a database server running Postgres13.6/Postgis 3.2. I'm able to add the data store to Portal using the .sde connection file, but when I try to create the layers in bulk, I get this message in Portal, "An unknown error occurred. The operation may not have completed successfully."

I looked in the the ArcGIS Server logs for more information and see the following error which mentions an invalid column data type. How might I track down which column/table is causing the error?  Any other suggestions for troubleshooting this and getting our layers to load? 

"Error executing tool. Publish Datasets In Data Store Job ID: j528bdb98ba9a4b74a71cf99b21f4396e : ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. Invalid column data type Failed to execute (Publish Datasets In Data Store)."

0 Kudos
0 Replies