2132792 - DELETE fails after upgrade from SAP IQ 15 to SAP IQ 16

After upgrading from SAP IQ 15.x to IQ 16 SP08 some delete statements fail with

• Invlaid key length found in dictionary errors

I. 02/06 20:39:11. 0000006958 [20917]: Delete of 1 rows started for table:
I. 02/06 20:39:11. 0000006958 Invalid key length found in the dictionary: maxLength = 50
I. 02/06 20:39:11. 0000006958   .. invalid key length = 17731
I. 02/06 20:39:11. 0000006958   .. invalid key length = 17731

• Query fails with  Non-Fatal Internal errors detected in s_dpidx.cxx 

I. 02/06 20:39:11. 0000006958     **       Non-Fatal IQ Internal Error Detected
I. 02/06 20:39:11. 0000006958     **       at slib/s_dpidx.cxx:1706  on thread 107 (TID 9)
...
I. 02/06 20:39:12. 0000006958 Exception Thrown from slib/s_dpidx.cxx:1706, Err# 16, tid 9 origtid 9
I. 02/06 20:39:12. 0000006958    O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
I. 02/06 20:39:12. 0000006958 [20238]: IQ Internal error. Please report this to SAP IQ support.
-- (slib/s_dpidx.cxx 1706)

• Stack trace is produced with failure at call to hs_dpidentity*hs_dp::GetIdentity

    ***************** This is the STACKTRACE ***************

I. 02/06 20:39:12. 0000006958
===== Thread Number  107  (IQ connID: 0000006958) =====
I. 02/06 20:39:12. 0000006958 pc: 0x0 (0x9, 0xfffffd7b97a87dc6)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b96b7384c void StackTraceForThisThread(const char*,int,const char*,const char*,const char*)+0x3c4(0x6aa99342e40, 0xfffffd7b98db5340)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b9739e6ab void hs_ThrowIdxException(const char*,int,hs_idxexception::hs_idxerrors,const s_index*,unsigned,const char*,const char*)+0x297(0x0, 0x0)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b96e33854 const hs_dpidentity*hs_dp::GetIdentity(int&)+0x36c(0x93b0a4ba8, 0x93ad4a838)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b97a893d5 hos_exception*db_IndexDef::FlushIndexIdentity()+0x275(0xfffffd7b00000000, 0x0)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b97909a5e void db_IndexDef::CloseSIndex(s_index*,int)+0x606(0x0, 0x93b14f310)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b9798bda0 void hdb_hdelete::Delete(const char*)+0x5c4(0x93b14f310, 0x93b14e9f8)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b964ef95d void dfo_DeleteRoot::Complete()+0x2b1(0xfffffd7b9b83bc40, 0xfffffd7b9642ec34)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b977e0c8a void st_cursorIQtoSA::Complete()+0x812(0xfffffd7b993b44f0, 0xfffffd7b9b83c9a0)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b9627fabd void df_Delete::Complete()+0x2d(0x1a, 0x0)
...

SAP IQ 15.x upgraded to SAP IQ 16 SP08

KBA , BC-SYB-IQ , Sybase IQ , Bug Filed