Error: Unknown DROP statement in qv12.20

aj0031724 — Mon, 26 Jan 2026 18:19:17 GMT

Dear TEAM,

We upgraded to QV12.20 SR3 from QV11 SR13.

However during PARTAL RELOAD same scripts that get successful with QV11 is getting failed with ERROR IN QV12.20 SR3

Error: Unknown statement: ADD DROP TABLE.

Every DROP statement is failing in QV12.20 SR3.

PLEASE ADVISE AND HELP if ADD DROP TABLE is not supported in QV12 release and how can we do alternative solution.

PFA THE LOGS error

in QV12:

2018-03-21 16:05:52 0123 SheetsMappingCP:

2018-03-21 16:05:52 0124 ADD LOAD

2018-03-21 16:05:52 0125 SheetID

2018-03-21 16:05:52 0126 FROM

2018-03-21 16:05:52 0127 C:\qv\ScModel\Settings\SheetsConfiguration.xlsx

2018-03-21 16:05:52 0128

2018-03-21 16:05:52 0129 (ooxml, embedded labels, table is Sheet1)

2018-03-21 16:05:52 0130 WHERE SheetID ='CellProfile'

2018-03-21 16:05:52 1 fields found: SheetID,

2018-03-21 16:05:52 1 lines fetched

2018-03-21 16:05:52 0133 IF NoOfRows('SheetsMappingCP') > 0 THEN

2018-03-21 16:05:52 0134 SET CellProfile = 1

2018-03-21 16:05:52 0135 ELSE

2018-03-21 16:05:52 Error: Unknown statement: ADD DROP TABLE SheetsMappingCP

in QV11:

03/21/2018 16:04:44: 0124 SheetsMappingCP:

03/21/2018 16:04:44: 0125 ADD LOAD

03/21/2018 16:04:44: 0126 SheetID

03/21/2018 16:04:44: 0127 FROM

03/21/2018 16:04:44: 0128 D:\qv\ScModel\Settings\SheetsConfiguration.xlsx

03/21/2018 16:04:44: 0129

03/21/2018 16:04:44: 0130 (ooxml, embedded labels, table is Sheet1)

03/21/2018 16:04:44: 0131 WHERE SheetID ='CellProfile'

03/21/2018 16:04:44: 1 fields found: SheetID, 1 lines fetched

03/21/2018 16:04:44: 0134 IF NoOfRows('SheetsMappingCP') > 0 THEN

03/21/2018 16:04:44: 0135 SET CellProfile = 1

03/21/2018 16:04:44: 0136 ELSE

03/21/2018 16:04:44: 0140 ADD DROP TABLE SheetsMappingCP

Re: Error: Unknown DROP statement in qv12.20

Peter_Cammaert — Thu, 22 Mar 2018 12:35:04 GMT

The ADD prefix cannot be added to a DROP Table statement. See Add - QlikView

Simply remove the ADD prefix. As far as I can see, it doesn't serve any purpose.