SAP Knowledge Base Article - Preview

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

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

SAP IQ 16.1

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.