Archiving unable to generate Weekly, Monthly, Custom date range stats

Hi, After upgrading to 5.0.2, we’re having issues with getting weekly, monthly, custom date range stats from reports generated after archiving, We get this message “There is no data for this report.”, if we try to select any period other than day. And Also we’re seeing the error message " Response was ‘{“result”:“error”,“message”:“The unserialization has failed! - in plugin CustomDimensions.”}’ " in archiving log.

INFO      [2024-06-11 12:06:01] 859118  Error: Got invalid response from API request: ?module=API&method=CoreAdminHome.archiveReports&idSite=1&period=year&date=2024-01-01&format=json&trigger=archivephp. Response was '{"result":"error","message":"The unserialization has failed! - in plugin CustomDimensions."}'
ERROR     [2024-06-11 12:06:01] 859118  1 total errors during this script execution, please investigate and try and fix these errors.
ERROR     [2024-06-11 12:06:01] 859118  Uncaught exception: xxxxxx/core/CronArchive.php(647): 1 total errors during this script execution, please investigate and try and fix these errors. [Query: , CLI mode: 1]

I have tried to invalidate the report and tried to regenerating the reports multiple times but it always fails with above error. And I don’t see any error in php logs. Any advice on how to debug further?