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;
same error message Table Not found
CONCATENATE(LinkTable_Temp)
LOAD *;
SQL
SELECT
can u move ur linktable_temp to the very beginning to see what tables are not created this time.
and add noconcatenate at the beginning of each table and show your table viewer?
I have moved these tables to top, still getting same error as soon as it hit Concatnate () statement.
i asked to move only one table not tables. Did that linked_temp create? can u show the table viewer?
people have been suspecting the problem of auto concatnate. did you add noconcatnate?
no luck. Same error message at NOCONCATENATE statement...
Finalley I found the issue, I should not give table name after Concatnate statement.
i mentioned that on my first reply.
but goo to hear.
Sorry man I have overlook your 1st responce. Thanks.