Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
It is definetly not a qv problem..
may be there is a timeout setting in your connection file some where...
did you try a limited load on the view?
hth
Sasi
Are you reaching the DBMS?: "Timeout expired."
try a limited load ..or put a condition in your sql to see if it loads without any problems. If it loads the limited records then your dataset might be large and query is timing out may be.
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"
where rownum<1000
Hi Yashwanth,
Are you able to click on the 'Select Data' button to see the tables in your data source.
If this is ok can you post the part of the loadscript with the connect.
Thanks
Mark
guys, thanks for the suggestions. i tried few of your suggestions, seems like the problem still exists.
i am getting the below error.
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
this is a VIEW table (cuz the original table's size was huge) Does this affect the download?
i was able to download the original table.. it was taking loottt of time
Did you try SasiParupudi1 suggestion on the original table?
It sounds like a flaw in your Oracle view script that is causing a performance issue with the querying the view not how QLIK is working.
It is definetly not a qv problem..
may be there is a timeout setting in your connection file some where...
did you try a limited load on the view?
hth
Sasi
Hi Srini,
I was able to download data but now I am trying to convert the data or store as QVD files.
I am trying the below:
STORE INTO lib://Qlik Sense POC/oraclelines.qvd (QVD);
I keep getting error that this code is wrong. Doesn’t Qlik Sense allow to save the data download from a live source and then save it as a QVD file?
Please help and thanks for all the assistance prior to this.
Yash