On rare occasions after executing a DML operation such as a LOAD, INSERT or UPDATE for tables that contain varchar or varbinary columns the SQL transaction may fail with messages like
- Invalid key length or offset found in the dictionary of index <table index name> (datatype as varchar): maxLength = 50 around token(1)
- s_Dictionary Dump Token varchar Keys
- slib/s_llhtable.cxx:3456 datatype varchar not supported yet.
- Non-Fatal IQ Internal Error Detected at slib/s_dpidx.cxx:7763
- Stacktrace calls …
You may also encounter these types of errors “slib/s_dpNBit.cxx:3186 invalid key offset”
This will only apply to index objects that were originally created in a IQ 15.x system and upgraded to IQ 16.x , where a index rebuild has not been done.
SAP IQ 16.0 any platform
SAP IQ 16.1 any platform
Only databases that were upgraded from a IQ 15.x version
sybase, upgrade, CR825351, CR#825351 , 825351, CR812631, CR#812631 , 812631, key, token, dictionary, fail, query, , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.