Guest

Preview Tool

Cisco Bug: CSCvh77897 - CM query is hardcoding literal values and not using bind variables

Last Modified

Aug 22, 2018

Products (1)

  • Cisco Workload Automation

Known Affected Releases

6.2.1 6.2.1_SP3 6.2.1_SP4 6.3.0

Description (partial)

Symptom:
As  the query is hardcoding literal values and not using bind variables, different executions of query with different dates have different response times.
e.g. response time for 2 execs of  first query  is 487 seconds whereas for third query, response time is 85 seconds.
 
Using bind variables will save lot of parse calls at oracle optimizer layer and is recommended.

Conditions:
when executing queries against the TES Cache database
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.