Oninit cdi / Archive
Talk to an expert →

Some SQL errors...

Posted in 2008

Topics: General Discussion

Paul — — source: Usenet: comp.databases.informix

Hello, Im having those errors: Summaries Failed Reason Code *Error_in_the_Summariser_or_an_interworking_component| SQL_error_was_received_at_execution_of_statement_insert_into_summariser_periods_values(?,?,?,?,?,?,?,?) *Dependent_tables_contained_no_data_to_be_summarised_for_the_period| No_Information *SQL_Error_during_Summary_execution| _Summary_failed_with_SQL_error_code_-239._Summary_error_details:_._Summary_failed_with_ISAM_error_code_-100._Error_processing_object_ids:_.

↪ replying to Paul
Colin Dawson — — source: Usenet: comp.databases.informix

SQL Code -239 is "Could not insert new row - duplicate value in a UNIQUE INDEXcolumn." check the data you're inserting Regards Colin There are 10 types of people in the world, those that understand binary and those that don't > From: petrybr@gmail.com> Subject: Some SQL errors...> Date: Tue, 1 Apr 2008 04:59:49 -0700> To: informix-list@iiug.org> > Hello,> > Im having those errors:> > Summaries Failed Reason Code> *Error_in_the_Summariser_or_an_interworking_component|> SQL_error_was_received_at_execution_of_statement_insert_into_summariser_periods_values(?,?,?,?,?,?,?,?)> > *Dependent_tables_contained_no_data_to_be_summarised_for_the_period|> No_Information> > *SQL_Error_during_Summary_execution|> _Summary_failed_with_SQL_error_code_-239._Summary_error_details:_._Summary_failed_with_ISAM_error_code_-100._Error_processing_object_ids:_.> > > _______________________________________________> Informix-list mailing list> Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Win 100’s of Virgin Experience days with BigSnapSearch.com http://www.bigsnapsearch.com

↪ replying to Paul
TBP — — source: Usenet: comp.databases.informix

On 1 Apr, 12:59, Paul <petr...@gmail.com> wrote: > Hello, > > Im having those errors: > > Summaries Failed Reason Code > *Error_in_the_Summariser_or_an_interworking_component| > SQL_error_was_received_at_execution_of_statement_insert_into_summariser_periods_values(?,?,?,?,?,?,?,?) > > *Dependent_tables_contained_no_data_to_be_summarised_for_the_period| > No_Information > > *SQL_Error_during_Summary_execution| > _Summary_failed_with_SQL_error_code_-239._Summary_error_details:_._Summary_failed_with_ISAM_error_code_-100._Error_processing_object_ids:_. "I'm" not Im "These" not those - or better still "... the following ..." and perhaps ... > *Dependent_tables_contained_no_data_to_be_summarised_for_the_period| > No_Information could be your initial problem, with : > _Summary_failed_with_SQL_error_code_-239._Summary_error_details:_._Summary_failed_with_ISAM_error_code_-100._Error_processing_object_ids:_. being a symptom -239 Could not insert new row - duplicate value in a UNIQUE INDEX column. Sounds like (perhaps) a run failed half way through and had already put a unique value in a summary table - i.e. no begin; "business logic"; commit approach. Sort out your data :D

Related threads