search

avniproject / avni-etl

GNU Affero General Public License v3.0
0 stars 6 forks source link

Shelter ETL not working inspite of regenarating it #72

Closed nupoorkhandelwal closed 1 year ago

nupoorkhandelwal commented 1 year ago

Ticket: https://avni.freshdesk.com/a/tickets/3089

Shelter ETL was not reflecting changes since 19th of September, and to fix this we tried creating it with the command available on readme. But it is still failing and is not clear what is the issue and the resolution.

Console log from integration server-

Error in job run
org.quartz.JobExecutionException: org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table shelter.family_member_menstrual_hygiene ("id" integer, "uuid" text, "is_voided" boolean, "created_by_id" integer, "last_modified_by_id" integer, "created_date_time" timestamp with time zone, "last_modified_date_time" timestamp with time zone, "organisation_id" integer, "individual_id" integer, "address_id" integer, "enrolment_date_time" timestamp with time zone, "program_exit_date_time" timestamp with time zone, "enrolment_location" point, "exit_location" point, "legacy_id" text, "latest_approval_status" text, "Do you want to enroll in our Menstrual hygiene program ?" text, "Comment if any ?" text, "Have you received a Cup from SA ?" text, "If Yes, Have you understood the Use of Cup ?" text, "Last month's period date." date );
grant all privileges on all tables in schema shelter to shelter;
grant all privileges on all sequences in schema shelter to shelter;
]] [See nested exception: org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table shelter.family_member_menstrual_hygiene ("id" integer, "uuid" text, "is_voided" boolean, "created_by_id" integer, "last_modified_by_id" integer, "created_date_time" timestamp with time zone, "last_modified_date_time" timestamp with time zone, "organisation_id" integer, "individual_id" integer, "address_id" integer, "enrolment_date_time" timestamp with time zone, "program_exit_date_time" timestamp with time zone, "enrolment_location" point, "exit_location" point, "legacy_id" text, "latest_approval_status" text, "Do you want to enroll in our Menstrual hygiene program ?" text, "Comment if any ?" text, "Have you received a Cup from SA ?" text, "If Yes, Have you understood the Use of Cup ?" text, "Last month's period date." date );
grant all privileges on all tables in schema shelter to shelter;
grant all privileges on all sequences in schema shelter to shelter;
]]]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:218)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table shelter.family_member_menstrual_hygiene ("id" integer, "uuid" text, "is_voided" boolean, "created_by_id" integer, "last_modified_by_id" integer, "created_date_time" timestamp with time zone, "last_modified_date_time" timestamp with time zone, "organisation_id" integer, "individual_id" integer, "address_id" integer, "enrolment_date_time" timestamp with time zone, "program_exit_date_time" timestamp with time zone, "enrolment_location" point, "exit_location" point, "legacy_id" text, "latest_approval_status" text, "Do you want to enroll in our Menstrual hygiene program ?" text, "Comment if any ?" text, "Have you received a Cup from SA ?" text, "If Yes, Have you understood the Use of Cup ?" text, "Last month's period date." date );
grant all privileges on all tables in schema shelter to shelter;
grant all privileges on all sequences in schema shelter to shelter;
]]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
        ... 1 more
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table shelter.family_member_menstrual_hygiene ("id" integer, "uuid" text, "is_voided" boolean, "created_by_id" integer, "last_modified_by_id" integer, "created_date_time" timestamp with time zone, "last_modified_date_time" timestamp with time zone, "organisation_id" integer, "individual_id" integer, "address_id" integer, "enrolment_date_time" timestamp with time zone, "program_exit_date_time" timestamp with time zone, "enrolment_location" point, "exit_location" point, "legacy_id" text, "latest_approval_status" text, "Do you want to enroll in our Menstrual hygiene program ?" text, "Comment if any ?" text, "Have you received a Cup from SA ?" text, "If Yes, Have you understood the Use of Cup ?" text, "Last month's period date." date );
grant all privileges on all tables in schema shelter to shelter;
grant all privileges on all sequences in schema shelter to shelter;
]