Hi,
While using Surrogate Key Generator which in turn invoking oracle data base sequence in job aborting with error
APT_CombinedOperatorController,2: Caught exception from runLocally(): APT_ParseError: Expected "," or "}", got: ".", line 1.
APT_CombinedOperatorController,0: The runLocally() of the operator failed.
Job design
Source (Data Set file) ----> Surrogate Key Generator -> Oracle table..
Shall appreciate suggestions...
Incase need more info pls let me know.
thanks
Surrogate Key Generator
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
We do not even attempt diagnosis of errors thrown by APT_CombinedOperatorController.
Disable operator combination and reproduce the error, which will now be reported by the actual operator (stage) that generated it.
Disable operator combination and reproduce the error, which will now be reported by the actual operator (stage) that generated it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,
As per your suggestion, made stage's combinability to "Don't combine"
re-ran the job and captured the error as below,
SG_EXCEPTION_INSTANCE: Error occurred during initializeFromArgs().
main_program: Incorrect -dboptions option list; failed on Expected "," or "}", got: ".", line 1.
main_program: Creation of a step finished with status = FAILED.
As per your suggestion, made stage's combinability to "Don't combine"
re-ran the job and captured the error as below,
SG_EXCEPTION_INSTANCE: Error occurred during initializeFromArgs().
main_program: Incorrect -dboptions option list; failed on Expected "," or "}", got: ".", line 1.
main_program: Creation of a step finished with status = FAILED.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
So now you look at your database stage, in particular its dboptions property, and figure out what you've put in there to cause a syntax error - in particular there's a "." that was not expected to appear where it does appear, and where the expected character is "," or "}".
You may find it useful also to examine the generated OSH where the -dboptions property is highly evident.
You may find it useful also to examine the generated OSH where the -dboptions property is highly evident.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.