how Link & Concatenate tables using oracle data source

[#1]

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;

[#2]

After reload, I did not find LinkTable_Temp in table view.

[MayilVahanan]

Hi

     So only that error message appears.. So make sure that.

[#4]

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

[Anonymous]

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.

[#6]

I have test these sql's from sql developer and there are working fine. Do you have any other thgouths.

[Anonymous]

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."

[alexpanjhc]

did you say you connected to Oralce not SQL server?

[#9]

Please don't confuse with sql. I'm working with Oracle only and use sql developer (oracle developer GUI tool) to run sql's.

[#10]

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.

[alexpanjhc]

just to amuse me

add

load *;

betwen your table name and sql select and  to reload to see what happens