search

akvo / wai-sdg-portal

Wash Dataportal for WAI SDG
GNU Affero General Public License v3.0
1 stars 4 forks source link

WAI Nepal Reservoir data upload failed #386

Open ifirmawan opened 1 year ago

ifirmawan commented 1 year ago

Data validation success email

Scherm_afbeelding 2023-07-31 om 13 29 05

Data upload failed email

Scherm_afbeelding 2023-07-31 om 13 29 21

and status in jobs table still "on progress"

Screenshot 2023-08-01 at 09 18 58

Logs

JOBS #4 IS SUCCESSFULY VALIDATED
wai-sdg-portal-worker-1 | JobStatus.on_progress
wai-sdg-portal-worker-1 | DATA SEEDER STARTED
wai-sdg-portal-worker-1 | SEEDER ERROR (psycopg2.errors.UndefinedFunction) operator does not exist: character varying = integer
wai-sdg-portal-worker-1 | LINE 3: WHERE data.name = 51102002
wai-sdg-portal-worker-1 |                         ^
wai-sdg-portal-worker-1 | HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
wai-sdg-portal-worker-1 |
wai-sdg-portal-worker-1 | [SQL: SELECT data.id AS data_id, data.name AS data_name, data.form AS data_form, data.administration AS data_administration, data.geo AS data_geo, data.created_by AS data_created_by, data.updated_by AS data_updated_by, data.created AS data_created, data.updated AS data_updated, data.submitter AS data_submitter
wai-sdg-portal-worker-1 | FROM data
wai-sdg-portal-worker-1 | WHERE data.name = %(name_1)s
wai-sdg-portal-worker-1 |  LIMIT %(param_1)s]
wai-sdg-portal-worker-1 | [parameters: {'name_1': 51102002, 'param_1': 1}]
wai-sdg-portal-worker-1 | (Background on this error at: http://sqlalche.me/e/13/f405)
wai-sdg-portal-worker-1 | JobStatus.on_progress

SEEDER ERROR 'NoneType' object has no attribute 'name'