2405459 - IQ got crashed when sp_iqrebuildindex executed in the process of upgrading to IQ16. | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

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