ETL Service fails

------=_Part_3758020_756145403.1475295841164 Content-Type: multipart/alternative; boundary="----=_Part_3758019_2012389424.1475295841163" ------=_Part_3758019_2012389424.1475295841163 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hello, I just upgraded to OVIRT 4.04 on the hosted appliance and for some reason I no longer see the DHW metrics on the dashboard. I receive a lot of errors, obviously, stating "ETL Service has encountered an error, Please consult the service log. The research that I have been able to come up with appears to be with a FK or a user that no longer exists in the database, however the attached logs have zero reference to these errors. Any help would be appreciated. Thanks Andy ------=_Part_3758019_2012389424.1475295841163 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <html><head></head><body><div style=3D"color:#000; background-color:#fff; f= ont-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, = sans-serif;font-size:10px"><div id=3D"yui_3_16_0_ym19_1_1475295566829_6832"= dir=3D"ltr">Hello,<br id=3D"yui_3_16_0_ym19_1_1475295566829_6851">I just u= pgraded to OVIRT 4.04 on the hosted appliance and for some reason I no long= er see the DHW metrics on the dashboard. I receive a lot of errors, obvious= ly, stating "ETL Service has encountered an error, Please consult the servi= ce log. The research that I have been able to come up with appears to be wi= th a FK or a user that no longer exists in the database, however the attach= ed logs have zero reference to these errors.<br id=3D"yui_3_16_0_ym19_1_147= 5295566829_6857"><br id=3D"yui_3_16_0_ym19_1_1475295566829_6858">Any help w= ould be appreciated.<br id=3D"yui_3_16_0_ym19_1_1475295566829_6859"></div><= div dir=3D"ltr"><br></div><div dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_14752955= 66829_7031">Thanks Andy</div></div></body></html> ------=_Part_3758019_2012389424.1475295841163-- ------=_Part_3758020_756145403.1475295841164 Content-Type: application/octet-stream Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=logs Content-ID: <d1e00938-2621-e516-6bd5-7329b95cfe8c@yahoo.com> W3Jvb3RAZXhjb3ZtZyBvdmlydC1lbmdpbmUtZHdoXSMgbW9yZSBvdmlydC1lbmdpbmUtZHdoZC5s b2cgCjIwMTYtMTAtMDEgMDI6Mzg6Mzl8RVRMIFNlcnZpY2UgU3RhcnRlZApvdmlydEVuZ2luZURi RHJpdmVyQ2xhc3N8b3JnLnBvc3RncmVzcWwuRHJpdmVyCm92aXJ0RW5naW5lSGlzdG9yeURiSmRi Y0Nvbm5lY3Rpb258amRiYzpwb3N0Z3Jlc3FsOi8vbG9jYWxob3N0OjU0MzIvb3ZpcnRfZW5naW5l X2hpc3Rvcnk/c3NsZmFjdG9yeT1vcmcucG9zdGdyZXNxbC5zc2wuTm9uVmFsaWRhdGluZ0ZhY3Rv cnkKaG91cnNUb0tlZXBEYWlseXwwCmhvdXJzVG9LZWVwSG91cmx5fDcyMApvdmlydEVuZ2luZURi UGFzc3dvcmR8KioqKioqKioqKioqKioqKioqKioqKgpydW5EZWxldGVUaW1lfDMKb3ZpcnRFbmdp bmVEYkpkYmNDb25uZWN0aW9ufGpkYmM6cG9zdGdyZXNxbDovL2xvY2FsaG9zdDo1NDMyL2VuZ2lu ZT9zc2xmYWN0b3J5PW9yZy5wb3N0Z3Jlc3FsLnNzbC5Ob25WYWxpZGF0aW5nRmFjdG9yeQpydW5J bnRlcmxlYXZlfDIwCmxpbWl0Um93c3xsaW1pdCAxMDAwCm92aXJ0RW5naW5lSGlzdG9yeURiVXNl cnxvdmlydF9lbmdpbmVfaGlzdG9yeQpvdmlydEVuZ2luZURiVXNlcnxlbmdpbmUKZGVsZXRlSW5j cmVtZW50fDEwCnRpbWVCZXR3ZWVuRXJyb3JFdmVudHN8MzAwMDAwCmhvdXJzVG9LZWVwU2FtcGxl c3wyNApkZWxldGVNdWx0aXBsaWVyfDEwMDAKbGFzdEVycm9yU2VudHwyMDExLTA3LTAzIDEyOjQ2 OjQ3LjAwMDAwMApldGxWZXJzaW9ufDQuMC4yCmR3aEFnZ3JlZ2F0aW9uRGVidWd8ZmFsc2UKZHdo VXVpZHw3NmQ1NTg4Ny1hMDgxLTQ5YTAtODllNy1kOGIxMmQxYWYyYzMKb3ZpcnRFbmdpbmVIaXN0 b3J5RGJEcml2ZXJDbGFzc3xvcmcucG9zdGdyZXNxbC5Ecml2ZXIKb3ZpcnRFbmdpbmVIaXN0b3J5 RGJQYXNzd29yZHwqKioqKioqKioqKioqKioqKioqKioqCkV4Y2VwdGlvbiBpbiBjb21wb25lbnQg dEpEQkNPdXRwdXRfNQpFeGNlcHRpb24gaW4gY29tcG9uZW50IHRKREJDT3V0cHV0XzYKRXhjZXB0 aW9uIGluIGNvbXBvbmVudCB0SkRCQ091dHB1dF8yCm9yZy5wb3N0Z3Jlc3FsLnV0aWwuUFNRTEV4 Y2VwdGlvbjogRVJST1I6IGluZGV4ICJpZHhfdm1fY29uZmlndXJhdGlvbl92ZXJzaW9uX3NhbXBs ZXMiIGNvbnRhaW5zIHVuZXhwZWN0ZWQgemVybyBwYWdlIGF0IGJsb2NrIDI0MjMKICBIaW50OiBQ bGVhc2UgUkVJTkRFWCBpdC4KCWF0IG9yZy5wb3N0Z3Jlc3FsLmNvcmUudjMuUXVlcnlFeGVjdXRv ckltcGwucmVjZWl2ZUVycm9yUmVzcG9uc2UoUXVlcnlFeGVjdXRvckltcGwuamF2YToyMTU3KQoJ YXQgb3JnLnBvc3RncmVzcWwuY29yZS52My5RdWVyeUV4ZWN1dG9ySW1wbC5wcm9jZXNzUmVzdWx0 cyhRdWVyeUV4ZWN1dG9ySW1wbC5qYXZhOjE4ODYpCglhdCBvcmcucG9zdGdyZXNxbC5jb3JlLnYz LlF1ZXJ5RXhlY3V0b3JJbXBsLmV4ZWN1dGUoUXVlcnlFeGVjdXRvckltcGwuamF2YToyNTUpCglh dCBvcmcucG9zdGdyZXNxbC5qZGJjMi5BYnN0cmFjdEpkYmMyU3RhdGVtZW50LmV4ZWN1dGUoQWJz dHJhY3RKZGJjMlN0YXRlbWVudC5qYXZhOjU1NSkKCWF0IG9yZy5wb3N0Z3Jlc3FsLmpkYmMyLkFi c3RyYWN0SmRiYzJTdGF0ZW1lbnQuZXhlY3V0ZVdpdGhGbGFncyhBYnN0cmFjdEpkYmMyU3RhdGVt ZW50LmphdmE6NDE3KQoJYXQgb3JnLnBvc3RncmVzcWwuamRiYzIuQWJzdHJhY3RKZGJjMlN0YXRl bWVudC5leGVjdXRlVXBkYXRlKEFic3RyYWN0SmRiYzJTdGF0ZW1lbnQuamF2YTozNjMpCglhdCBv dmlydF9lbmdpbmVfZHdoLnN0YXRpc3RpY3NzeW5jXzRfMC5TdGF0aXN0aWNzU3luYy50SkRCQ0lu cHV0XzEwUHJvY2VzcyhTdGF0aXN0aWNzU3luYy5qYXZhOjkwMzApCglhdCBvdmlydF9lbmdpbmVf ZHdoLnN0YXRpc3RpY3NzeW5jXzRfMC5TdGF0aXN0aWNzU3luYyQ1LnJ1bihTdGF0aXN0aWNzU3lu Yy5qYXZhOjE2MDcxKQpFeGNlcHRpb24gaW4gY29tcG9uZW50IHRKREJDT3V0cHV0XzQKb3JnLnBv c3RncmVzcWwudXRpbC5QU1FMRXhjZXB0aW9uOiBFUlJPUjogY3VycmVudCB0cmFuc2FjdGlvbiBp cyBhYm9ydGVkLCBjb21tYW5kcyBpZ25vcmVkIHVudGlsIGVuZCBvZiB0cmFuc2FjdGlvbiBibG9j awoJYXQgb3JnLnBvc3RncmVzcWwuY29yZS52My5RdWVyeUV4ZWN1dG9ySW1wbC5yZWNlaXZlRXJy b3JSZXNwb25zZShRdWVyeUV4ZWN1dG9ySW1wbC5qYXZhOjIxNTcpCglhdCBvcmcucG9zdGdyZXNx bC5jb3JlLnYzLlF1ZXJ5RXhlY3V0b3JJbXBsLnByb2Nlc3NSZXN1bHRzKFF1ZXJ5RXhlY3V0b3JJ bXBsLmphdmE6MTg4NikKCWF0IG9yZy5wb3N0Z3Jlc3FsLmNvcmUudjMuUXVlcnlFeGVjdXRvcklt cGwuZXhlY3V0ZShRdWVyeUV4ZWN1dG9ySW1wbC5qYXZhOjI1NSkKCWF0IG9yZy5wb3N0Z3Jlc3Fs LmpkYmMyLkFic3RyYWN0SmRiYzJTdGF0ZW1lbnQuZXhlY3V0ZShBYnN0cmFjdEpkYmMyU3RhdGVt ZW50LmphdmE6NTU1KQoJYXQgb3JnLnBvc3RncmVzcWwuamRiYzIuQWJzdHJhY3RKZGJjMlN0YXRl bWVudC5leGVjdXRlV2l0aEZsYWdzKEFic3RyYWN0SmRiYzJTdGF0ZW1lbnQuamF2YTo0MTcpCglh dCBvcmcucG9zdGdyZXNxbC5qZGJjMi5BYnN0cmFjdEpkYmMyU3RhdGVtZW50LmV4ZWN1dGVVcGRh dGUoQWJzdHJhY3RKZGJjMlN0YXRlbWVudC5qYXZhOjM2MykKCWF0IG92aXJ0X2VuZ2luZV9kd2gu c3RhdGlzdGljc3N5bmNfNF8wLlN0YXRpc3RpY3NTeW5jLnRKREJDSW5wdXRfOFByb2Nlc3MoU3Rh dGlzdGljc1N5bmMuamF2YTo2MjU4KQoJYXQgb3ZpcnRfZW5naW5lX2R3aC5zdGF0aXN0aWNzc3lu Y180XzAuU3RhdGlzdGljc1N5bmMkNC5ydW4oU3RhdGlzdGljc1N5bmMuamF2YToxNjAyNSkKb3Jn LnBvc3RncmVzcWwudXRpbC5QU1FMRXhjZXB0aW9uOiBFUlJPUjogY3VycmVudCB0cmFuc2FjdGlv biBpcyBhYm9ydGVkLCBjb21tYW5kcyBpZ25vcmVkIHVudGlsIGVuZCBvZiB0cmFuc2FjdGlvbiBi bG9jawoJYXQgb3JnLnBvc3RncmVzcWwuY29yZS52My5RdWVyeUV4ZWN1dG9ySW1wbC5yZWNlaXZl RXJyb3JSZXNwb25zZShRdWVyeUV4ZWN1dG9ySW1wbC5qYXZhOjIxNTcpCglhdCBvcmcucG9zdGdy ZXNxbC5jb3JlLnYzLlF1ZXJ5RXhlY3V0b3JJbXBsLnByb2Nlc3NSZXN1bHRzKFF1ZXJ5RXhlY3V0 b3JJbXBsLmphdmE6MTg4NikKCWF0IG9yZy5wb3N0Z3Jlc3FsLmNvcmUudjMuUXVlcnlFeGVjdXRv ckltcGwuZXhlY3V0ZShRdWVyeUV4ZWN1dG9ySW1wbC5qYXZhOjI1NSkKCWF0IG9yZy5wb3N0Z3Jl c3FsLmpkYmMyLkFic3RyYWN0SmRiYzJTdGF0ZW1lbnQuZXhlY3V0ZShBYnN0cmFjdEpkYmMyU3Rh dGVtZW50LmphdmE6NTU1KQoyMDE2LTEwLTAxIDAyOjM5OjAxfFVwMjZxOXxEazNRUVN8UHB2aVEw fE9WSVJUX0VOR0lORV9EV0h8U3RhdGlzdGljc1N5bmN8RGVmYXVsdHw2fEphdmEgRXhjZXB0aW9u fHRKREJDT3V0cHV0XzV8b3JnLnBvc3RncmVzcWwudXRpbC5QU1FMRXhjZXB0aW9uCjpFUlJPUjog aW5kZXggImlkeF92bV9jb25maWd1cmF0aW9uX3ZlcnNpb25fc2FtcGxlcyIgY29udGFpbnMgdW5l eHBlY3RlZCB6ZXJvIHBhZ2UgYXQgYmxvY2sgMjQyMwogIEhpbnQ6IFBsZWFzZSBSRUlOREVYIGl0 LnwxCglhdCBvcmcucG9zdGdyZXNxbC5qZGJjMi5BYnN0cmFjdEpkYmMyU3RhdGVtZW50LmV4ZWN1 dGVXaXRoRmxhZ3MoQWJzdHJhY3RKZGJjMlN0YXRlbWVudC5qYXZhOjQxNykKCWF0IG9yZy5wb3N0 Z3Jlc3FsLmpkYmMyLkFic3RyYWN0SmRiYzJTdGF0ZW1lbnQuZXhlY3V0ZVVwZGF0ZShBYnN0cmFj dEpkYmMyU3RhdGVtZW50LmphdmE6MzYzKQoJYXQgb3ZpcnRfZW5naW5lX2R3aC5zdGF0aXN0aWNz c3luY180XzAuU3RhdGlzdGljc1N5bmMudEpEQkNJbnB1dF80UHJvY2VzcyhTdGF0aXN0aWNzU3lu Yy5qYXZhOjIwNTUpCglhdCBvdmlydF9lbmdpbmVfZHdoLnN0YXRpc3RpY3NzeW5jXzRfMC5TdGF0 aXN0aWNzU3luYyQyLnJ1bihTdGF0aXN0aWNzU3luYy5qYXZhOjE1OTMzKQpFeGNlcHRpb24gaW4g Y29tcG9uZW50IHRKREJDT3V0cHV0XzcKb3JnLnBvc3RncmVzcWwudXRpbC5QU1FMRXhjZXB0aW9u OiBFUlJPUjogY3VycmVudCB0cmFuc2FjdGlvbiBpcyBhYm9ydGVkLCBjb21tYW5kcyBpZ25vcmVk IHVudGlsIGVuZCBvZiB0cmFuc2FjdGlvbiBibG9jawoJYXQgb3JnLnBvc3RncmVzcWwuY29yZS52 My5RdWVyeUV4ZWN1dG9ySW1wbC5yZWNlaXZlRXJyb3JSZXNwb25zZShRdWVyeUV4ZWN1dG9ySW1w bC5qYXZhOjIxNTcpCglhdCBvcmcucG9zdGdyZXNxbC5jb3JlLnYzLlF1ZXJ5RXhlY3V0b3JJbXBs LnByb2Nlc3NSZXN1bHRzKFF1ZXJ5RXhlY3V0b3JJbXBsLmphdmE6MTg4NikKCWF0IG9yZy5wb3N0 Z3Jlc3FsLmNvcmUudjMuUXVlcnlFeGVjdXRvckltcGwuZXhlY3V0ZShRdWVyeUV4ZWN1dG9ySW1w bC5qYXZhOjI1NSkKCWF0IG9yZy5wb3N0Z3Jlc3FsLmpkYmMyLkFic3RyYWN0SmRiYzJTdGF0ZW1l bnQuZXhlY3V0ZShBYnN0cmFjdEpkYmMyU3RhdGVtZW50LmphdmE6NTU1KQoJYXQgb3JnLnBvc3Rn cmVzcWwuamRiYzIuQWJzdHJhY3RKZGJjMlN0YXRlbWVudC5leGVjdXRlV2l0aEZsYWdzKEFic3Ry YWN0SmRiYzJTdGF0ZW1lbnQuamF2YTo0MTcpCglhdCBvcmcucG9zdGdyZXNxbC5qZGJjMi5BYnN0 cmFjdEpkYmMyU3RhdGVtZW50LmV4ZWN1dGVVcGRhdGUoQWJzdHJhY3RKZGJjMlN0YXRlbWVudC5q YXZhOjM2MykKCWF0IG92aXJ0X2VuZ2luZV9kd2guc3RhdGlzdGljc3N5bmNfNF8wLlN0YXRpc3Rp Y3NTeW5jLnRKREJDSW5wdXRfMThQcm9jZXNzKFN0YXRpc3RpY3NTeW5jLmphdmE6MTM0MjkpCglh dCBvdmlydF9lbmdpbmVfZHdoLnN0YXRpc3RpY3NzeW5jXzRfMC5TdGF0aXN0aWNzU3luYyQ3LnJ1 bihTdGF0aXN0aWNzU3luYy5qYXZhOjE2MTYzKQpvcmcucG9zdGdyZXNxbC51dGlsLlBTUUxFeGNl cHRpb246IEVSUk9SOiBjdXJyZW50IHRyYW5zYWN0aW9uIGlzIGFib3J0ZWQsIGNvbW1hbmRzIGln bm9yZWQgdW50aWwgZW5kIG9mIHRyYW5zYWN0aW9uIGJsb2NrCglhdCBvcmcucG9zdGdyZXNxbC5j b3JlLnYzLlF1ZXJ5RXhlY3V0b3JJbXBsLnJlY2VpdmVFcnJvclJlc3BvbnNlKFF1ZXJ5RXhlY3V0 b3JJbXBsLmphdmE6MjE1NykKCWF0IG9yZy5wb3N0Z3Jlc3FsLmNvcmUudjMuUXVlcnlFeGVjdXRv ckltcGwucHJvY2Vzc1Jlc3VsdHMoUXVlcnlFeGVjdXRvckltcGwuamF2YToxODg2KQoJYXQgb3Jn LnBvc3RncmVzcWwuY29yZS52My5RdWVyeUV4ZWN1dG9ySW1wbC5leGVjdXRlKFF1ZXJ5RXhlY3V0 b3JJbXBsLmphdmE6MjU1KQoJYXQgb3JnLnBvc3RncmVzcWwuamRiYzIuQWJzdHJhY3RKZGJjMlN0 YXRlbWVudC5leGVjdXRlKEFic3RyYWN0SmRiYzJTdGF0ZW1lbnQuamF2YTo1NTUpCglhdCBvcmcu cG9zdGdyZXNxbC5qZGJjMi5BYnN0cmFjdEpkYmMyU3RhdGVtZW50LmV4ZWN1dGVXaXRoRmxhZ3Mo QWJzdHJhY3RKZGJjMlN0YXRlbWVudC5qYXZhOjQxNykKCWF0IG9yZy5wb3N0Z3Jlc3FsLmpkYmMy LkFic3RyYWN0SmRiYzJTdGF0ZW1lbnQuZXhlY3V0ZVVwZGF0ZShBYnN0cmFjdEpkYmMyU3RhdGVt ZW50LmphdmE6MzYzKQoJYXQgb3ZpcnRfZW5naW5lX2R3aC5zdGF0aXN0aWNzc3luY180XzAuU3Rh dGlzdGljc1N5bmMudEpEQkNJbnB1dF8xMlByb2Nlc3MoU3RhdGlzdGljc1N5bmMuamF2YToxMTM3 OCkyMDE2LTEwLTAxIDAyOjM5OjAxfFVwMjZxOXxEazNRUVN8UHAKdmlRMHxPVklSVF9FTkdJTkVf RFdIfFN0YXRpc3RpY3NTeW5jfERlZmF1bHR8NnxKYXZhIEV4Y2VwdGlvbnx0SkRCQ091dHB1dF80 fG9yZy5wb3N0Z3Jlc3FsLnV0aWwuUFNRTEV4Y2VwdGlvbjpFUlJPUjogY3VycmVudCB0cmFuc2Fj dGlvbiBpcyBhYm9ydAplZCwgY29tbWFuZHMgaWdub3JlZCB1bnRpbCBlbmQgb2YgdHJhbnNhY3Rp b24gYmxvY2t8MQoKCWF0IG92aXJ0X2VuZ2luZV9kd2guc3RhdGlzdGljc3N5bmNfNF8wLlN0YXRp c3RpY3NTeW5jJDYucnVuKFN0YXRpc3RpY3NTeW5jLmphdmE6MTYxMTcpCjIwMTYtMTAtMDEgMDI6 Mzk6MDF8VXAyNnE5fERrM1FRU3xQcHZpUTB8T1ZJUlRfRU5HSU5FX0RXSHxTdGF0aXN0aWNzU3lu Y3xEZWZhdWx0fDZ8SmF2YSBFeGNlcHRpb258dEpEQkNPdXRwdXRfN3xvcmcucG9zdGdyZXNxbC51 dGlsLlBTUUxFeGNlcHRpb24KOkVSUk9SOiBjdXJyZW50IHRyYW5zYWN0aW9uIGlzIGFib3J0ZWQs IGNvbW1hbmRzIGlnbm9yZWQgdW50aWwgZW5kIG9mIHRyYW5zYWN0aW9uIGJsb2NrfDEKMjAxNi0x MC0wMSAwMjozOTowMXxVcDI2cTl8RGszUVFTfFBwdmlRMHxPVklSVF9FTkdJTkVfRFdIfFN0YXRp c3RpY3NTeW5jfERlZmF1bHR8NnxKYXZhIEV4Y2VwdGlvbnx0SkRCQ091dHB1dF8yfG9yZy5wb3N0 Z3Jlc3FsLnV0aWwuUFNRTEV4Y2VwdGlvbgo6RVJST1I6IGN1cnJlbnQgdHJhbnNhY3Rpb24gaXMg YWJvcnRlZCwgY29tbWFuZHMgaWdub3JlZCB1bnRpbCBlbmQgb2YgdHJhbnNhY3Rpb24gYmxvY2t8 MQoyMDE2LTEwLTAxIDAyOjM5OjAxfFVwMjZxOXxEazNRUVN8UHB2aVEwfE9WSVJUX0VOR0lORV9E V0h8U3RhdGlzdGljc1N5bmN8RGVmYXVsdHw2fEphdmEgRXhjZXB0aW9ufHRKREJDT3V0cHV0XzZ8 b3JnLnBvc3RncmVzcWwudXRpbC5QU1FMRXhjZXB0aW9uCjpFUlJPUjogY3VycmVudCB0cmFuc2Fj dGlvbiBpcyBhYm9ydGVkLCBjb21tYW5kcyBpZ25vcmVkIHVudGlsIGVuZCBvZiB0cmFuc2FjdGlv biBibG9ja3wxCkV4Y2VwdGlvbiBpbiBjb21wb25lbnQgdFJ1bkpvYl81CmphdmEubGFuZy5SdW50 aW1lRXhjZXB0aW9uOiBDaGlsZCBqb2IgcnVubmluZyBmYWlsZWQKCWF0IG92aXJ0X2VuZ2luZV9k d2guc2FtcGxlcnVuam9ic180XzAuU2FtcGxlUnVuSm9icy50UnVuSm9iXzVQcm9jZXNzKFNhbXBs ZVJ1bkpvYnMuamF2YToxNjU0KQoJYXQgb3ZpcnRfZW5naW5lX2R3aC5zYW1wbGVydW5qb2JzXzRf MC5TYW1wbGVSdW5Kb2JzLnRSdW5Kb2JfNlByb2Nlc3MoU2FtcGxlUnVuSm9icy5qYXZhOjE0NTYp CglhdCBvdmlydF9lbmdpbmVfZHdoLnNhbXBsZXJ1bmpvYnNfNF8wLlNhbXBsZVJ1bkpvYnMudFJ1 bkpvYl8xUHJvY2VzcyhTYW1wbGVSdW5Kb2JzLmphdmE6MTIyOCkKCWF0IG92aXJ0X2VuZ2luZV9k d2guc2FtcGxlcnVuam9ic180XzAuU2FtcGxlUnVuSm9icy50UnVuSm9iXzRQcm9jZXNzKFNhbXBs ZVJ1bkpvYnMuamF2YToxMDAwKQoJYXQgb3ZpcnRfZW5naW5lX2R3aC5zYW1wbGVydW5qb2JzXzRf MC5TYW1wbGVSdW5Kb2JzLnRKREJDQ29ubmVjdGlvbl8yUHJvY2VzcyhTYW1wbGVSdW5Kb2JzLmph dmE6NzY3KQoJYXQgb3ZpcnRfZW5naW5lX2R3aC5zYW1wbGVydW5qb2JzXzRfMC5TYW1wbGVSdW5K b2JzLnRKREJDQ29ubmVjdGlvbl8xUHJvY2VzcyhTYW1wbGVSdW5Kb2JzLmphdmE6NjQyKQoJYXQg b3ZpcnRfZW5naW5lX2R3aC5zYW1wbGVydW5qb2JzXzRfMC5TYW1wbGVSdW5Kb2JzJDIucnVuKFNh bXBsZVJ1bkpvYnMuamF2YToyNjgzKQoyMDE2LTEwLTAxIDAyOjM5OjAxfFBwdmlRMHxEazNRUVN8 VjNURjBWfE9WSVJUX0VOR0lORV9EV0h8U2FtcGxlUnVuSm9ic3xEZWZhdWx0fDZ8SmF2YSBFeGNl cHRpb258dFJ1bkpvYl81fGphdmEubGFuZy5SdW50aW1lRXhjZXB0aW9uOkNoaWxkIGpvYiByCnVu bmluZyBmYWlsZWR8MQpFeGNlcHRpb24gaW4gY29tcG9uZW50IHRSdW5Kb2JfMQpqYXZhLmxhbmcu UnVudGltZUV4Y2VwdGlvbjogQ2hpbGQgam9iIHJ1bm5pbmcgZmFpbGVkCglhdCBvdmlydF9lbmdp bmVfZHdoLnNhbXBsZXRpbWVrZWVwaW5nam9iXzRfMC5TYW1wbGVUaW1lS2VlcGluZ0pvYi50UnVu Sm9iXzFQcm9jZXNzKFNhbXBsZVRpbWVLZWVwaW5nSm9iLmphdmE6NjA2NykKCWF0IG92aXJ0X2Vu Z2luZV9kd2guc2FtcGxldGltZWtlZXBpbmdqb2JfNF8wLlNhbXBsZVRpbWVLZWVwaW5nSm9iLnRK REJDSW5wdXRfMlByb2Nlc3MoU2FtcGxlVGltZUtlZXBpbmdKb2IuamF2YTo1ODA5KQoJYXQgb3Zp cnRfZW5naW5lX2R3aC5zYW1wbGV0aW1la2VlcGluZ2pvYl80XzAuU2FtcGxlVGltZUtlZXBpbmdK b2IudEpEQkNDb25uZWN0aW9uXzFQcm9jZXNzKFNhbXBsZVRpbWVLZWVwaW5nSm9iLmphdmE6NDQ0 NCkKCWF0IG92aXJ0X2VuZ2luZV9kd2guc2FtcGxldGltZWtlZXBpbmdqb2JfNF8wLlNhbXBsZVRp bWVLZWVwaW5nSm9iLnRKREJDQ29ubmVjdGlvbl8yUHJvY2VzcyhTYW1wbGVUaW1lS2VlcGluZ0pv Yi5qYXZhOjQzMTkpCglhdCBvdmlydF9lbmdpbmVfZHdoLnNhbXBsZXRpbWVrZWVwaW5nam9iXzRf MC5TYW1wbGVUaW1lS2VlcGluZ0pvYi50Um93R2VuZXJhdG9yXzJQcm9jZXNzKFNhbXBsZVRpbWVL ZWVwaW5nSm9iLmphdmE6NDE4OCkKCWF0IG92aXJ0X2VuZ2luZV9kd2guc2FtcGxldGltZWtlZXBp bmdqb2JfNF8wLlNhbXBsZVRpbWVLZWVwaW5nSm9iLnRKREJDSW5wdXRfM1Byb2Nlc3MoU2FtcGxl VGltZUtlZXBpbmdKb2IuamF2YTozNTkzKQoJYXQgb3ZpcnRfZW5naW5lX2R3aC5zYW1wbGV0aW1l a2VlcGluZ2pvYl80XzAuU2FtcGxlVGltZUtlZXBpbmdKb2IudEpEQkNJbnB1dF81UHJvY2VzcyhT YW1wbGVUaW1lS2VlcGluZ0pvYi5qYXZhOjI5NzcpCglhdCBvdmlydF9lbmdpbmVfZHdoLnNhbXBs ZXRpbWVrZWVwaW5nam9iXzRfMC5TYW1wbGVUaW1lS2VlcGluZ0pvYi50SkRCQ0lucHV0XzRQcm9j ZXNzKFNhbXBsZVRpbWVLZWVwaW5nSm9iLmphdmE6MjI5NSkKCWF0IG92aXJ0X2VuZ2luZV9kd2gu c2FtcGxldGltZWtlZXBpbmdqb2JfNF8wLlNhbXBsZVRpbWVLZWVwaW5nSm9iLnRKREJDQ29ubmVj dGlvbl8zUHJvY2VzcyhTYW1wbGVUaW1lS2VlcGluZ0pvYi5qYXZhOjE2NDkpCglhdCBvdmlydF9l bmdpbmVfZHdoLnNhbXBsZXRpbWVrZWVwaW5nam9iXzRfMC5TYW1wbGVUaW1lS2VlcGluZ0pvYiQy LnJ1bihTYW1wbGVUaW1lS2VlcGluZ0pvYi5qYXZhOjExMzYxKQo= ------=_Part_3758020_756145403.1475295841164--

