SAP Knowledge Base Article - Preview

2830861 - SAP IQ - Data type conversion not possible when comparing Datetime (ASE) to Datetime (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 , Problem

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.