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 个回答duzn的回答

duznduzn软件实施顾问free (Independent consultant)
正常导入就可以了,导入后的类型 clob对应longvharchar,blob是longvarbinary,在connector stage里Enable LOB reference可以选择大字段,array size设置为1即可
互联网服务 · 2015-09-08
浏览2150

回答者

duzn
软件实施顾问free (Independent consultant)
擅长领域: 大数据datastage商业智能

duzn 最近回答过的问题

回答状态

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