DSXchange

I have a job that has run successfully on my dev and uat servers, but is failing in Production. The error seems to be in the Surrogate key stage -

SK_Employer,0: Caught exception from runLocally(): APT_ParseError: Expected "," or "}", got: "*", line 1.

The stage is designed to get a sequence from an Oracle 11g database sequence, and the inputdata to the stage is partioned using the Hash algorithim, and is sortedusing unique on two keys.

Any assistance greatly appreciated.

Is the database sequence present on your production database? And has your Oracle-user sufficient privileges to access it? Somehow it looks like something goes wrong when parsing the SQL-statement used to retrieve the next value from the sequence.

Hi Roland

Yes the sequence is present, and I have access to sequence to generate the next value...confirmed through Toad

I've worked around this problem for now by removing the Surrogate key stage and using the .NEXTVAL function to build the key...but i will chase this issue with IBM for a resolution.

The issue is that certain stages have issues with password containing '*'. The resolution is to ensure all password fields wrap the password in double-quotes to ensure the full password is passed back to the database system.

Traps for young players...

So there was an authentication problem after all... A bit difficult to track down, though. Thanks for sharing.