IBM Support

PM49737: RW: 'OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver] Query timeout expired'

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When creating a trace to or trace from to an external project
    receives the following error every time.
    
    'An error has occurred: Error during traceability update:
    [Microsoft][ODBC SQL Server Driver]Timeout expired.'
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    USERS AFFECTED:
    Users of RequisiteWeb who create a traceability relationship
    between two requirements contained in two different projects
    stored in the same MS SQL Server database.
    
    PROBLEM DESCRIPTION :
    When the user is working with projects with a high number of
    requirements, the application gets an "Timeout expired"
    error because it is trying to read a value in a table which
    is still locked by another Database request in progress.
    

Problem conclusion

  • RequisiteWeb was modified for re-using a Database connection
    and get the data during the creation of the traceability
    relationship.
    The fix for this APAR was included in RequisitePro version
    7.1.1.9, 7.1.2.6 and 7.1.3.2
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM49737

  • Reported component name

    REQUISITEPRO WI

  • Reported component ID

    5724G3900

  • Reported release

    712

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-10-10

  • Closed date

    2012-04-05

  • Last modified date

    2012-04-05

  • 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

  • R712 PSN

       UP

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

Document Information

Modified date:
05 April 2012