Symptom
- When Replication Server replicates to IQ, the DSI bulk copy-in feature fails with "SQL Anywhere Error -1006000: IQ Internal error" :
ERROR #151 DSI EXEC(136(1) IQserver.IQdatabase) - i/hqexec.c(11975)
Bulk-Lib routine 'RCIMoreResults' failed.
ERROR #1028 DSI EXEC(136(1) IQserver.IQdatabase) - i/hqexec.c(11975)
Message from server: Message: -1006000, State 0, Severity 23 -- 'SQL Anywhere Error -1006000: IQ Internal error. Please report this to Sybase IQ support.-- (dfjo_Hash.cxx 1943) '.
HQCPL: HQ execution exception occurred while applying to table [nil][nil]...
A grouped transaction of 47470 individual transactions has failed in database 'IQserver.IQdatabase'. It will be broken into smaller groups and retried.
- The IQ .iqmsg file reports the following error with the stack trace on a connection from Replication Server:
********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at dfjo_Hash.cxx:1943 on thread 30070 (TID 24)
**
** Please report this to Sybase IQ support
** with the following diagnostic information,
** and, if possible, with the user's command.
**
** Error from IQ connection: SA connHandle: 17826 SA connID: 13 IQ connID: 0000481757 User: xxxxx_maint
** Time of error: 2014-05-03 21:19:55
** IQ Version: Sybase IQ/15.4.0/140325/P/ESD 3.9
** OS info: IQ built on: RS6000MP/AIX 6.1.0, Executed on: AIX/dbspp0075/1/6/00C06D774C00
** Command status when error occured: CURSOR ACTIVE
.....
Exception Thrown from dfjo_Hash.cxx:1943, Err# 0, tid 24 origtid 24
O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
IQ Internal error. Please report this to Sybase IQ support.
- The top calls in the IQ stack trace are as follows:
.dfjo_Hash::ComputeKeyEstimates()
.dfjo_Hash::PrePrepare()
.dfo_Join::PrePrepare()+0xfc()
.dfo::RecursivePrePrepare()
.dfo::RecursivePrePrepare()
.dfo::RecursivePrePrepare()
.dfo_Root::Prepare()+0x710()
.dfo_DeleteRoot::Prepare()
.st_cursorIQtoSA::Prepare()
.df_dmlcommand::Prepare()
.st_command::DoCmdThroughResourceGate()
.st_iqdml::Delete()
.UIQDML_Delete()
...
.dbi_delete()
...
Read more...
Environment
- SAP Replication Server 15.7
- SAP IQ 15.4
- SAP IQ 16.0
Product
Keywords
CR763801, dfjo_Hash::ComputeKeyEstimates, .dfjo_Hash::PrePrepare, .dfo_Join::PrePrepare, .dfo::RecursivePrePrepare, 763801 , KBA , BC-SYB-IQ , Sybase IQ , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.