problem

When the Usage service imports accounts from the cloud database, the uuid column is not retrieved correctly. This results in all uuid values in cloud_usage.accounts being NULL.

versions

The issue has been observed in CloudStack versions from 4.20.0 down to 4.18.0. Older versions may also be affected, but they have not been tested.

The steps to reproduce the bug

1. Run the Usage Job
2. Check the accounts table from cloud_usage.

What to do about it?

The process responsible for copying accounts from the cloud database to the cloud_usage database needs to be corrected, to ensure the UUID values are properly retrieved and stored.