Symptom
When attempting to run an SQL command that compairs two dates, one from ASE and the other a proxy IQ.
IQ throws following error and a non-fatal StackTrace
Data type conversion is not possible. datetime( 23, 0) to datetimex( 27, 0)
********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at oslib/hos_dfe.cxx:13994 on thread 45 (TID 7)
** Conversion Error
**
void StackTraceForThisThread
int hos_dfe_KeyCompare
dfe*opt_QueryTree::ConvertConstantDataType
void opt_QueryTree::CreateInferredZoneMapDFP
void opt_QueryTree::InferZoneMapRestriction
void opt_QueryTree::GenerateInferredPredicates
void opt_QueryTree::ProcessPredicates
void opt_Select::ProcessPredicates
void opt_Driver::OptimizeQueryExp
dfo_Root*opt_Driver::GenerateTree
void st_cursorIQtoSA::Parse
void df_OpenCursor::Parse
void st_command::DoCmdThroughResourceGate
unsigned st_iqdml::OpenCursor
UIQDML_OpenCursor+0x20
void st_SAIQInterfaceInfo::callFunction
void st_SAIQInterface::RunIQFunc
void st_SAIQInterface::Execute
unsigned saint_iqthresholddml::OpenCursor
dfo::Status df_OmniRowScan::Restart
dfo::Status dfo_Scan::DoFetch
dfo::Status dfo_Scan::DoFirstFetch
dfo::Status dfo_Base::Fetch
dfo::Status dfo_Root::DoFetch
dfo::Status dfo_Root::DoFirstFetch
dfo::Status dfo_Base::Fetch
a_search_status dfo_Root::DoFetchRelative
a_search_status dfo_Root::FetchRelative
Read more...
Environment
SAP IQ 16.1 SP 4 PL 1
Product
Keywords
CR 819971. CR819971, DATETIME, Convert, Conversion, , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.