IBM Support

PI67963: IMPORTING ITEMTYPE DEFINITIONS TO CREATE ITEMTYPES IS GETTING UNEXPECTED ERROR WITH SQL ERROR -519.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When importing a itemtype into CM 8.5.0, customer is getting a
    -519 sql error that a cursor is already open when trying to open
    and use it.  This is happening as the library server is building
    the batch jobs that need to be run to do the import.  LS needs a
    close cursor statement to avoid the problem.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM(R) Content Manager for z/OS(R)  *
    *                 V8.5.0 library server who want to import     *
    *                 item type definitions to Library Server for  *
    *                 multiple item types.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: Library server gets SQL error -519 when *
    *                      it tries to open a cursor that is       *
    *                      already open.                           *
    ****************************************************************
    * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
    ****************************************************************
    A cursor is not closed correctly.
    

Problem conclusion

  • Library server code has been changed to close the cursor after
    each item type is created.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI67963

  • Reported component name

    CM390 LIB SER R

  • Reported component ID

    5697H6000

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-08-23

  • Closed date

    2016-11-28

  • Last modified date

    2017-01-03

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

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

Modules/Macros

  •    INTLPRTS
    

Fix information

  • Fixed component name

    CM390 LIB SER R

  • Fixed component ID

    5697H6000

Applicable component levels

  • R850 PSN UI42944

       UP16/12/12 P F612

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSLQWS","label":"Content Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 January 2017