Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

16 Replies
Not applicable
Author

Hi Sasidhar,

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

sasiparupudi1
Master III
Master III

hi

Your syntax seems to be incorrect..

STORE YourTable  INTO 'lib://Qlik Sense POC/oraclelines.qvd' (QVD);

hth

Sasi

Not applicable
Author

Here is the entire script:

LIB CONNECT TO 'Oracle_d510app';

LOAD SCHEDULE_SHIP_DATE,

ORDER_QUANTITY_UOM,

SHIPPED_QUANTITY,

ORDERED_QUANTITY,

SHIP_FROM_ORG_ID,

DELIVER_TO_ORG_ID,

SOLD_TO_ORG_ID,

UNIT_SELLING_PRICE,

ACTUAL_SHIPMENT_DATE,

SALESREP_ID;

:

SELECT "SCHEDULE_SHIP_DATE",

"ORDER_QUANTITY_UOM",

"SHIPPED_QUANTITY",

"ORDERED_QUANTITY",

"SHIP_FROM_ORG_ID",

"DELIVER_TO_ORG_ID",

"SOLD_TO_ORG_ID",

"UNIT_SELLING_PRICE",

"ACTUAL_SHIPMENT_DATE",

"SALESREP_ID"

FROM "ONT"."OE_ORDER_LINES_ALL";

STORE INTO 'lib://Qlik Sense POC/oraclelines.qvd' (QVD);

So basically I am downloading the data from oracle and saving directly in a QVD file. The data gets downloaded but does not complete because it says “TABLE NOT FOUND” I think I am missing something here, please help.

Regards,

Yashwanth Sharma

+917073111135

SreeniJD
Specialist
Specialist

Hi Yashwanth,

Correct your script in the last line as mentioned below..

...

..

.

...

Temp_Table:

SELECT "SCHEDULE_SHIP_DATE",

            "ORDER_QUANTITY_UOM",

            "SHIPPED_QUANTITY",

            "ORDERED_QUANTITY",

            "SHIP_FROM_ORG_ID",

            "DELIVER_TO_ORG_ID",

            "SOLD_TO_ORG_ID",

            "UNIT_SELLING_PRICE",

            "ACTUAL_SHIPMENT_DATE",

            "SALESREP_ID"

FROM "ONT"."OE_ORDER_LINES_ALL";

STORE Temp_Table INTO 'lib://Qlik Sense POC/oraclelines.qvd' (QVD);


DROP Temp_Table;

sasiparupudi1
Master III
Master III

Hi Yashwant,

As I mentioned earlier, you need to use table name to store into a file/qvd. You have to name your table and then store into a file

YourTable:

LOAD SCHEDULE_SHIP_DATE,

            ORDER_QUANTITY_UOM,

            SHIPPED_QUANTITY,

            ORDERED_QUANTITY,

            SHIP_FROM_ORG_ID,

            DELIVER_TO_ORG_ID,

            SOLD_TO_ORG_ID,

            UNIT_SELLING_PRICE,

            ACTUAL_SHIPMENT_DATE,

            SALESREP_ID;

:

SELECT "SCHEDULE_SHIP_DATE",

            "ORDER_QUANTITY_UOM",

            "SHIPPED_QUANTITY",

            "ORDERED_QUANTITY",

            "SHIP_FROM_ORG_ID",

            "DELIVER_TO_ORG_ID",

            "SOLD_TO_ORG_ID",

            "UNIT_SELLING_PRICE",

            "ACTUAL_SHIPMENT_DATE",

            "SALESREP_ID"

FROM "ONT"."OE_ORDER_LINES_ALL";

STORE YourTable INTO 'lib://Qlik Sense POC/oraclelines.qvd' (QVD);

//Since you have stored the table into a file, you may drop your in memory table..

drop YourTable;

hth

Sasi

Not applicable
Author

Iits resolved now, thanks a lot for your response.

Regards,

Yashwanth Sharma

+917073111135

sasiparupudi1
Master III
Master III

Hi Yashwant,

Great, may I ask you to please close this thread by marking a correct and any helpful answers so that it will be helpful for others?

thanks

Sasi