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)."