Hello Guys,
I am working on a universe in IDT and seeing IES10901 error on webi side. I researched but could not find much about someone having this error on teradata. Hence posting this in here . Here is my SQL which I am using to create a Derived Table in IDT.
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.TAG_NM,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.PLANT_CD,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.START_DT,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.PLANT_NM,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.PLANT_AREA_CD,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.ENGR_UOM_CD,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.TAGLO,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.TAGHI,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.EFFECTIVE_DT,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.SERVER_NM,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.CTAG_NM,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.CTAGLO,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.CTAGHI,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.TAGAVG,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.TAGGOOD,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.CHNG_USER_NM,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.CHNG_TYPE,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.COMMENT_FLG,
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW.TAG_TYP,
EXTRACT (HOUR FROM (CAST(START_DT AS TIMESTAMP(0)))) Hour_Value
FROM
DLGSC_MIRS.PERMIT_HISTORY_LEVEL_1_VW
In IDT, when I validated it was fine.
I have attached the error screen shot for reference.
Any suggestions??
Regards