Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

aj0031724
Contributor

Error: Unknown DROP statement in qv12.20

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

1 Reply

Re: Error: Unknown DROP statement in qv12.20

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.

Community Browser