Surrogate_Key_Generator password problem

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
abyss
Premium Member
Premium Member
Posts: 172
Joined: Thu May 22, 2014 12:43 am

Surrogate_Key_Generator password problem

Post by abyss »

hi
i have a simple question
i got a problem to use surrogate key generator, it uses a sequence in my oracle data base, problem is when job runs it shows the following error message:
APT_CombinedOperatorController,1: Failure during execution of operator logic.
APT_CombinedOperatorController,1: Fatal Error: Not a string value: password=123456

looks like password is wrong, but the password is right and its encrypted, anyone know why?

Image

Image

thanks
abyss
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

A few guesses.... Is your password parameter defined as a string type or some sort of numeric type? Is your password value all numeric? Maybe that's confusing it?
Choose a job you love, and you will never have to work a day in your life. - Confucius
abyss
Premium Member
Premium Member
Posts: 172
Joined: Thu May 22, 2014 12:43 am

Post by abyss »

password is numeric, but password type is 'encrypted' type.
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

try quoting it.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
abyss
Premium Member
Premium Member
Posts: 172
Joined: Thu May 22, 2014 12:43 am

Post by abyss »

Priyadarshi
you mean quoting password? some how?
abyss
Premium Member
Premium Member
Posts: 172
Joined: Thu May 22, 2014 12:43 am

Post by abyss »

Priyadarshi, I tried again with your method, it works, i just put quote around password then it works fine. thanks mate
Post Reply