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
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.
SAP Knowledge Base Article - Preview