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

Shelter ETL not working inspite of regenarating it #72

Closed
nupoorkhandelwal opened this issue Sep 25, 2023 · 0 comments
Closed

Shelter ETL not working inspite of regenarating it #72

nupoorkhandelwal opened this issue Sep 25, 2023 · 0 comments
Labels
bug Something isn't working user reported

Comments

@nupoorkhandelwal
Copy link

nupoorkhandelwal commented Sep 25, 2023

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;
]

@nupoorkhandelwal nupoorkhandelwal moved this to New Issues in Avni Product Sep 25, 2023
@nupoorkhandelwal nupoorkhandelwal added bug Something isn't working user reported labels Sep 25, 2023
@mahalakshme mahalakshme moved this from New Issues to Ready in Avni Product Sep 25, 2023
@mahalakshme mahalakshme moved this from Ready to Analysis Complete in Avni Product Sep 25, 2023
@mahalakshme mahalakshme moved this from In Analysis Review to Analysis Complete in Avni Product Sep 26, 2023
@mahalakshme mahalakshme moved this from Analysis Complete to In Analysis in Avni Product Sep 26, 2023
@mahalakshme mahalakshme moved this from In Analysis to Focus Items in Avni Product Sep 27, 2023
@github-project-automation github-project-automation bot moved this from Focus Items to Done in Avni Product Oct 2, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working user reported
Projects
Archived in project
Development

No branches or pull requests

2 participants