Discussions

Expand all | Collapse all

error code -1

  • 1.  error code -1

    Posted 07-17-2019 00:53
    Edited by Nagulan Santhi 07-17-2019 02:44
    i am getting "Other error: code -1"
    and sometimes "error code 16803"

    frequently while quering i cant find the root cause of this error can someone help on this
    i am getting error in both cpu version and gpu version

    SELECT "m5d2d671c_product".m_description AS "label_product.description", "m5d2d671c_SO_ITEM".m_productnum AS "label_SO_ITEM.productnum", "m5d2d671c_SO".m_so_num AS "label_SO.so_num", coalesce(round(CAST(sum("m5d2d671c_SO_ITEM".m_totalprice) AS DOUBLE PRECISION), 2), 0) AS "label_SO_ITEM.totalprice", coalesce(round(CAST(sum("m5d2d671c_SO_ITEM".m_item_margin) AS DOUBLE PRECISION), 2), 0) AS "label_SO_ITEM.item_margin", coalesce(round(CAST(sum("m5d2d671c_SO_ITEM".m_totalcost) AS DOUBLE PRECISION), 2), 0) AS "label_SO_ITEM.totalcost", "m5d2d671c_SO_ITEM".m_soitem_type AS "label_SO_ITEM.soitem_type", "m5d2d671c_SO_ITEM".m_soitem_status AS "label_SO_ITEM.soitem_status", "m5d2d671c_SO_ITEM".m_datescheduledfulfillment AS "label_SO_ITEM.datescheduledfulfillment" FROM "m5d2d671c_product", "m5d2d671c_SO_ITEM", "m5d2d671c_SO" WHERE "m5d2d671c_SO_ITEM".m_productId = "m5d2d671c_product".m_id AND "m5d2d671c_SO".m_so_id = "m5d2d671c_SO_ITEM".m_soid GROUP BY "m5d2d671c_product".m_description, "m5d2d671c_SO_ITEM".m_productnum, "m5d2d671c_SO".m_so_num, "m5d2d671c_SO_ITEM".m_soitem_type, "m5d2d671c_SO_ITEM".m_soitem_status, "m5d2d671c_SO_ITEM".m_datescheduledfulfillment ORDER BY "m5d2d671c_product".m_description, "m5d2d671c_SO_ITEM".m_productnum, "m5d2d671c_SO".m_so_num, "m5d2d671c_SO_ITEM".m_soitem_type, "m5d2d671c_SO_ITEM".m_soitem_status, "m5d2d671c_SO_ITEM".m_datescheduledfulfillment, "label_SO_ITEM.totalprice" DESC, "label_SO_ITEM.totalcost" DESC, "label_SO_ITEM.item_margin" DESC

    the above is the example query but query seems to be correct

    #Core
    #Immerse
    #General


  • 2.  RE: error code -1

    Posted 07-18-2019 04:47
    Hi @Nagulan Santhi,

    query
    SELECT
        "m5d2d671c_product".m_description AS "label_product.description",
        "m5d2d671c_SO_ITEM".m_productnum AS "label_SO_ITEM.productnum",
        "m5d2d671c_SO".m_so_num AS "label_SO.so_num",
        coalesce(
            round(
                CAST(SUM("m5d2d671c_SO_ITEM".m_totalprice) AS DOUBLE PRECISION),
                2
            ),
            0
        ) AS "label_SO_ITEM.totalprice",
        coalesce(
            round(
                CAST(SUM("m5d2d671c_SO_ITEM".m_item_margin) AS DOUBLE PRECISION),
                2
            ),
            0
        ) AS "label_SO_ITEM.item_margin",
        coalesce(
            round(
                CAST(SUM("m5d2d671c_SO_ITEM".m_totalcost) AS DOUBLE PRECISION),
                2
            ),
            0
        ) AS "label_SO_ITEM.totalcost",
        "m5d2d671c_SO_ITEM".m_soitem_type AS "label_SO_ITEM.soitem_type",
        "m5d2d671c_SO_ITEM".m_soitem_status AS "label_SO_ITEM.soitem_status",
        "m5d2d671c_SO_ITEM".m_datescheduledfulfillment AS "label_SO_ITEM.datescheduledfulfillment"
    FROM
        "m5d2d671c_product",
        "m5d2d671c_SO_ITEM",
        "m5d2d671c_SO"
    WHERE
            "m5d2d671c_SO_ITEM".m_productid = "m5d2d671c_product".m_id
        AND
            "m5d2d671c_SO".m_so_id = "m5d2d671c_SO_ITEM".m_soid
    GROUP BY
        "m5d2d671c_product".m_description,
        "m5d2d671c_SO_ITEM".m_productnum,
        "m5d2d671c_SO".m_so_num,
        "m5d2d671c_SO_ITEM".m_soitem_type,
        "m5d2d671c_SO_ITEM".m_soitem_status,
        "m5d2d671c_SO_ITEM".m_datescheduledfulfillment
    ORDER BY
        "m5d2d671c_product".m_description,
        "m5d2d671c_SO_ITEM".m_productnum,
        "m5d2d671c_SO".m_so_num,
        "m5d2d671c_SO_ITEM".m_soitem_type,
        "m5d2d671c_SO_ITEM".m_soitem_status,
        "m5d2d671c_SO_ITEM".m_datescheduledfulfillment,
        "label_SO_ITEM.totalprice" DESC,
        "label_SO_ITEM.totalcost" DESC,
        "label_SO_ITEM.item_margin" DESC;

    Looks right.
    Could you raise the verbosity level and activate the debug timer of the ser, then share the log with us?
    Changing parameters is relatively simple; you have to to add
    verbose=true
    enable-debug-timer=true
    to the omnisci.conf file, then restart the instance

    the log file is into $MAPD_STOARGE/mapd_log/omnisci_server.INFO