Need help in loading ORACLE data into Qlik Sense

[#1]

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.

[johanlindell]

Are you reaching the DBMS?: "Timeout expired."

[sasiparupudi1]

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

[markodonovan]

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

http://techstuffybooks.com

[#5]

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

[sasiparupudi1]

try

Qlik ODBC Connector problem

may be set your timeout to 0

[#7]

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

[DavidFoster1]

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.

[sasiparupudi1 · Accepted solution]

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

[#10]

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