Change in datatype for password throwing errors

[suresh.narasimha]

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

[chulett]

What exact version of DataStage? I seem to recall earlier implementations didn't support encrypted environment variables.