NULL value in uuid column of cloud_usage.account table

[erikbocks]

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.

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template!

[weizhouapache]

Downgrade is not supoorted
also, 4.18 is EOL

[DaanHoogland]

I can confirm this happens on main as well

[weizhouapache]

what's the consequence of it ?

usage server looks good, as well as usage records

[DaanHoogland]

actually maybe you are right and it is not a major issue but still an issue as the uuid is the externally identifiable quality of an account (or domain+account-name) and now an extra step is required to retrieve it.

[weizhouapache]

actually maybe you are right and it is not a major issue but still an issue as the uuid is the externally identifiable quality of an account (or domain+account-name) and now an extra step is required to retrieve it.

yes, good to correct it.
the usage server may get the account information from cloud database, I think

[erikbocks]

Downgrade is not supoorted also, 4.18 is EOL

@weizhouapache Sorry if the word "down" caused any misunderstanding. What I meant to say was that, I tested the 4.20.0 version and the intermediates (as 4.19.0, and so on) until the 4.18.0.0 version.