 |
 |
Archives of the TeradataForum
Message Posted: Fri, 12 Sep 2008 @ 15:43:55 GMT
| Subj: | | Re: Cognos Error UDA-EE-0007: "integer" to "textblob" |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wed, 10 Sep 2008 14:45 -->
This particular error occurs in reportnet 1.1 when the master and detail is joined. The database its connecting is to Teradata version 12 where
when its connected to Teradata version 6 this report works.
Master detail join:
1. [QueryCommLinksMaster].[Page Type Code] = [QueryCommLinks].[Page Type Code] and
2.[QueryCommLinksMaster].[Report Identifier] = [QueryCommLinks].[Report Identifier]
1.Master Query:
select "T0"."C0" "Page_Type_Code" , 'testValue' "ParmPerdDate" ,
"T0"."C1" "Page_Type_Label" , "T0"."C2" "Report_Name" , "T0"."C3"
"Report_Identifier"
from (
select "RPR_Report_Dimension"."PAGE_TYPE_C" "C0" , (case when
"RPR_Report_Dimension"."PAGE_TYPE_C" = 'PAGE_SUMM' then 'Summary Page
Commentary' else 'Detail Pages Commentary' end ) "C1" ,
min("RPR_Report_Dimension"."RPRT_M") "C2" ,
min("RPR_Report_Dimension"."RPRT_I") "C3"
from (
select "Report_Report"."RPRT_I" "RPRT_I" , "Report_Page"."PAGE_I"
"PAGE_I" , min("Report_Report"."RPRT_M") "RPRT_M" ,
min("Report_Page"."PAGE_TYPE_C") "PAGE_TYPE_C"
from "PVMGTR"."RPRT_RPRT_RPR" "Report_Report", "PVMGTR"."RPRT_PAGE"
"Report_Page", "PVMGTR"."RPRT_RPRT_PAGE" "Report_Report_Page"
where "Report_Report_Page"."PAGE_I" = "Report_Page"."PAGE_I" and
"Report_Report"."RPRT_I" = "Report_Report_Page"."RPRT_I"
group by "Report_Report"."RPRT_I", "Report_Page"."PAGE_I"
having "Report_Report"."RPRT_I" = 0) "RPR_Report_Dimension"
group by "RPR_Report_Dimension"."PAGE_TYPE_C") "T0"
2.Detail Query:
select "T0"."C0" "Block_Identifier" , "T0"."C1" "Application_Identifier"
, "T0"."C2" "Report_Identifier" , "T0"."C3" "Page_Name" , "T0"."C4"
"Page_Identifier" , "T0"."C5" "Report_Name" , "T0"."C6" "Page_Type_Code"
, "T0"."C7" "Report_Page_Sequence" , "T0"."C8" "Block_Type_Group_Code" ,
"T0"."C9" "Block_Link_Status_Code" , "T0"."C10" "Block_Link_Type_Code" ,
"T0"."C11" "c12" , "T0"."C12" "Block_Application_Link_Name" ,
'testValue' "ParmPerdDate" , "T0"."C13" "ParmPerdType" , "T0"."C14"
"c16" , "T0"."C15" "Block_Name"
from (
select "RPR_Report_Dimension"."BLOK_I" "C0" ,
"RPR_Report_Dimension"."APPT_I" "C1" , "RPR_Report_Dimension"."RPRT_I"
"C2" , "RPR_Report_Dimension"."PAGE_M" "C3" ,
"RPR_Report_Dimension"."PAGE_I" "C4" , "RPR_Report_Dimension"."RPRT_M"
"C5" , "RPR_Report_Dimension"."PAGE_TYPE_C" "C6" ,
"RPR_Report_Dimension"."SORT_SEQN_N" "C7" ,
"RPR_Report_Dimension"."Calculation9" "C8" ,
"RPR_Report_Dimension"."LINK_STUS_C" "C9" ,
"RPR_Report_Dimension"."LINK_TYPE_C" "C10" ,
"RPR_Report_Dimension"."APPT_SRVR_LINK_M" "C11" ,
"RPR_Report_Dimension"."APPT_LINK_M" "C12" , (case when
"RPR_Report_Dimension"."RPRT_M" = 'Weekly Retail Product Report' then
'WKLY' else 'MNTH' end ) "C13" , "RPR_Report_Dimension"."BLOK_M" "C14" ,
min("RPR_Report_Dimension"."BLOK_M") "C15"
from (
select "Report_Report"."RPRT_I" "RPRT_I" , "Report_Page"."PAGE_I"
"PAGE_I" , "Report_Block"."BLOK_I" "BLOK_I" ,
min("Report_Report"."APPT_I") "APPT_I" , min("Report_Report"."RPRT_M")
"RPRT_M" , min("Report_Page"."PAGE_M") "PAGE_M" ,
min("Report_Page"."PAGE_TYPE_C") "PAGE_TYPE_C" ,
min("Report_Report_Page"."SORT_SEQN_N") "SORT_SEQN_N" ,
min("Report_Block"."BLOK_M") "BLOK_M" ,
min("Report_Block_Links"."LINK_STUS_C") "LINK_STUS_C" ,
min("Report_Block_Links"."LINK_TYPE_C") "LINK_TYPE_C" ,
min("Report_Block_Links"."APPT_SRVR_LINK_M") "APPT_SRVR_LINK_M" ,
min("Report_Block_Links"."APPT_LINK_M") "APPT_LINK_M" ,
min("Report_Block"."Calculation") "Calculation9"
from (((("PVMGTR"."RPRT_RPRT_RPR" "Report_Report" INNER JOIN
"PVMGTR"."RPRT_RPRT_PAGE" "Report_Report_Page" on
"Report_Report"."RPRT_I" = "Report_Report_Page"."RPRT_I") INNER JOIN
"PVMGTR"."RPRT_PAGE_BLOK" "Report_Page_Block" on
"Report_Report_Page"."PAGE_I" = "Report_Page_Block"."PAGE_I") INNER JOIN
( select "RPRT_BLOK_RPR"."BLOK_I" "BLOK_I" , "RPRT_BLOK_RPR"."BLOK_M"
"BLOK_M" , "RPRT_BLOK_RPR"."LINK_I" "LINK_I" , substring
("RPRT_BLOK_RPR"."BLOK_TYPE_C"
from 1 for 4) "Calculation"
from "PVMGTR"."RPRT_BLOK_RPR" "RPRT_BLOK_RPR") "Report_Block" on
"Report_Page_Block"."BLOK_I" = "Report_Block"."BLOK_I") INNER JOIN
"PVMGTR"."RPRT_PAGE" "Report_Page" on "Report_Report_Page"."PAGE_I" =
"Report_Page"."PAGE_I") LEFT OUTER JOIN ( select
"RPRT_LINK_DEFN_RPR"."LINK_I" "LINK_I" ,
"RPRT_LINK_DEFN_RPR"."LINK_STUS_C" "LINK_STUS_C" ,
"RPRT_LINK_DEFN_RPR"."LINK_TYPE_C" "LINK_TYPE_C" ,
"RPRT_LINK_DEFN_RPR"."APPT_SRVR_LINK_M" "APPT_SRVR_LINK_M" ,
"RPRT_LINK_DEFN_RPR"."APPT_LINK_M" "APPT_LINK_M"
from "PVMGTR"."RPRT_LINK_DEFN_RPR" "RPRT_LINK_DEFN_RPR"
where "RPRT_LINK_DEFN_RPR"."APPT_I" = 'RPR') "Report_Block_Links" on
"Report_Block"."LINK_I" = "Report_Block_Links"."LINK_I"
group by "Report_Report"."RPRT_I", "Report_Page"."PAGE_I",
"Report_Block"."BLOK_I"
having min("Report_Report"."APPT_I") = 'RPR' and
min("Report_Block"."Calculation") = 'CMMT' and
min("Report_Block_Links"."LINK_STUS_C") = 'ACTIVE' and
min("Report_Block_Links"."LINK_TYPE_C") = 'COMMENTARY')
"RPR_Report_Dimension"
group by "RPR_Report_Dimension"."BLOK_I",
"RPR_Report_Dimension"."APPT_I", "RPR_Report_Dimension"."RPRT_I",
"RPR_Report_Dimension"."PAGE_M", "RPR_Report_Dimension"."PAGE_I",
"RPR_Report_Dimension"."RPRT_M", "RPR_Report_Dimension"."PAGE_TYPE_C",
"RPR_Report_Dimension"."SORT_SEQN_N",
"RPR_Report_Dimension"."Calculation9",
"RPR_Report_Dimension"."LINK_STUS_C",
"RPR_Report_Dimension"."LINK_TYPE_C",
"RPR_Report_Dimension"."APPT_SRVR_LINK_M",
"RPR_Report_Dimension"."APPT_LINK_M", (case when
"RPR_Report_Dimension"."RPRT_M" = 'Weekly Retail Product Report' then
'WKLY' else 'MNTH' end ), "RPR_Report_Dimension"."BLOK_M") "T0"
order by 1 asc
| |
