DSXchange

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.

check your oracle password, is there any special character is there in your password ? Put the password inside double quotes " ".

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