IBM Support

JR30015: RETRIEVE: SYNTAX ERROR. UNEXPECTED SYMBOL. TOKEN WAS "@ID".

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Auto-purge of job log set to "Up to previous 3 job runs", at the
    project level. When I run a DataStage job and there are not 3
    existing sets of log files (ie there is nothing yet to
    auto-purge" I get the following log entry
    in the job log, immediately following the "Finished Job" log
    entry.
    
    Message:: From previous run
    DataStage Job 1417 Phantom 10340
    [8128] Done    : DSD.StageRun DWOASTGLoadWKASG.
    DWOASTGLoadWKASG.Transform1 1 0/0/2
    DataStage Phantom Finished.
    Retrieve: syntax error.  Unexpected symbol.  Token was "@ID".
    Scanned command was SELECT RT_LOG1417 WITH @ID < AND @ID
    

Local fix

  • This fix is included in 8.0.1 fix pack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All platforms: Log purging and running multi-instance jobs.
    ****************************************************************
    PROBLEM DESCRIPTION:
    A status=99 is returned:
    1. If a sequence job or dsjob is reporting a status=99 when
    running multi-instance jobs with auto-purging enabled.
    2. If more than 25 instances are run simultaneuosly, a
    status=99 may returned.
    3. If a sequence/dsjob starts many multi-instance jobs and one
    or more instances are set to reset, the may be a timing windows
    when a status=99 is returned for the resetting instance.
    An error code=-99 is returned :
    4. If insufficient system resources are available to start a PX
    job or if the PX job process failed to notify that it has
    finished.
    ****************************************************************
    RECOMMENDATION:
    Apply patch for APAR JR30015.
    Changes up to and including JR30015v6 are included in 8.1 Fix
    Pack 1.
    ****************************************************************
    

Problem conclusion

  • Fixed sequence/dsjob to get notification that a child job has
    started before polling for their status. Updated auto-purge
    logic for cleaning of status information. Added extra check for
    PX job completion.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR30015

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-07-25

  • Closed date

    2008-08-15

  • Last modified date

    2013-07-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • CLIENT
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R801 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021