1 Reply Latest reply on Oct 12, 2016 10:56 AM by Michael Gee

    Data Loading Errors

    Michael Gee

      I've recently upgraded to Version 10, and when I try to drill into the Full Data, I get the following message:

      • [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'LIMIT'.
      • [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

       

      The script is shown below.  I assume it has to do with the limit amount at the bottom of the script.  Is there a way I can fix this?

       

      SELECT CAST(CAST("v_ZUSRebates"."Date" AS DATE) AS DATE) AS "Date",

        "v_ZUSParkingAdmin"."Id_Parking" AS "Id_Parking",

        1 AS "Number_of_Records",

        "v_ZUSParkingAdmin"."ParkingName" AS "ParkingName",

        "v_ZUSRebates"."RebateAmount" AS "RebateAmount",

        "v_ZUSParkingAdmin"."ShortName" AS "ShortName",

        "v_ZUSRebates"."TicketId" AS "TicketId",

        "v_ZUSRebates"."Time" AS "Time",

        "v_ZUSRebateTypes"."identifier" AS "identifier",

        "v_ZUSRebateTypes"."type" AS "type"

      FROM "dbo"."v_ZUSParkingAdmin" "v_ZUSParkingAdmin"

        INNER JOIN "dbo"."v_ZUSRebates" "v_ZUSRebates" ON ("v_ZUSParkingAdmin"."Id_Parking" = "v_ZUSRebates"."Id_Parking")

        INNER JOIN "dbo"."v_ZUSRebateTypes" "v_ZUSRebateTypes" ON ("v_ZUSRebates"."RebateType" = "v_ZUSRebateTypes"."type")

      WHERE (((CAST("v_ZUSRebates"."Date" AS DATE) >= {d '2015-10-01'}) AND (CAST("v_ZUSRebates"."Date" AS DATE) <= {d '2016-09-30'})) AND ((((CAST({fn TRUNCATE({fn EXTRACT(YEAR FROM CAST(CAST("v_ZUSRebates"."Date" AS DATE) AS DATE))},0)} AS INTEGER) * 100) + CAST({fn TRUNCATE({fn EXTRACT(MONTH FROM CAST(CAST("v_ZUSRebates"."Date" AS DATE) AS DATE))},0)} AS INTEGER)) = 201607) AND ("v_ZUSRebateTypes"."identifier" = '$100 off')))

      LIMIT 75000