1 Reply Latest reply: Mar 22, 2018 8:35 AM by Peter Cammaert RSS

    Error: Unknown DROP statement in qv12.20

    Avinash Jain

      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