Skip to Content
0
Apr 14, 2014 at 05:28 PM

IES10901 error for Teradata

36 Views

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

Attachments