Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.