SAP Knowledge Base Article - Preview

2405459 - IQ got crashed when sp_iqrebuildindex executed in the process of upgrading to IQ16.

Symptom

IQ got crashed when sp_iqrebuildindex executed in the process of upgrading to IQ16.
Customer upgraded IQ from IQ12.5.
(12.5 -> 12.7 ESD#5 -> 16.0 SP11 PL04)

There were no Unfoced constraint, errors during iqunload.
All column is "flat fp" because of minimize_storage option was 'OFF' in IQ12.5.

> call "sp_iqrebuildindex"('DBA.Test_TB','column col1')

1. iqmsg
I. 12/13 18:45:10. 0000000037 Index Rebuild in progress for "DBA"."Test_TB" column "col1"
I. 12/13 18:45:10. 0000000037 ## hs_dpidentity :
I. 12/13 18:45:10. 0000000037 _version: 3
I. 12/13 18:45:10. 0000000037 _nLookupPages: 0
I. 12/13 18:45:10. 0000000037 _dpType: 4
I. 12/13 18:45:10. 0000000037 _nLookupEntries: 0
I. 12/13 18:45:10. 0000000037 _1stLookupPage: 0
I. 12/13 18:45:10. 0000000037 _nLargeLOBs: 0
I. 12/13 18:45:10. 0000000037 _nSmallLOBs: 0
I. 12/13 18:45:10. 0000000037 _unmergedIPs: 0
I. 12/13 18:45:10. 0000000037
I. 12/13 18:45:10. 0000000037
I. 12/13 18:45:10. 0000000037 **************************************************
I. 12/13 18:45:10. 0000000037 *** SAP IQ Abort:
I. 12/13 18:45:10. 0000000037 *** From: stcxtlib\st_server.cxx:996
I. 12/13 18:45:10. 0000000037 *** PID: 5264
I. 12/13 18:45:10. 0000000037 *** Message: Program Abort
I. 12/13 18:45:10. 0000000037 *** Thread: 4452 (TID: 2)
I. 12/13 18:45:10. 0000000037 **************************************************
I. 12/13 18:45:10. 0000000037
I. 12/13 18:45:10. 0000000037 ** Error from IQ connection: SA connHandle: 1 SA connID: 5 IQ connID: 0000000037 User: DBA
I. 12/13 18:45:10. 0000000037 ** Time of error: 2016-12-13 18:45:10
I. 12/13 18:45:10. 0000000037 ** IQ Version: SAP IQ/16.0.110/10339/P/sp11.04
I. 12/13 18:45:10. 0000000037 ** OS info: IQ built on: MS/Windows 2003, Executed on: Windows/BI_DB_MIRR/WinNT/6.1/Build 7601/Service Pack 1/x86 Family/level 6/Model 62/Stepping 4/4 CPU(s)
I. 12/13 18:45:10. 0000000037 ** Command status when error occured: CURSOR ACTIVE
I. 12/13 18:45:10. 0000000037 ** Command text:
call "sp_iqrebuildindex"('DBA.Test_TB','column col1')

2. stacktrace file
...
..MD5Final + 7656
.._C_specific_handler + 156
..RtlDecodePointer + 189
..RtlUnwindEx + 3007
..KiUserExceptionDispatcher + 46
..df_AttSingleStatsObj::`scalar deleting destructor'
..hs_dpidentity::DumpToIqmsg
..hs_dp::DumpDiagnostics
..hs_dp::ConvertMetadataFrom15x
..hs_dp::hs_dp
..db_IndexDef::OpenSIndexWithLock
..db_IndexDef::OpenSIndex
..opt_RebuildIndex::DestroyIndex
..opt_RebuildIndex::GenerateDFEs
..opt_Driver::GenerateTree
..db_RebuildIndex::Execute
..db_TableDef::RebuildIndex
..db_TableDef::RebuildIndexIfNeeded


Read more...

Environment

  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

IQ, SYBASE, sp_iqrebuildindex, upgrade, ConvertMetadataFrom15x, DumpToIqmsg, hs_dpidentity, RtlDecodePointer , 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 for Me (Login required).

Search for additional results

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