Scheduled task failed: Quiz tracking task (local_assessfreq\task\quiz_tracking),Error reading from database

[dmitriim]

Could be a data issue, but that what we got in one of our prod system:

Scheduled task failed: Quiz tracking task (local_assessfreq\task\quiz_tracking),Error reading from database
ce92bd93ce0a:29871 2023-08-21 09:15:48 Debug info:
ce92bd93ce0a:29871 2023-08-21 09:15:48 ERROR:  invalid input syntax for type bigint: ""
ce92bd93ce0a:29871 2023-08-21 09:15:48 CONTEXT:  unnamed portal parameter $1 = ''
ce92bd93ce0a:29871 2023-08-21 09:15:48 SELECT rc.id, rc.roleid, rc.permission, rc.capability, ctx.path
ce92bd93ce0a:29871 2023-08-21 09:15:48               FROM mdl_role_capabilities rc
ce92bd93ce0a:29871 2023-08-21 09:15:48               JOIN mdl_capabilities cap ON rc.capability = cap.name
ce92bd93ce0a:29871 2023-08-21 09:15:48               JOIN mdl_context ctx on rc.contextid = ctx.id
ce92bd93ce0a:29871 2023-08-21 09:15:48              WHERE rc.contextid = $1 AND rc.capability IN ($2,$3) 
ce92bd93ce0a:29871 2023-08-21 09:15:48 [array (
ce92bd93ce0a:29871 2023-08-21 09:15:48   0 => '',
ce92bd93ce0a:29871 2023-08-21 09:15:48   1 => 'mod/quiz:attempt',
ce92bd93ce0a:29871 2023-08-21 09:15:48   2 => 'mod/quiz:view',
ce92bd93ce0a:29871 2023-08-21 09:15:48 )]
ce92bd93ce0a:29871 2023-08-21 09:15:48 Backtrace:
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 295 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 341 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_slave_query_end()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 965 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 3565 of /lib/accesslib.php: call to pgsql_native_moodle_database->get_records_sql()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 398 of /local/assessfreq/classes/frequency.php: call to get_with_capability_join()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 423 of /local/assessfreq/classes/frequency.php: call to local_assessfreq\frequency->generate_enrolled_wheres_joins_params()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 450 of /local/assessfreq/classes/frequency.php: call to local_assessfreq\frequency->get_enrolled_users()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 660 of /local/assessfreq/classes/quiz.php: call to local_assessfreq\frequency->get_event_users_raw()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 57 of /local/assessfreq/classes/task/quiz_tracking.php: call to local_assessfreq\quiz->process_quiz_tracking()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 263 of /lib/cronlib.php: call to local_assessfreq\task\quiz_tracking->execute()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 120 of /lib/cronlib.php: call to cron_run_inner_scheduled_task()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 73 of /lib/cronlib.php: call to cron_run_scheduled_tasks()
ce92bd93ce0a:29871 2023-08-21 09:15:48 * line 178 of /admin/cli/cron.php: call to cron_run()