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.
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
hi
Your syntax seems to be incorrect..
STORE YourTable INTO 'lib://Qlik Sense POC/oraclelines.qvd' (QVD);
hth
Sasi
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
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;
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
Iits resolved now, thanks a lot for your response.
Regards,
Yashwanth Sharma
+917073111135
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