DAG: ssh505-scc

schedule: 0 7,15 * * *


Task Instance: getPaymentStatistics


Task Instance Details

Dependencies Blocking Task From Getting Scheduled
Dependency Reason
Dagrun Running Task instance's dagrun was not in the 'running' state but in the state 'success'.
Task Instance State Task is in the 'success' state which is not a valid state for execution. The task must be cleared in order to be run.
Attribute: python_callable
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
def getPaymentStatistics(**context):
    token = context.get("ti").xcom_pull(key="token")

    records = get_workflow_records(token, WORKFLOW_ID)
    print(f"Total records fetched from main workflow: {len(records) if records else 0}")

    if not records:
        print("No records found in main workflow.")
        return

    output_rows = [extract_output_row(record) for record in records]

    print("\n===== OUTPUT ROWS TO INSERT (PAYMENT STATISTICS) =====")
    print(json.dumps(output_rows[:1], indent=2, default=str))

    df = pd.DataFrame(output_rows)

    engine = get_postgres_connection()

    # COMMENTED OUT FOR NOW
    # df.to_sql(
    #     TARGET_TABLE,
    #     engine,
    #     if_exists="replace",
    #     index=False
    # )

    print(f"[SKIPPED DB INSERT] Prepared {len(df)} rows for {TARGET_TABLE}")
Task Instance Attributes
Attribute Value
dag_id ssh505-scc
duration 6.892943
end_date 2026-04-13 15:00:41.452660+00:00
execution_date 2026-04-13T07:00:00+00:00
executor_config {}
generate_command <function TaskInstance.generate_command at 0x7fd0919c9320>
hostname c8820bd82d81
is_premature False
job_id 12600
key ('ssh505-scc', 'getPaymentStatistics', <Pendulum [2026-04-13T07:00:00+00:00]>, 2)
log <Logger airflow.task (INFO)>
log_filepath /usr/local/airflow/logs/ssh505-scc/getPaymentStatistics/2026-04-13T07:00:00+00:00.log
log_url http://localhost:8080/admin/airflow/log?execution_date=2026-04-13T07%3A00%3A00%2B00%3A00&task_id=getPaymentStatistics&dag_id=ssh505-scc
logger <Logger airflow.task (INFO)>
mark_success_url http://localhost:8080/success?task_id=getPaymentStatistics&dag_id=ssh505-scc&execution_date=2026-04-13T07%3A00%3A00%2B00%3A00&upstream=false&downstream=false
max_tries 1
metadata MetaData(bind=None)
next_try_number 2
operator PythonOperator
pid 1461145
pool default_pool
prev_attempted_tries 1
previous_execution_date_success 2026-04-12 15:00:00+00:00
previous_start_date_success 2026-04-13 07:00:57.920837+00:00
previous_ti <TaskInstance: ssh505-scc.getPaymentStatistics 2026-04-12 15:00:00+00:00 [success]>
previous_ti_success <TaskInstance: ssh505-scc.getPaymentStatistics 2026-04-12 15:00:00+00:00 [success]>
priority_weight 1
queue default
queued_dttm 2026-04-13 15:00:25.549127+00:00
raw False
run_as_user None
start_date 2026-04-13 15:00:34.559717+00:00
state success
task <Task(PythonOperator): getPaymentStatistics>
task_id getPaymentStatistics
test_mode False
try_number 2
unixname airflow
Task Attributes
Attribute Value
dag <DAG: ssh505-scc>
dag_id ssh505-scc
depends_on_past False
deps {<TIDep(Trigger Rule)>, <TIDep(Not In Retry Period)>, <TIDep(Previous Dagrun State)>}
do_xcom_push True
downstream_list []
downstream_task_ids set()
email None
email_on_failure True
email_on_retry True
end_date None
execution_timeout None
executor_config {}
extra_links []
global_operator_extra_link_dict {}
inlets []
lineage_data None
log <Logger airflow.task.operators (INFO)>
logger <Logger airflow.task.operators (INFO)>
max_retry_delay None
on_failure_callback None
on_retry_callback None
on_success_callback None
op_args []
op_kwargs {}
operator_extra_link_dict {}
operator_extra_links ()
outlets []
owner airflow
params {}
pool default_pool
priority_weight 1
priority_weight_total 1
provide_context True
queue default
resources None
retries 1
retry_delay 0:05:00
retry_exponential_backoff False
run_as_user None
schedule_interval 0 7,15 * * *
shallow_copy_attrs ('python_callable', 'op_kwargs')
sla None
start_date 2023-01-17T00:00:00+00:00
subdag None
task_concurrency None
task_id getPaymentStatistics
task_type PythonOperator
template_ext []
template_fields ('templates_dict', 'op_args', 'op_kwargs')
templates_dict None
trigger_rule all_success
ui_color #ffefeb
ui_fgcolor #000
upstream_list [<Task(PythonOperator): getDrowToken>]
upstream_task_ids {'getDrowToken'}
wait_for_downstream False
weight_rule downstream