Re: Error :please solve the issue - Qlik Community

Hassanjaved01 · ‎2019-01-21

Connected

MSEG << QueryResult

Lines fetched: 25,608 MAKT <<

The following error occurred:

QVX_UNEXPECTED_END_OF_DATA: ERROR [HY000] ORA-00942: table or view does not exist

The error occurred here:

[MAKT]: SELECT "MANDT", "MATNR", "SPRAS", "MAKTX", "MAKTG" FROM "SAPSR3"."MAKT" INNER JOIN MSEG ON MAKT.MATNR = MSEG.MATNR

Data has not been loaded. Please correct the error and try loading again.

code

[MAKT]:
SELECT "MANDT",
"MATNR",
"SPRAS",
"MAKTX",
"MAKTG"
FROM "SAPSR3"."MAKT" INNER JOIN MSEG ON MAKT.MATNR = MSEG.MATNR;

avinashelite · ‎2019-01-21

Their might me 2 reasons for this

1. You don't have enough privileges to the table or view which your trying to access

2. Table/View might not exist in the data base

check DB or with Database admin once

Hassanjaved01 · ‎2019-01-21

with out join condition data lode from the db .when i use the join condition then face error .

Hassanjaved01 · ‎2019-01-21

Please see the code

[MSEG]:

SELECT
"MANDT",
"MBLNR",
"MATNR",

"ZRET_QTY"
FROM "SAPSR3"."MSEG"
where "BWART" = 131 or "BWART"= 132 ;

[MAKT]:
SELECT "MANDT",
"MATNR",
"SPRAS",
"MAKTX",
"MAKTG"
FROM "SAPSR3"."MAKT" INNER JOIN MSEG ON MAKT.MATNR = MSEG.MATNR;

Store MSEG INTO [Lib://Hassan/MSEG.QVD](qvd);
Store MAKT INTO [Lib://Hassan/MAKT.QVD](qvd);

avinashelite · ‎2019-01-21

Try like this

[MAKT]:
SQL SELECT "MANDT",
"MATNR",
"SPRAS",
"MAKTX",
"MAKTG"
FROM "SAPSR3"."MAKT" MAKT INNER JOIN "SAPSR3"."MSEG" MSEG ON MAKT.MATNR = MSEG.MATNR;

timpoismans · ‎2019-01-21

I don't know if Qlik can do an inner join like that. I'd try the following:

 [MAKT]:
SELECT "MANDT",
"MATNR",
"SPRAS",
"MAKTX",
"MAKTG"
FROM "SAPSR3"."MAKT";

Inner Join([MAKT]):
//MSEG
SELECT
"MATNR",
"MANDT",
"MBLNR",
"ZRET_QTY"
FROM "SAPSR3"."MSEG"
where "BWART" = 131 or "BWART"= 132 ;

Hassanjaved01 · ‎2019-01-21