Adding some relevant people On Sat, Oct 1, 2016 at 6:24 AM, Andy <farkey_2000@yahoo.com> wrote:
Hello, I just upgraded to OVIRT 4.04 on the hosted appliance and for some reason I no longer see the DHW metrics on the dashboard. I receive a lot of errors, obviously, stating "ETL Service has encountered an error, Please consult the service log. The research that I have been able to come up with appears to be with a FK or a user that no longer exists in the database, however the attached logs have zero reference to these errors.
Any help would be appreciated.
Thanks Andy
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com <https://www.redhat.com/it/about/events/red-hat-open-source-day-2016>

On Mon, Oct 3, 2016 at 12:30 PM, Sandro Bonazzola <sbonazzo@redhat.com> wrote:
Adding some relevant people
Are you sure it's not a system/hardware issue? A bad disk, filesystem, network? If it was something temporary, you might manage to fix it using the hint in the error message: su - postgres -c "psql ovirt_engine_history -c 'REINDEX INDEX idx_vm_configuration_version_samples'" Adding also Eli. Best,
On Sat, Oct 1, 2016 at 6:24 AM, Andy <farkey_2000@yahoo.com> wrote:
Hello, I just upgraded to OVIRT 4.04 on the hosted appliance and for some reason I no longer see the DHW metrics on the dashboard. I receive a lot of errors, obviously, stating "ETL Service has encountered an error, Please consult the service log. The research that I have been able to come up with appears to be with a FK or a user that no longer exists in the database, however the attached logs have zero reference to these errors.
Any help would be appreciated.
Thanks Andy
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com <https://www.redhat.com/it/about/events/red-hat-open-source-day-2016>
-- Didi

