sap errors and solutions

Just another SAP blog

sql syntax error: incorrect syntax near “drpfulltext”

Error:

(RDI) WARNING: C:\software\Export\ABAP\DATA\SAPAPPL2_4.STR: cannot find version token “ver:” at line 1
(RDI) WARNING: C:\software\Export\ABAP\DATA\SAPAPPL2_4.STR: unknown file format, assuming version 2
(DB) WARNING: mass import for LOBs is not supported: current HANA database version ‘1.00.102.’ is blacklisted (version is in the range ‘1.00.051.000000’ – ‘1.00.099.999999’)
(IMP) INFO: starting create for object “RSLTIPT~010” of type “index” #20161207151626
(SQL) INFO: index RSLTIPT~010: CREATE overridden by ‘C:\software\Export\ABAP\DB/HDB/APPL2.SQL’, line 5
DbSl Trace:   execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(DROP INDEX “RSLTIPT~010” drpfulltext: DROP INDEX “RSLTIPT~010”)
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:

sql syntax error: incorrect syntax near “drpfulltext”: line 1 col 26 (at pos 26)
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(SQL) INFO: index RSLTIPT~010: CREATE overridden by ‘C:\software\Export\ABAP\DB/HDB/APPL2.SQL’, line 5
DbSl Trace:   execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE FULLTEXT INDEX “RSLTIPT~010” ON “RSLTIPT” ( “DESCRIPTION”) FAST PREPROCESS           ON FUZZY SEARCH INDEX ON SEARCH ONLY ON SYNC PHRASE INDEX RATIO 0.20 TOKEN           SEPARATORS ‘ \)
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:

sql syntax error: unterminated quoted string literal: line 1 col 189 (at pos 189)
(IMP) INFO: starting create for object “SIMDQ_DESCRIP~FZY” of type “index” #20161207151626
(SQL) INFO: index SIMDQ_DESCRIP~FZY: CREATE overridden by ‘C:\software\Export\ABAP\DB/HDB/APPL2.SQL’, line 27
DbSl Trace:   execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(DROP INDEX “SIMDQ_DESCRIP~FZY” drpfulltext: DROP INDEX “SIMDQ_DESCRIP~FZY”)
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:

sql syntax error: incorrect syntax near “drpfulltext”: line 1 col 32 (at pos 32)
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(SQL) INFO: index SIMDQ_DESCRIP~FZY: CREATE overridden by ‘C:\software\Export\ABAP\DB/HDB/APPL2.SQL’, line 27
DbSl Trace:   execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE FULLTEXT INDEX “SIMDQ_DESCRIP~FZY” ON “SIMDQ_DESCRIP” ( “DESCRIPTION”)           LANGUAGE COLUMN “LANGU” LANGUAGE DETECTION (‘EN’) FAST PREPROCESS OFF FUZZY           SEARCH INDEX ON SEARCH ONLY ON ASYNC PHRASE INDEX RATIO 0.20 TOKEN SEPARATORS           ‘\)
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:

sql syntax error: unterminated quoted string literal: line 1 col 263 (at pos 263)
(IMP) INFO: starting create for object “SIMDQ_DSC_CLNT~FZY” of type “index” #20161207151626
(SQL) INFO: index SIMDQ_DSC_CLNT~FZY: CREATE overridden by ‘C:\software\Export\ABAP\DB/HDB/APPL2.SQL’, line 21
DbSl Trace:   execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(DROP INDEX “SIMDQ_DSC_CLNT~FZY” drpfulltext: DROP INDEX “SIMDQ_DSC_CLNT~FZY”)
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:

sql syntax error: incorrect syntax near “drpfulltext”: line 1 col 33 (at pos 33)
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(SQL) INFO: index SIMDQ_DSC_CLNT~FZY: CREATE overridden by ‘C:\software\Export\ABAP\DB/HDB/APPL2.SQL’, line 21
DbSl Trace:   execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE FULLTEXT INDEX “SIMDQ_DSC_CLNT~FZY” ON “SIMDQ_DSC_CLNT” ( “DESCRIPTION”)           LANGUAGE COLUMN “LANGU” LANGUAGE DETECTION (‘EN’) FAST PREPROCESS OFF FUZZY           SEARCH INDEX ON SEARCH ONLY ON ASYNC PHRASE INDEX RATIO 0.20 TOKEN SEPARATORS           ‘\)
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:

sql syntax error: unterminated quoted string literal: line 1 col 265 (at pos 265)
(IMP) INFO: starting create for object “SIMDQ_NAME~FZY” of type “index” #20161207151626
(SQL) INFO: index SIMDQ_NAME~FZY: CREATE overridden by ‘C:\software\Export\ABAP\DB/HDB/APPL2.SQL’, line 16
DbSl Trace:   execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(DROP INDEX “SIMDQ_NAME~FZY” drpfulltext: DROP INDEX “SIMDQ_NAME~FZY”)
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:

sql syntax error: incorrect syntax near “drpfulltext”: line 1 col 29 (at pos 29)
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(SQL) INFO: index SIMDQ_NAME~FZY: CREATE overridden by ‘C:\software\Export\ABAP\DB/HDB/APPL2.SQL’, line 16
DbSl Trace:   execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE FULLTEXT INDEX “SIMDQ_NAME~FZY” ON “SIMDQ_NAME” ( “NAME”) LANGUAGE           COLUMN “LANGU” LANGUAGE DETECTION (‘EN’) FAST PREPROCESS OFF SEARCH ONLY           ON ASYNC PHRASE INDEX RATIO 0.20 TOKEN SEPARATORS ‘\)
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:

sql syntax error: unterminated quoted string literal: line 1 col 218 (at pos 218)
(IMP) INFO: starting create for object “SIMDQ_NAM_CLNT~FZY” of type “index” #20161207151626
(SQL) INFO: index SIMDQ_NAM_CLNT~FZY: CREATE overridden by ‘C:\software\Export\ABAP\DB/HDB/APPL2.SQL’, line 10
DbSl Trace:   execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(DROP INDEX “SIMDQ_NAM_CLNT~FZY” drpfulltext: DROP INDEX “SIMDQ_NAM_CLNT~FZY”)
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:

sql syntax error: incorrect syntax near “drpfulltext”: line 1 col 33 (at pos 33)
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(SQL) INFO: index SIMDQ_NAM_CLNT~FZY: CREATE overridden by ‘C:\software\Export\ABAP\DB/HDB/APPL2.SQL’, line 10
DbSl Trace:   execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE FULLTEXT INDEX “SIMDQ_NAM_CLNT~FZY” ON “SIMDQ_NAM_CLNT” ( “NAME”)           LANGUAGE COLUMN “LANGU” LANGUAGE DETECTION (‘EN’) FAST PREPROCESS OFF SEARCH           ONLY ON ASYNC PHRASE INDEX RATIO 0.20 TOKEN SEPARATORS ‘\)
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:

sql syntax error: unterminated quoted string literal: line 1 col 226 (at pos 226)
(DB) INFO: disconnected from DB

Solution:

Follow note 2031638 to resolve the issue.

Updated: December 7, 2016 — 9:00 pm

Leave a Reply

Your email address will not be published. Required fields are marked *

sap errors and solutions © 2016 Frontier Theme
Copy Protected by Chetan's WP-Copyprotect.