Symptom
- During the import of an SAP System on SAP HANA Database, the creation of one or more flexible Indexes fails due to an SQL error 7 resulting in the entire package failing.
- Examination of the <package>.log shows the following error: "feature not supported: LANGUAGE DETECTION and FAST PREPROCESS ON not allowed"
Example: SAPAPPL2.log
(IMP) INFO: starting create for object "CUANC_ME_SPROF_T10" of type "flexible index" #20160524152255
DbSl Trace: execute(), rc=1, rcSQL=7
DbSl Trace: EXECUTE on connection 0, rc=7
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE FULLTEXT INDEX "CUANC_ME_SPROF_T10" ON "CUANC_ME_SPROF_T" ( "PROFILE_DESCR")
LANGUAGE DETECTION ('EN') FAST PREPROCESS ON FUZZY SEARCH INDEX ON SEARCH
ONLY ON ASYNC PHRASE INDEX RATIO 0.20 TOKEN SEPARATORS '\;,.:-_()[]<>!?*@+{}="&)/'
)
DbSlExecute: rc = 99
(SQL error 7)
error message returned by DbSl:
feature not supported: LANGUAGE DETECTION and FAST PREPROCESS ON not allowed
(IMP) ERROR: statement 1 of 1 failed for the object CUANC_ME_SPROF_T10
Read more...
Environment
- Currently the issue has been encountered on the following R3LDCTL / DBSL combination
- --------------------
- R3ldctl information
- --------------------
- kernel release 745
- kernel make variant 745_REL
- DBMS client library HDB_1.00.95.00.1429086950
- DBSL shared library version 745.04
- compiled on Linux GNU SLES-11 x86_64 cc4.3.4 use-pr160330i for linuxx86_64
- compiled for 64 BIT
- compilation mode UNICODE
- compile time Mar 30 2016 19:04:57
- update level 0
- patch number 113
- source id 0.113
- RKS compatibility level 0
- ---------------------
- supported environment
- ---------------------
- database (SAP, table SVERS) 740
- 750
- 751
- 762
- DBMS server
- HDB 1.0
- operating system
- Linux
Keywords
KBA , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , HAN-LM-INS-SAP , Installation of SAP Systems on HANA , 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.