Hi David, Please update me on what you found.
Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd. ----- Original Message ----- > From: "Shirly Radco" <sra...@redhat.com> > To: "David van zeebroeck" <da...@analytics.brusselsairport.be> > Cc: users@ovirt.org > Sent: Sunday, February 1, 2015 11:24:10 AM > Subject: Re: [ovirt-users] dwh not receiving any data > > Hi David, > > It means that for some reason user with user_id > ab932902-cead-4435-a2b6-8b88576feab6 > was not added to users_details_history. > And this is why the etl can't update the vm_samples_history table on the > ovirt_engine_history database. > > Please check if this user_id ab932902-cead-4435-a2b6-8b88576feab6 exists in > the "dwh_users_history_view" or in the users table in the engine database. > > Select * From dwh_users_history_view > Where user_id = 'ab932902-cead-4435-a2b6-8b88576feab6'; > > Best regards, > --- > Shirly Radco > BI Software Engineer > Red Hat Israel Ltd. > > > ----- Original Message ----- > > From: "David van zeebroeck" <da...@analytics.brusselsairport.be> > > To: users@ovirt.org > > Sent: Thursday, January 29, 2015 5:10:01 PM > > Subject: [ovirt-users] dwh not receiving any data > > > > hi > > we are running ovirt 3.5.1 and we are trying to setup the dwh part > > install and setup appears to run fine but when starting the service we see > > following error in the log file : > > > > 2015-01-29 16:06:26|ETL Service Started > > Exception in component tJDBCOutput_5 > > org.postgresql.util.PSQLException: ERROR: insert or update on table > > "vm_samples_history" violates foreign key constraint > > "vm_samples_history_current_user_id_fkey" > > Detail: Key (current_user_id)=(ab932902-cead-4435-a2b6-8b88576feab6) is not > > present in table "users_details_history". > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > > at > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > > at > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_10Process(StatisticsSync.java:10482) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$6.run(StatisticsSync.java:17437) > > Exception in component tJDBCOutput_6 > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > > commands ignored until end of transaction block > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > > at > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > > at > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_12Process(StatisticsSync.java:12689) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$7.run(StatisticsSync.java:17483) > > Exception in component tJDBCOutput_7 > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > > commands ignored until end of transaction block > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > > at > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > > at > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_18Process(StatisticsSync.java:14806) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$8.run(StatisticsSync.java:17529) > > Exception in component tJDBCOutput_4 > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > > commands ignored until end of transaction block > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > > at > > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > > at > > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync.tJDBCInput_8Process(StatisticsSync.java:7788) > > at > > ovirt_engine_dwh.statisticssync_3_5.StatisticsSync$5.run(StatisticsSync.java:17391) > > 2015-01-29 > > 16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java > > Exception|tJDBCOutput_7|org.postgresql.util.PSQLException:ERROR: current > > transaction is aborted, commands ignored until end of transaction block|1 > > 2015-01-29 > > 16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java > > Exception|tJDBCOutput_5|org.postgresql.util.PSQLException:ERROR: insert or > > update on table "vm_samples_history" violates foreign key constraint > > "vm_samples_history_current_user_id_fkey" > > Detail: Key (current_user_id)=(ab932902-cead-4435-a2b6-8b88576feab6) is not > > present in table "users_details_history".|1 > > 2015-01-29 > > 16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java > > Exception|tJDBCOutput_6|org.postgresql.util.PSQLException:ERROR: current > > transaction is aborted, commands ignored until end of transaction block|1 > > 2015-01-29 > > 16:07:04|kGEf8p|YhA1NE|VVdF7H|OVIRT_ENGINE_DWH|StatisticsSync|Default|6|Java > > Exception|tJDBCOutput_4|org.postgresql.util.PSQLException:ERROR: current > > transaction is aborted, commands ignored until end of transaction block|1 > > Exception in component tRunJob_5 > > java.lang.RuntimeException: Child job running failed > > at > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_5Process(SampleRunJobs.java:1598) > > at > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_6Process(SampleRunJobs.java:1412) > > at > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_1Process(SampleRunJobs.java:1197) > > at > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:982) > > at > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762) > > at > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641) > > at > > ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560) > > 2015-01-29 > > 16:07:04|VVdF7H|YhA1NE|XpLXfK|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java > > Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1 > > Exception in component tRunJob_1 > > java.lang.RuntimeException: Child job running failed > > at > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941) > > at > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707) > > at > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340) > > at > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219) > > at > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092) > > at > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505) > > at > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877) > > at > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191) > > at > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537) > > at > > ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546) > > > > > > _______________________________________________ > > Users mailing list > > Users@ovirt.org > > http://lists.ovirt.org/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users