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

• 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

SAP IQ 15.3

dfo_Join.cxx 350

dfo_Join.cxx 435

SQLCODE=-1006001, ODBC 3 State="HY000"