Change in datatype for password throwing errors
Posted: Thu Sep 20, 2007 12:54 am
Hi,
I have a job design
flat file --->xfm---->xfm---->oci
My job was working fine. Now that i have changed datatype of password from string to encrypted, its throwing errors and my job is getting aborted.
Unknown: DSCGetStrStageProp value (??) of property (PASSWORD) contains unmappable characters (MS1252)
Sequence_Master..SEQUENCE_MASTER: ORA-01017: invalid username/password; logon denied
I'm able to view the data in the sequential file and oci stage.
I'm using enviromental variables as job parameters.
when i validated the job it is saying source file not found in specified directory.
when i run the job its reading zero rows and aborting.
Could you please help me with some solution.
I have restarted datastage engine services also, which did not help me.
Thanks & Regards,
Suresh N
I have a job design
flat file --->xfm---->xfm---->oci
My job was working fine. Now that i have changed datatype of password from string to encrypted, its throwing errors and my job is getting aborted.
Unknown: DSCGetStrStageProp value (??) of property (PASSWORD) contains unmappable characters (MS1252)
Sequence_Master..SEQUENCE_MASTER: ORA-01017: invalid username/password; logon denied
I'm able to view the data in the sequential file and oci stage.
I'm using enviromental variables as job parameters.
when i validated the job it is saying source file not found in specified directory.
when i run the job its reading zero rows and aborting.
Could you please help me with some solution.
I have restarted datastage engine services also, which did not help me.
Thanks & Regards,
Suresh N