DSXchange

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.

suri wrote:>ORA-01017: invalid username/password; logon denied

Your error tells you all.
Do you have special characters in your password?

I'm having "_" in the passwd.
passwd is : bwcm_ws_etl

Thanks and Regards
Suri

That should be ok. So its just enterprise stage connected to lookup thats creating a problem right. If you remove that stage, does the job work?

check the "spelling" in your user id and password and permissions for that particular database.

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.

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.
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?

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.

csrazdan wrote:
The other option for you is to use ODBC connect.

Hope it helps...

You are right. thank you for pointing out.