16 Replies Latest reply: Sep 23, 2015 1:50 AM by Sasidhar Parupudi RSS

    Need help in loading ORACLE data into Qlik Sense

      I keep getting the below error while loading the data using ODBC connector from Oracle.

       

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      Started loading data

      XX_OE_ORDER_LINES_ALL_V << QueryResult Script error: QVX_UNEXPECTED_END_OF_DATA: ERROR [HYT00] [Qlik][ODBC Oracle Wire Protocol driver]Timeout expired. ERROR [HYT00] [Qlik][ODBC Oracle Wire Protocol driver]Timeout expired.

      The following error occurred:

      Custom read failed

      The error occurred here:

      [XX_OE_ORDER_LINES_ALL_V]: SELECT "LINE_ID", "ORG_ID", "HEADER_ID", "LINE_NUMBER", "ORDERED_ITEM", "REQUEST_DATE", "PROMISE_DATE", "SCHEDULE_SHIP_DATE", "ORDER_QUANTITY_UOM", "PRICING_QUANTITY", "PRICING_QUANTITY_UOM", "CANCELLED_QUANTITY", "SHIPPED_QUANTITY", "ORDERED_QUANTITY", "FULFILLED_QUANTITY", "SHIPPING_QUANTITY", "SHIPPING_QUANTITY_UOM", "DELIVERY_LEAD_TIME", "INVOICE_TO_ORG_ID", "DELIVER_TO_ORG_ID", "SHIP_TO_CONTACT_ID", "DELIVER_TO_CONTACT_ID", "INVOICE_TO_CONTACT_ID", "SOLD_FROM_ORG_ID", "SOLD_TO_ORG_ID", "SHIP_TOLERANCE_ABOVE", "SHIP_TOLERANCE_BELOW", "ORDERED_QUANTITY2", "ORDERED_QUANTITY_UOM2", "SHIPPING_QUANTITY2", "CANCELLED_QUANTITY2", "SHIPPED_QUANTITY2", "SHIPPING_QUANTITY_UOM2", "FULFILLED_QUANTITY2", "MFG_LEAD_TIME", "END_CUSTOMER_CONTACT_ID", "END_CUSTOMER_SITE_USE_ID" FROM "ONT"."XX_OE_ORDER_LINES_ALL_V"

      Data has not been loaded. Please correct the error and try loading again.

       

      --------------------------------------------------------------------------------------

      Please help me out on this and let me know if you need anything more to understand this issue.

       

      Thanks

      Yash

      PS: I am working on a POC to understand the Qlik's capabilities of downloading data from different Data Sources.