SAP Knowledge Base Article - Preview

1961784 - IQ Internal error. Please report this to Sybase IQ support. Input to merge join #XX from child #YY not ordered as required.

Symptom

  • Non-Fatal IQ Internal Error Detected

Exception Thrown from dfo.cxx:10173, Err# 0, tid 5 origtid 5
O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006001, SQLState: 'QBA01', Severity: 23
IQ Internal error. Please report this to Sybase IQ support. Input to merge join #06 from child #03 not ordered as required. Key: FPVALUE(FPORDINAL(t.acid, 2))

  • With stack trace:

void dfo::ValidateOutputOrdering(const dfo*,const char*,const hos_vector_noerror&)
dfjo_MergeBase::ValidateInputOrdering(unsigned) const
dfo_Join::ValidateDFOInputOrdering() const
dfo::ValidateInputOrderings() const
dfo_Root::Prepare
db_cursorIQtoIQ::Prepare
db_sqlinsert::SPrepare
void db_sqlinsert::Prepare
 void st_command::DoCmdThroughResourceGate
unsigned st_iqdml::Insert(a_statement*,UIConnection*,UICursor*)
 UIQDML_Insert
 st_SAIQInterfaceInfo::callFunction
 st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)
st_SAIQInterface::Execute(int,void*,unsigned(*)(void*,void*),void*,unsigned
saint_iqthresholddml::Insert(a_statement*,IConnection*,ICursor*)
InsertFromSelect(a_db_cursor*,a_statement*,unsigned)
 dbi_insert(Connection*,a_statement*,a_stmt*,a_stmt_identifier*,unsigned,unsigned,TableDef*)
a_cursor*DoExecuteBodyLocal(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)
a_cursor*DoExecuteBody(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)
DoExecuteStmt(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,unsigned short,unsigned)
ExecuteStmt(Connection*,a_context_ref*,a_statement*,a_stmt*)
unsigned exec_procedure_stmt(Connection*,a_context_ref*,a_statement*,unsigned,unsigned)
unsigned run_procedure(a_context_ref*,dfm_CallInfo*,unsigned,Connection*,unsigned)
call_procedure(Connection*,a_proc_def*,a_trigger_def*,an_expr_node*,a_procedure_arg*,unsigned,a_db_cursor*,bool)
dbi_stmt_batch(a_statement*,a_procedure*,bool,unsigned)
*DoExecuteBodyLocal(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)
a_cursor*DoExecuteBody(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)
DoExecuteStmt(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,unsigned short,unsigned)
 db__execute(Connection*,an_sqlpres_receive*)
RequestProcedure::call()
 Context::call(Procedure*,Context**)
Worker::call_on_stack(Procedure*)
 TopProcedure
 Worker::spawn(Procedure
 EngStream::execute
unsigned RQBaseItem::do_work
DeferredCall::worker_body
request_task  UnixTask::pre_body


Read more...

Environment

SAP IQ 15.3

Product

SAP Sybase IQ 15.2

Keywords

dfo_Join.cxx 350
dfo_Join.cxx 435

SQLCODE=-1006001, ODBC 3 State="HY000"
, KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.