Didi,</div><div id=3D"yui_3_16_0_ym19_1_1475669632171_3122"><br></div><div=
<br></div><div dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_1475669632171_3184">And= y <br></div><div class=3D"qtdSeparateBR"><br><br></div><div class=3D"yahoo_= quoted" style=3D"display: block;"> <div style=3D"font-family: HelveticaNeue= , Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 1= 0px;"> <div style=3D"font-family: HelveticaNeue, Helvetica Neue, Helvetica,= Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir=3D"ltr"><fon= t size=3D"2" face=3D"Arial"> On Wednesday, October 5, 2016 4:33 AM, Yedidya= h Bar David <didi@redhat.com> wrote:<br></font></div> <br><br> <div = class=3D"y_msg_container"><div id=3D"yiv3576292682"><div dir=3D"ltr"><div c= lass=3D"yiv3576292682gmail_extra"><div class=3D"yiv3576292682gmail_quote">O= n Mon, Oct 3, 2016 at 12:30 PM, Sandro Bonazzola <span dir=3D"ltr"><<a r= el=3D"nofollow" ymailto=3D"mailto:sbonazzo@redhat.com" target=3D"_blank" hr= ef=3D"mailto:sbonazzo@redhat.com">sbonazzo@redhat.com</a>></span> wrote:= <br><blockquote style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb= (204,204,204);padding-left:1ex;" class=3D"yiv3576292682gmail_quote"><div di= r=3D"ltr">Adding some relevant people</div></blockquote><div><br></div><div= Are you sure it's not a system/hardware issue? A bad disk, filesystem, net= work?<br><br></div><div>If it was something temporary, you might manage to = fix it using the hint in the error message:<br><br></div><div>su - postgres= -c "psql ovirt_engine_history -c 'REINDEX INDEX idx_vm_configuration_versi= on_samples'"<br></div><div><br>Adding also Eli.<br><br></div><div>Best,<br>= </div><div> </div><blockquote style=3D"margin:0px 0px 0px 0.8ex;border= -left:1px solid rgb(204,204,204);padding-left:1ex;" class=3D"yiv3576292682g= mail_quote"><div class=3D"yiv3576292682gmail_extra"><br><div class=3D"yiv35= 76292682gmail_quote"><div><div class=3D"yiv3576292682gmail-h5">On Sat, Oct = 1, 2016 at 6:24 AM, Andy <span dir=3D"ltr"><<a rel=3D"nofollow" ymailto= =3D"mailto:farkey_2000@yahoo.com" target=3D"_blank" href=3D"mailto:farkey_2= 000@yahoo.com">farkey_2000@yahoo.com</a>></span> wrote:<br></div></div><=
------=_Part_339970_436082828.1475669930159 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Didi, Thanks for the info,=C2=A0 it appears running the command your provided fix= ed the problem.=C2=A0 Upgrading the appliance could have corrupted the DB, = but as I recall I didnt receive any errors or nothing failed.=C2=A0 Thanks = for all the help guys.=20 Andy=20 On Wednesday, October 5, 2016 4:33 AM, Yedidyah Bar David <didi@redhat.= com> wrote: =20 On Mon, Oct 3, 2016 at 12:30 PM, Sandro Bonazzola <sbonazzo@redhat.com> wr= ote: Adding some relevant people Are you sure it's not a system/hardware issue? A bad disk, filesystem, netw= ork? If it was something temporary, you might manage to fix it using the hint in= the error message: su - postgres -c "psql ovirt_engine_history -c 'REINDEX INDEX idx_vm_config= uration_version_samples'" Adding also Eli. Best, =C2=A0 On Sat, Oct 1, 2016 at 6:24 AM, Andy <farkey_2000@yahoo.com> wrote: Hello, I just upgraded to OVIRT 4.04 on the hosted appliance and for some reason I= no longer see the DHW metrics on the dashboard. I receive a lot of errors,= obviously, stating "ETL Service has encountered an error, Please consult t= he service log. The research that I have been able to come up with appears = to be with a FK or a user that no longer exists in the database, however th= e attached logs have zero reference to these errors. Any help would be appreciated. Thanks Andy ______________________________ _________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman /listinfo/users --=20 Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com --=20 Didi =20 ------=_Part_339970_436082828.1475669930159 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <html><head></head><body><div style=3D"color:#000; background-color:#fff; f= ont-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, = sans-serif;font-size:10px"><div id=3D"yui_3_16_0_ym19_1_1475669632171_3183"= dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_1475669632171_3119">Thanks for the inf= o, it appears running the command your provided fixed the problem.&nb= sp; Upgrading the appliance could have corrupted the DB, but as I recall I = didnt receive any errors or nothing failed. Thanks for all the help g= uys. <br></div><div dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_1475669632171_3185"= blockquote style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,= 204,204);padding-left:1ex;" class=3D"yiv3576292682gmail_quote"><div><div cl= ass=3D"yiv3576292682gmail-h5"><div><div style=3D"color:rgb(0,0,0);backgroun= d-color:rgb(255,255,255);font-family:helveticaneue, helvetica neue, helveti= ca, arial, lucida grande, sans-serif;font-size:10px;"><div dir=3D"ltr">Hell= o,<br>I just upgraded to OVIRT 4.04 on the hosted appliance and for some re= ason I no longer see the DHW metrics on the dashboard. I receive a lot of e= rrors, obviously, stating "ETL Service has encountered an error, Please con= sult the service log. The research that I have been able to come up with ap= pears to be with a FK or a user that no longer exists in the database, howe= ver the attached logs have zero reference to these errors.<br><br>Any help = would be appreciated.<br></div><div dir=3D"ltr"><br></div><div dir=3D"ltr">= Thanks Andy</div></div></div><br></div></div>______________________________= _________________<br> Users mailing list<br> <a rel=3D"nofollow" ymailto=3D"mailto:Users@ovirt.org" target=3D"_blank" hr= ef=3D"mailto:Users@ovirt.org">Users@ovirt.org</a><br> <a rel=3D"nofollow" target=3D"_blank" href=3D"http://lists.ovirt.org/mailma= n/listinfo/users">http://lists.ovirt.org/mailman /listinfo/users</a><br> <br></blockquote></div><span class=3D"yiv3576292682gmail-HOEnZb"><font colo= r=3D"#888888"><br><br clear=3D"all"><div><br></div>-- <br><div><div dir=3D"= ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr">Sandro Bonazzola<br>Better= technology. Faster innovation. Powered by community collaboration.<br>See = how it works at <a rel=3D"nofollow" target=3D"_blank" href=3D"http://redhat= .com/">redhat.com</a><br></div></div><div dir=3D"ltr"><a rel=3D"nofollow" t= arget=3D"_blank" href=3D"https://www.redhat.com/it/about/events/red-hat-ope= n-source-day-2016"><img width=3D"420" height=3D"60"></a><br></div></div></d= iv></div></div> </font></span></div> </blockquote></div><br><br clear=3D"all"><br>-- <br><div class=3D"yiv357629= 2682gmail_signature">Didi<br></div> </div></div></div><br><br></div> </div> </div> </div></div></body></html> ------=_Part_339970_436082828.1475669930159--
participants (3)
-
Andy
-
Sandro Bonazzola
-
Yedidyah Bar David