Esri / geoportal-server-harvester

Metadata Harvester for Esri Geoportal Server
http://esri.github.io/geoportal-server/
Apache License 2.0
31 stars 24 forks source link

Failed to remove task/execute task #178

Closed tom62291 closed 4 months ago

tom62291 commented 2 years ago

image

Hello, I have change the config point to a postgresql and place the jdbc postgresql jar in lib folder. I can succesfully add/edit/delete brokers. I can succesfully create task.

However, I cannot execute task or remove the task. Please help.

image

mhogeweg commented 2 years ago

do you get messages in the harvester log when trying to remove the task? or else in the browser console/network responses?

tom62291 commented 2 years ago

Hi, there is no special log message from the network response or even the log file

Attached my log config, log output and network response.

image image image image

tom62291 commented 2 years ago

Hello, I just find CLOB is not support in PostgreSQL. Any guideline for user if we want to use PostgreSQL?

mhogeweg commented 2 years ago

oh wait, are you trying to make postgresql the database where harvester stores the brokers/task information? That is an untested configuration. I thought you were trying harvest from PostgreSQL.

tom62291 commented 2 years ago

yes