Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i'm trying to link and concatenate different tables to create master calender for oracle data source and end up with "Table Not Found" error from LinkTable_Temp (show bellow).
LinkTable_Temp:
//LOAD
SQL
SELECT *,
DateTIme AS DATE,
'GATEWAYDATE' AS DateType
FROM
"SAEGW"."GTP_STATS"
WHERE
DATETIME >= SYSDATE - 7 AND SUBSTR(PDNGW,11,3) in ('P01', 'P02', 'P03');
PCRF_STATS: ---- TABLE NOT FOUND ERROR
Concatenate(LinkTable_Temp)
SQL
SELECT
*,
DATETIME AS DATE,
'PCRFSTATSDATE' AS DateType
FROM
"CRF"."ERTICAL_15M"
WHERE
DATETIME >= SYSDATE - 7 AND CATEGORY = 'PC'
GROUP BY
PCRF, DATETIME, "COMPONENT_NAME", "PROCESS_NAME"
;
DB_SESSION_COUNT: ---- TABLE NOT FOUND ERROR
Concatenate(LinkTable_Temp)
SQL
SELECT
*,
DATETIME AS DATE,
'DBDATE' AS DateType
FROM "CRF"."ALLSESSIONCOUNT_DY" A, "CRF"."STALESESSIONCOUNT_DY" B
WHERE TO_CHAR(B.DATETIMEZONE, 'MM/DD/YYYY HH24:MI') = TO_CHAR(A.DATETIMEZONE, 'MM/DD/YYYY HH24:MI')
AND A."EMS_NAME" IN ('10_36_66_136', '10_37_19_136', '10_37_166_136','107_246_96_136','155_174_220_136','10_40_16_136','107_246_112_136')
AND A.DATETIME >= SYSDATE - 7;
LinkTable:
LOAD
DATE,
DateType,
PDNGW &'-'& DATETIME AS "KEY_PDP_COUNT",
PCRF &'-'& DATETIME AS "KEY_PCRF_STATS",
"CRF"."ALLSESSIONCOUNT_DY"."EMS_NAME" &'-'& "CRF"."ALLSESSIONCOUNT_DY".DATETIME AS "KEY_DB_SESSION_COUNT"
RESIDENT LinkTable_Temp;
DROP Table LinkTable_Temp;
After reload, I did not find LinkTable_Temp in table view.
Hi
So only that error message appears.. So make sure that.
No error message. it has loaded 3 tables but not LinkTable_Temp at same time it did not rise the error too. The reload scrip has completed successfully.
PDP_COUNT: -- Loaded
PCRF_STATS: --- Loaded
DB_SESSION_COUNT: -- Loaded
LinkTable_Temp:
SQL
SELECT
PDNGW AS GATEWAY,
// TO_CHAR("DATETIME_INS", 'MM/DD/YYYY HH24:MI') AS DATETIME,
DATETIME AS "PDP_DATETIME",
// PDNGW||'-'||DATETIME AS "KEY_PDP_COUNT",
CAST(PERIOD AS INT) AS "AT_PERIOD",
ACTIVEGTPVERSION0PDPS AS ACTIVEGTPVERSION0PDPS,
ACTIVEGTPVERSION1PDPS AS ACTIVEGTPVERSION1PDPS,
ACTIVEGTPVERSION0PDPS + ACTIVEGTPVERSION1PDPS AS "PGW_3G_CONTEXTS",
ACTIVEBEARERS AS ACTIVEBEARERS,
CAST(ACTIVEGTPVERSION0PDPS+ACTIVEGTPVERSION1PDPS+ACTIVEBEARERS*(2.10526) AS DECIMAL (16,2)) AS "PGW_TOTAL_SESSIONS",
DATETIME AS DATE,
'GATEWAYDATE' AS DateType
FROM
"CISCO_SAEGW"."PDNGW_GTP_STATS"
WHERE
DATETIME >= SYSDATE - 2 AND SUBSTR(PDNGW,11,3) in ('P01', 'P02', 'P03');
CONCATENATE (LinkTable_Temp) -- Commented
LinkTable: -- Commented
Drop Table LinkTable_Temp; --- Commented
This means that it was auto-concatenated to a previously loaded table with the same set of fields.
Edit: also there is a chance thta something is wrong in the query for this table. I also had this problem in QV11 that when SQL is incorrect, no errors and nothing loaded, although ErrorMode=1. Try to run this qiuery outside of QlikView, in SQL+, or SQL Developer, for example.
I have test these sql's from sql developer and there are working fine. Do you have any other thgouths.
In this case, see my first assuption: "This means that it was auto-concatenated to a previously loaded table with the same set of fields."
did you say you connected to Oralce not SQL server?
Please don't confuse with sql. I'm working with Oracle only and use sql developer (oracle developer GUI tool) to run sql's.
I have commentout concatenate statement and ran it by providing diffrent table name and it has create table with data contains only non-common columns. But it was successfully completed and load data. I dont understand why it is throwing error if I turn on concatenate statement.
just to amuse me
add
load *;
betwen your table name and sql select and to reload to see what happens