<div dir="ltr">Hi,<div><br></div><div>My issue resolved by remove the dwh and reports and reinstall again......also i found that my server time was correct and updated but the postgresql time was different form the server time.....above two changes made it work...</div><div><br></div><div>Thanks,</div><div>punit</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Feb 2, 2015 at 8:25 PM, Shirly Radco <span dir="ltr"><<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
If any of you can send me the engine and ovirt_engine_dwh dump,<br>
I will upload them in my development environment and see what is the issue.<br>
<span class="im HOEnZb"><br>
Best regards,<br>
---<br>
Shirly Radco<br>
BI Software Engineer<br>
Red Hat Israel Ltd.<br>
<br>
<br>
----- Original Message -----<br>
> From: "Shirly Radco" <<a href="mailto:sradco@redhat.com">sradco@redhat.com</a>><br>
> To: "David van zeebroeck" <<a href="mailto:david@analytics.brusselsairport.be">david@analytics.brusselsairport.be</a>><br>
> Cc: <a href="mailto:users@ovirt.org">users@ovirt.org</a><br>
</span><div class="HOEnZb"><div class="h5">> Sent: Monday, February 2, 2015 1:04:24 PM<br>
> Subject: Re: [ovirt-users] dwh not receiving any data<br>
><br>
> Hi David,<br>
><br>
> Please update me on what you found.<br>
><br>
> Best regards,<br>
> ---<br>
> Shirly Radco<br>
> BI Software Engineer<br>
> Red Hat Israel Ltd.<br>
><br>
><br>
> ----- Original Message -----<br>
> > From: "Shirly Radco" <<a href="mailto:sradco@redhat.com">sradco@redhat.com</a>><br>
> > To: "David van zeebroeck" <<a href="mailto:david@analytics.brusselsairport.be">david@analytics.brusselsairport.be</a>><br>
> > Cc: <a href="mailto:users@ovirt.org">users@ovirt.org</a><br>
> > Sent: Sunday, February 1, 2015 11:24:10 AM<br>
> > Subject: Re: [ovirt-users] dwh not receiving any data<br>
> ><br>
> > Hi David,<br>
> ><br>
> > It means that for some reason user with user_id<br>
> > ab932902-cead-4435-a2b6-8b88576feab6<br>
> > was not added to users_details_history.<br>
> > And this is why the etl can't update the vm_samples_history table on the<br>
> > ovirt_engine_history database.<br>
> ><br>
> > Please check if this user_id ab932902-cead-4435-a2b6-8b88576feab6 exists in<br>
> > the "dwh_users_history_view" or in the users table in the engine database.<br>
> ><br>
> > Select * From dwh_users_history_view<br>
> > Where user_id = 'ab932902-cead-4435-a2b6-8b88576feab6';<br>
> ><br>
> > Best regards,<br>
> > ---<br>
> > Shirly Radco<br>
> > BI Software Engineer<br>
> > Red Hat Israel Ltd.<br>
> ><br>
> ><br>
> > ----- Original Message -----<br>
> > > From: "David van zeebroeck" <<a href="mailto:david@analytics.brusselsairport.be">david@analytics.brusselsairport.be</a>><br>
> > > To: <a href="mailto:users@ovirt.org">users@ovirt.org</a><br>
> > > Sent: Thursday, January 29, 2015 5:10:01 PM<br>
> > > Subject: [ovirt-users] dwh not receiving any data<br>
> > ><br>
> > > hi<br>
> > > we are running ovirt 3.5.1 and we are trying to setup the dwh part<br>
> > > install and setup appears to run fine but when starting the service we<br>
> > > see<br>
> > > following error in the log file :<br>
> > ><br>
> > > 2015-01-29 16:06:26|ETL Service Started<br>
> > > Exception in component tJDBCOutput_5<br>
> > > org.postgresql.util.PSQLException: ERROR: insert or update on table<br>
> > > "vm_samples_history" violates foreign key constraint<br>
> > > "vm_samples_history_current_user_id_fkey"<br>
> > > Detail: Key (current_user_id)=(ab932902-cead-4435-a2b6-8b88576feab6) is<br>
> > > not<br>
> > > present in table "users_details_history".<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)<br>
> > > at<br>
> > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_10Process(StatisticsSync.java:10482)<br>
> > > at<br>
> > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$6.run(StatisticsSync.java:17437)<br>
> > > Exception in component tJDBCOutput_6<br>
> > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted,<br>
> > > commands ignored until end of transaction block<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)<br>
> > > at<br>
> > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_12Process(StatisticsSync.java:12689)<br>
> > > at<br>
> > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$7.run(StatisticsSync.java:17483)<br>
> > > Exception in component tJDBCOutput_7<br>
> > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted,<br>
> > > commands ignored until end of transaction block<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)<br>
> > > at<br>
> > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_18Process(StatisticsSync.java:14806)<br>
> > > at<br>
> > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$8.run(StatisticsSync.java:17529)<br>
> > > Exception in component tJDBCOutput_4<br>
> > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted,<br>
> > > commands ignored until end of transaction block<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)<br>
> > > at<br>
> > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)<br>
> > > at<br>
> > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)<br>
> > > at<br>
> > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_8Process(StatisticsSync.java:7788)<br>
> > > at<br>
> > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$5.run(StatisticsSync.java:17391)<br>
> > > 2015-01-29<br>
> > > 16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java<br>
> > > Exception|tJDBCOutput_7|org.postgresql.util.PSQLException:ERROR: current<br>
> > > transaction is aborted, commands ignored until end of transaction block|1<br>
> > > 2015-01-29<br>
> > > 16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java<br>
> > > Exception|tJDBCOutput_5|org.postgresql.util.PSQLException:ERROR: insert<br>
> > > or<br>
> > > update on table "vm_samples_history" violates foreign key constraint<br>
> > > "vm_samples_history_current_user_id_fkey"<br>
> > > Detail: Key (current_user_id)=(ab932902-cead-4435-a2b6-8b88576feab6) is<br>
> > > not<br>
> > > present in table "users_details_history".|1<br>
> > > 2015-01-29<br>
> > > 16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java<br>
> > > Exception|tJDBCOutput_6|org.postgresql.util.PSQLException:ERROR: current<br>
> > > transaction is aborted, commands ignored until end of transaction block|1<br>
> > > 2015-01-29<br>
> > > 16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java<br>
> > > Exception|tJDBCOutput_4|org.postgresql.util.PSQLException:ERROR: current<br>
> > > transaction is aborted, commands ignored until end of transaction block|1<br>
> > > Exception in component tRunJob_5<br>
> > > java.lang.RuntimeException: Child job running failed<br>
> > > at<br>
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_5Process(SampleRunJobs.java:1598)<br>
> > > at<br>
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_6Process(SampleRunJobs.java:1412)<br>
> > > at<br>
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_1Process(SampleRunJobs.java:1197)<br>
> > > at<br>
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:982)<br>
> > > at<br>
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)<br>
> > > at<br>
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)<br>
> > > at<br>
> > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)<br>
> > > 2015-01-29<br>
> > > 16:07:04|VVdF7H|YhA1NE|XpLXfK|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java<br>
> > > Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1<br>
> > > Exception in component tRunJob_1<br>
> > > java.lang.RuntimeException: Child job running failed<br>
> > > at<br>
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)<br>
> > > at<br>
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)<br>
> > > at<br>
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)<br>
> > > at<br>
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)<br>
> > > at<br>
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)<br>
> > > at<br>
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)<br>
> > > at<br>
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)<br>
> > > at<br>
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)<br>
> > > at<br>
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)<br>
> > > at<br>
> > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)<br>
> > ><br>
> > ><br>
> > > _______________________________________________<br>
> > > Users mailing list<br>
> > > <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
> > > <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
> > ><br>
> > _______________________________________________<br>
> > Users mailing list<br>
> > <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
> > <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
> ><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
> <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
><br>
</div></div></blockquote></div><br></div>