SAP Knowledge Base Article - Preview

2830861 - Data type conversion not possible when comparing Datetime (ASE) to Proxy Datetime (IQ) -SAP IQ


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
void opt_QueryTree::CreateInferredZoneMapDFP
void opt_QueryTree::InferZoneMapRestriction
void opt_QueryTree::GenerateInferredPredicates
void opt_QueryTree::ProcessPredicates
void opt_Select::ProcessPredicates
void opt_Driver::OptimizeQueryExp
void st_cursorIQtoSA::Parse
void df_OpenCursor::Parse
void st_command::DoCmdThroughResourceGate
unsigned st_iqdml::OpenCursor
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



SAP IQ 16.1 SP 4 PL 1


SAP IQ 16.1


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 ONE Support launchpad (Login required).

Search for additional results

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