SAP Knowledge Base Article - Preview

2393516 - Query with GROUP BY could fire data conversion error or stack trace in hs_csortexception::hs_csortexception - SAP IQ

Symptom

Query with GROUP BY could fire

  • a data conversion error on version prior to IQ16 SP08 PL38 while no data conversion is required

Data exception - data type conversion is not possible: varchar( 20, 0) to smallint( 5, 0)
using local: SIGNED varchar to UNSIGNED smallint
Exception Thrown from oslib/hos_dfe.cxx:13768, Err# 0, tid 826 origtid 826
O/S Err#: 0, ErrID: 546 (hos_dtexception); SQLCode: -1009145, SQLState: 'QFA2E', Severity: 14
Data type conversion is not possible. varchar( 20, 0) to smallint( 5, 0).-- (oslib/hos_dfe.cxx 13768)

  • or a non-fatal stack trace in hs_csortexception::hs_csortexception on IQ16 SP11 PL04.

hs_csortexception::hs_csortexception
hs_csortRetriever::InitNextRetrieverRange
s_keyRangeWorkAllocator::AssignNextWork
df_CombinerFetchContext::PrepareForNextWorkUnit
hc_dmfrun::InitNextWorkUnit
hc_dmfrun::InitNextWorkUnit
hc_dmfrun::ExecWork
workAllocator::DoWork
hos_thread::Main


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

CR 792702 ; CR# 792702 ; 792702 ; hs_csortexception::hs_csortexception ; hs_csortexception ;
hs_csortRetriever::InitNextRetrieverRange ; hs_csortRetriever ; InitNextRetrieverRange
s_keyRangeWorkAllocator::AssignNextWork ; s_keyRangeWorkAllocator ; AssignNextWork ;
df_CombinerFetchContext::PrepareForNextWorkUnit ; df_CombinerFetchContext ; PrepareForNextWorkUnit , 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.