datastage VIEW data报错

##W TCOS 000049 08:55:17(006) Parameter specified but not used in flow: DSProjectMapName>##E TDOR 000172 08:55:17(008) Access to sys.dba_extents is required but not available; please>see your database administrator for select privileges.>##E TOPK 0...显示全部
##W TCOS 000049 08:55:17(006) Parameter specified but not used in flow: DSProjectMapName
>##E TDOR 000172 08:55:17(008) Access to sys.dba_extents is required but not available; please
>see your database administrator for select privileges.
>##E TOPK 000000 08:55:17(011) <_PEEK_IDENT_> Input dataset does not have field: "IDNO".
>##E TFSR 000019 08:55:17(013) Could not check all operators because of previous error(s)
##W TFOR 000000 08:55:17(014) When checking operator: The modify operator has a binding for the non-existent output field "IDNO".
##W TFOR 000000 08:55:17(015) When checking operator: The modify operator keeps field "IDNO" which is not present in the output interface.
>##E TCOS 000029 08:55:17(016) Creation of a step finished with status = FAILED.

请问有没有哪位同学遇到这样的问题?

先声明数据库连接是正常的,表与字段都是存在的

谁遇到过的给点建议啊,谢谢!收起
参与14

查看其它 4 个回答a530491093的回答

a530491093a530491093系统工程师mycle
我直接在datastage server的机器上用sqlplus完成是可以查询出数据的,类型长度一致。
所以我才纳闷,是否有可能是字符集的设置问题呢?
银行 · 2015-08-25
浏览2152

回答者

a530491093
系统工程师mycle
擅长领域: 大数据datastage

a530491093 最近回答过的问题

回答状态

  • 发布时间:2015-08-25
  • 关注会员:1 人
  • 回答浏览:2152
  • X社区推广