Surrogatekey generator 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
deepa.y
Participant
Posts: 56
Joined: Mon Nov 28, 2011 10:47 pm
Location: Bangalore

Surrogatekey generator problem

Post by deepa.y »

Hi,
When i am trying to use surrogate key generator to generate the PK by calling oracle sequence,it is giving the following error.
APT_CombinedOperatorController(4),1: Caught exception from runLocally(): APT_ParseError: Expected "," or "}", got: "abcd", line 1.
here "abcd" is part of the password .
Database type:Oracle
Oracle_server_name:Name of the server
Password:Password for the connection.
User Name:User name for the connection.

Generated output column name:PK.
Source name:databasename.TEST
Source Type:Database sequence.
I tried to read the output of surrogatekey generator into flat file.even then job is getting aborted.
rohitagarwal15
Participant
Posts: 102
Joined: Thu Sep 17, 2009 1:23 am

Re: Surrogatekey generator problem

Post by rohitagarwal15 »

check your oracle password, is there any special character is there in your password ? Put the password inside double quotes " ".
Rohit
deepa.y
Participant
Posts: 56
Joined: Mon Nov 28, 2011 10:47 pm
Location: Bangalore

Post by deepa.y »

Thanks a lot Rohit.I enclosed password in double quotes.it worked.
Post Reply