Temporal schedule created without the TemporalScheduler value in the namespace division

Community Support
1

Hello,

When I create a schedule with the CLI, temporal schedule create --schedule-id foo-schedule ..., it won’t appear in the UI and it won’t appear in the output of temporal schedule list. However, temporal schedule describe can find it, and the internal execution exists in executions_visibility.

This following query on the temporal DB shows the internal execution, `temporal-sys-scheduler:foo-schedule` with a null TemporalNamespaceDivision. Other schedules create successfully and appear in the UI as expected and have a “TemporalScheduler” value in TemporalNamespaceDivision

SELECT
  namespace_id,
  start_time,
  workflow_id,
  temporalnamespacedivision,
  status
FROM temporal_visibility.executions_visibility
WHERE
  workflow_type_name = 'temporal-sys-scheduler-workflow'
--   and TemporalNamespaceDivision = 'TemporalScheduler'
  and status = 1
ORDER BY coalesce(close_time, '9999-12-31 23:59:59') DESC, start_time DESC, run_id

It seems like certain schedule-ids on this system have been corrupted or created on older versions of Temporal. The current version running is temporalio/server:1.28.2.

Is there a way to manually update the namespace division? Or purge this execution?

I have done temporal schedule delete --schedule-id foo-schedule , but the subsequent temporal schedule create still creates with the null namespace division. I have also terminated the internal workflow temporal-sys-scheduler:foo-schedule, then run temporal schedule delete and still the ensuing creation lacks the namespace division.