IBM Support

RS02639: TEAMSERVER : REMOTE API TO EXECUTE A QUERY GENERATES TOO MANY SQL QUERIES FOR DEPENDENT PROJECTS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Using Remote API to run large query may lead to too many SQL
    calls for dependent project. In some environment  (Postgres),
    so many queries lead to database halt.
    

Local fix

Problem summary

  • When using teamserver remote API to run large query may lead to
    too many SQL calls for dependent project. In some environment
    like Postgres it may lead to database halt. The main cause is
    that unless Teamserver Enterprise Console,  the remote API
    doesn't use cache.
    

Problem conclusion

  • The code is fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    RS02639

  • Reported component name

    WS DECISION CTR

  • Reported component ID

    5725B6900

  • Reported release

    880

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-02-09

  • Closed date

    2017-02-13

  • Last modified date

    2017-02-21

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

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

Modules/Macros

  • 999
    

Fix information

  • Fixed component name

    WS DECISION CTR

  • Fixed component ID

    5725B6900

Applicable component levels

  • R880 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"880","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
11 January 2022