Re: cloudstack-usage no longer working / error saving account to cloud_usage db

2016-08-18 Thread Rohit Yadav
he.org Subject: Re: cloudstack-usage no longer working / error saving account to cloud_usage db Hi Rohit, thanks! Having a recent DB backup at hand and only based on guesses, I did some further experiments yesterday :) - Rerun /usr/share/cloudstack-common/scripts/util/migrate- dynamicroles.py - C

Re: cloudstack-usage no longer working / error saving account to cloud_usage db

2016-08-18 Thread Stephan Seitz
Hi Rohit, thanks! Having a recent DB backup at hand and only based on guesses, I did some further experiments yesterday :) - RerunĀ /usr/share/cloudstack-common/scripts/util/migrate- dynamicroles.py - Checked cloudstack-usage 4.8.0.1 instead of 4.9 - Updated back to cloudstack-usage 4.9 ... and

Re: cloudstack-usage no longer working / error saving account to cloud_usage db

2016-08-18 Thread Rohit Yadav
Hi Stephan, In cloud_usage.account `role_id` can be NULL as there is no user of this field within the usage server. In cloud.account, the `role_id` should be automatically populated/migrated when you upgraded. From your shared db query result, I'm not sure if that's a select query on

Re: cloudstack-usage no longer working / error saving account to cloud_usage db

2016-08-18 Thread Rajani Karuturi
role_id in account table shouldn't be null. If the upgrade was successful, it should have updated it with proper mapping from account type. (check the db upgrade log for any exceptions) I suggest you do the update manually following the logic at