I'm running an Alteryx workflow where I am pulling data from one database to another PostgreSQL database containg PostGIS. However, when I run the workflow and write the data to the database, I am getting an error saying:
Output Data (18) DataWrap2ODBC::SendBatch: ERROR: WKB structure does not match expected size!;¶Error while executing the query Insert into "table_name"("column_1","column_2","column_3","geom") Values (?,?,?,ST_GeomFromWKB(?,4326))
or in other words, the error is saying that WKB structure does not match expected size
. There is a geometry or Spatial Object column in the database that I am trying to send to PostgreSQL..
I thought it might be the Spatial Object Field Size (it's too small) but when I increased it, it didn't do anything. Does anybody know why I am getting this error and how to fix it?
EDIT: This is how the geom table looks like that I am trying to insert into my PostgreSQL PostGIS table:
\d table_name
in psql? ForInsert into "table_name"("column_1","column_2","column_3","geom") Values (?,?,?,ST_GeomFromWKB(?,4326)
, can you give use one sample for the value that should replace the question mark fromST_GeomFromWKB(?,4326)
? Edit your question the infos. Thanks