Hi,
In one of my jobs Source, lookup and target are Oracle Enterprise stages.
Job is getting filed for the lookup stages (Oracle Enterprise stage) because of below error.
I able to connect with same user_id and passwd from database tools.
Is there any do I need to cofigure for doing lookup.
Please let me know.
Thanks in Advance
Suri
##I TFCN 000001 13:26:44(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 13:26:44(001) <main_program> The open files limit is 1024; raising to 4096.
##I TOSH 000002 13:26:44(002) <main_program> orchgeneral: loaded
##I TOSH 000002 13:26:44(003) <main_program> orchsort: loaded
##I TOSH 000002 13:26:44(004) <main_program> orchstats: loaded
##I TFSC 000001 13:26:44(005) <main_program> APT configuration file: /detld2/etl/ascential/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 13:26:46(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TFOP 000000 13:26:49(000) <N_TIME_LKP> connect failed for env: o07bsl0, user: bwcm_ws_etl, password: *****
>
>Oracle error: -1017
>ORA-01017: invalid username/password; logon denied
>
>
>##E TFOP 000140 13:26:49(001) <N_TIME_LKP> APT_OraReadOperator: connect failed.
>##E TCOS 000029 13:26:49(002) <main_program> Creation of a step finished with status = FAILED.
oracle lookup failure
Moderators: chulett, rschirm, roy
Re: oracle lookup failure
Your error tells you all.suri wrote:>ORA-01017: invalid username/password; logon denied
Do you have special characters in your password?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Re: oracle lookup failure
I also got the same problem while viewing oracle stage data and got corrected after re typing the password. but now I am getting this error.suri wrote:Hi,
In one of my jobs Source, lookup and target are Oracle Enterprise stages.
Job is getting filed for the lookup stages (Oracle Enterprise stage) because of below error.
I able to connect with same user_id and passwd from database tools.
Is there any do I need to cofigure for doing lookup.
Please let me know.
Thanks in Advance
Suri
##I TFCN 000001 13:26:44(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 13:26:44(001) <main_program> The open files limit is 1024; raising to 4096.
##I TOSH 000002 13:26:44(002) <main_program> orchgeneral: loaded
##I TOSH 000002 13:26:44(003) <main_program> orchsort: loaded
##I TOSH 000002 13:26:44(004) <main_program> orchstats: loaded
##I TFSC 000001 13:26:44(005) <main_program> APT configuration file: /detld2/etl/ascential/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 13:26:46(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TFOP 000000 13:26:49(000) <N_TIME_LKP> connect failed for env: o07bsl0, user: bwcm_ws_etl, password: *****
>
>Oracle error: -1017
>ORA-01017: invalid username/password; logon denied
>
>
>##E TFOP 000140 13:26:49(001) <N_TIME_LKP> APT_OraReadOperator: connect failed.
>##E TCOS 000029 13:26:49(002) <main_program> Creation of a step finished with status = FAILED.
Error executing View Data command:
##E TDOR 000172 16:12:38(001) <Oracle_Enterprise_5> Access to sys.dba_extents is required but not available; please
question is Why do I need to have privilege to sys objects . My DBA is not interested to give it to me. Is this read on 'sys' objects essential ? Any different way I can look at the data?
-
- Participant
- Posts: 32
- Joined: Fri Dec 02, 2005 10:44 pm
- Location: Chicago,IL
Re: oracle lookup failure
You(User Id you are using) need to have atleast Read access (on the Database) to view the data from any data browser in DataStage.It holds the same for any other database tools.
Thanks,
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.