In oracle enterprise stage when I click on view data iam getting this error
Error executing View Data command
##E TDOR 000172 15:15:30(002) <Oracle_Enterprise_0> Access to sys.dba_extents is required but not available; please
##I TFCN 000001 15:15:29(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.2
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 15:15:29(001) <main_program> The open files limit is 100; raising to 65536.
##I TOSH 000002 15:15:29(002) <main_program> orchgeneral: loaded
##I TOSH 000002 15:15:29(003) <main_program> orchsort: loaded
##I TOSH 000002 15:15:29(004) <main_program> orchstats: loaded
##I TFSC 000001 15:15:29(005) <main_program> APT configuration file: /data1/Ascential/DataStage/Configurations/Multinode.apt
##W TFPA 000017 15:15:29(006) <main_program> Warning: the value of the PWD environment variable (/export/home/dsadmin) does not appear to be a synonym for the current working directory (/data1/Ascential/DataStage/Projects/test). The current working directory will be used, but if your ORCHESTRATE job does not start up correctly, you should set your PWD environment variable to a value that will work on all nodes of your system.
##W TCOS 000049 15:15:30(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TDOR 000172 15:15:30(002) <Oracle_Enterprise_0> Access to sys.dba_extents is required but not available; please
>see your database administrator for select privileges.
>##E TOPK 000000 15:15:30(005) <_PEEK_IDENT_> Input dataset does not have field: "A".
>##E TOPK 000000 15:15:30(006) <_PEEK_IDENT_> Input dataset does not have field: "B".
>##E TFSR 000019 15:15:30(008) <main_program> Could not check all operators because of previous error(s)
##W TFOR 000000 15:15:30(009) <Oracle_Enterprise_0> When checking operator: The modify operator has a binding for the non-existent output field "A".
##W TFOR 000000 15:15:30(010) <Oracle_Enterprise_0> When checking operator: The modify operator has a binding for the non-existent output field "B".
##W TFOR 000000 15:15:30(011) <Oracle_Enterprise_0> When checking operator: The modify operator keeps field "A" which is not present in the output interface.
##W TFOR 000000 15:15:30(012) <Oracle_Enterprise_0> When checking operator: The modify operator keeps field "B" which is not present in the output interface.
>##E TCOS 000029 15:15:30(013) <main_program> Creation of a step finished with status = FAILED.
>
Oracle Enterprise stage
Moderators: chulett, rschirm, roy
Code: Select all
"Access to sys.dba_extents is required but not available; please see your database administrator for select privileges"
"given enough eyeballs, all bugs are shallow" - Eric S. Raymond
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia