IBM Support

PK83382: Unable to move Externally traced projects via Data Transport Wiz ard

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Error:
    
    IBM][CLI Driver][DB2/NT] SQL0803N  One or more values in
    the INSERT statement, UPDATE statement, or foreign key update ca
    used by
    a DELETE statement are not valid because the primary key, unique
    
    constraint or unique index identified by '1' constrains table
    
    'DB2ADMIN.RQEXTERNALPROJECTS' from having duplicate values for t
    he index
    key.  SQLSTATE=23505
    
    when moving a set of projects with Data Transport Wizard aplicat
    ion.
    

Local fix

Problem summary

  • Error:
    
    IBM][CLI Driver][DB2/NT] SQL0803N  One or more values in
    the INSERT statement, UPDATE statement, or foreign key
    update caused by
    a DELETE statement are not valid because the primary key,
    unique
    constraint or unique index identified by "1" constrains
    table
    "DB2ADMIN.RQEXTERNALPROJECTS" from having duplicate values
    for the index
    key.  SQLSTATE=23505
    
    when moving a set of projects with Data Transport Wizard
    aplication.
    

Problem conclusion

  • Fixed
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK83382

  • Reported component name

    REQUISITEPRO WI

  • Reported component ID

    5724G3900

  • Reported release

    701

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-25

  • Closed date

    2009-05-20

  • Last modified date

    2009-05-20

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

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

Fix information

  • Fixed component name

    REQUISITEPRO WI

  • Fixed component ID

    5724G3900

Applicable component levels

  • R701 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
24 October 2021