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

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 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