Chart email schedules not delivering

[thammaneni]

A clear and concise description of what the bug is.
I have scheduled a report with cron tab frequency every 15 min. It is throwing an error saying slices.id is not found. I have check the chart creation and slice.id in slices table as well. everything looks fine. Please suggest any ideas here. Thanks.

Expected results

Worker log:
[2020-04-22 00:18:46,794: ERROR/ForkPoolWorker-7] Task email_reports.send[2fd14c5c-2df8-4130-a5da-2af92e0d5068] raised unexpected: NoSuchColumnError("Could not locate column in row for column 'slices.id'",)
Traceback (most recent call last):
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/celery/app/trace.py", line 385, in trace_task
R = retval = fun(*args, **kwargs)
File "/obi/ApacheSuperset/superset_36/Superset/superset/app.py", line 114, in call
return task_base.call(self, *args, **kwargs)
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/celery/app/trace.py", line 650, in protected_call
return self.run(*args, **kwargs)
File "/obi/ApacheSuperset/superset_36/Superset/superset/tasks/schedules.py", line 714, in schedule_email_report
deliver_slice(schedule)
File "/obi/ApacheSuperset/superset_36/Superset/superset/tasks/schedules.py", line 677, in deliver_slice
email = get_slice_visualization(schedule)
File "/obi/ApacheSuperset/superset_36/Superset/superset/tasks/schedules.py", line 636, in get_slice_visualization
slc = schedule.slice
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/orm/attributes.py", line 286, in get
return self.impl.get(instance_state(instance), dict)
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/orm/attributes.py", line 722, in get
value = self.callable(state, passive)
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/orm/strategies.py", line 750, in _load_for_state
session, state, primary_key_identity, passive
File "", line 1, in
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/orm/strategies.py", line 840, in _emit_lazyload
session.query(self.mapper), primary_key_identity
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/ext/baked.py", line 615, in load_on_pk_identity
result = list(bq.for_session(self.session).params(**params))
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/orm/loading.py", line 101, in instances
cursor.close()
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in exit
exc_value, with_traceback=exc_tb,
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/orm/loading.py", line 81, in instances
rows = [proc(row) for row in fetch]
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/orm/loading.py", line 81, in
rows = [proc(row) for row in fetch]
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/orm/loading.py", line 525, in _instance
tuple([row[column] for column in pk_cols]),
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/orm/loading.py", line 525, in
tuple([row[column] for column in pk_cols]),
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/engine/result.py", line 686, in key_fallback
replace_context=err,
File "/obi/ApacheSuperset/superset_36/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise
raise exception
sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column 'slices.id'"
what you expected to happen.

Actual results

what actually happens.

Screenshots

If applicable, add screenshots to help explain your problem.

How to reproduce the bug

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Environment

(please complete the following information):

• superset version: superset version
• python version: python --version
• node.js version: node -v
• npm version: npm -v

Checklist

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Add any other context about the problem here.

[thammaneni]

Resolved.