Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

WAI Nepal Reservoir data upload failed #386

Open
ifirmawan opened this issue Aug 1, 2023 · 0 comments · Fixed by #387
Open

WAI Nepal Reservoir data upload failed #386

ifirmawan opened this issue Aug 1, 2023 · 0 comments · Fixed by #387
Assignees

Comments

@ifirmawan
Copy link
Collaborator

ifirmawan commented Aug 1, 2023

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'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant