Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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.

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: Need help in loading ORACLE data into Qlik Sense

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

16 Replies
johanlindell
Contributor II

Re: Need help in loading ORACLE data into Qlik Sense

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

sasiparupudi1
Honored Contributor III

Re: Need help in loading ORACLE data into Qlik Sense

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
Valued Contributor

Re: Need help in loading ORACLE data into Qlik Sense

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.


selectdata.png


Thanks


Mark


http://techstuffybooks.com

Not applicable

Re: Need help in loading ORACLE data into Qlik Sense

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
Honored Contributor III

Re: Need help in loading ORACLE data into Qlik Sense

try

Qlik ODBC Connector problem

may be set your timeout to 0

Not applicable

Re: Need help in loading ORACLE data into Qlik Sense

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

dfoster9
Valued Contributor

Re: Need help in loading ORACLE data into Qlik Sense

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
Honored Contributor III

Re: Need help in loading ORACLE data into Qlik Sense

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

Not applicable

Re: Need help in loading ORACLE data into Qlik Sense

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