SAP Knowledge Base Article - Preview

2949403 - Crash on a_dfe_context::DoMapToPhysicalHandle - SAP IQ

Symptom

IQ crashed due a stack trace where we can see the following functions:

=====

a_dfe_context::DoMapToPhysicalHandle
dfv_RowViewContextBase::MapPhysHandle
dfv_RowViewContextBase::GetValuePtr
SAInternalQuery::GetColValue
UIInternalQuery_GetColValue
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::Execute
dfo_EETableUDFLeafCursor::FetchOpus
dfo_Store::Fetch_IntoStore
dfo_Store::SourcePreFetch
dfo::SourcePreFetch
...
...

======

This occurs when inserting data and the schema of the result set is different than expected.

For example, we have this procedure and this temporary table:

=====

CREATE PROCEDURE pjavap(IN Environment VARCHAR(50),IN SQL VARCHAR(4096))
RESULT (
a int,
b int,
c int,
d int
)
EXTERNAL NAME 'Main.xxxxxxxx(xxxxxx/sql/ResultSet;)V'
LANGUAGE JAVA
GO


create table #test
(
a int,
b int,
c int null,
d int
)

=====

If we try to insert data into this temporary table, then crash occurs:

=====

Insert into #test (a,b,d)
Select a,b,d
From pjavap ('SSSSSSS','select a,b,d from mss_tb')

=====

If we execute select statement:

====

Select a,b,d
From pjavap ('SSSSSSS','select a,b,d from mss_test')

====

This returns an error instead of crashing IQ: SQL Anywhere Error -866: pjavap returned a result set with a different schema than expected.


Read more...

Environment

 SAP IQ 16.0 

Product

SAP IQ 16.0

Keywords

insert different schema result set expected crash a_dfe_context::DoMapToPhysicalHandle dfv_RowViewContextBase::MapPhysHandle dfv_RowViewContextBase::GetValuePtr SAInternalQuery::GetColValue UIInternalQuery_GetColValue st_SAIQInterfaceInfo::callFunctionk  822289 CR  822289 CR822289 , 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.