Guest

Preview Tool

Cisco Bug: CSCvu64390 - CPO 3.5.1.98 - Patch 4 (3.5.1.125) : value with 'end' at Execute, will trunk the activity

Last Modified

Jul 16, 2020

Products (1)

  • Cisco Process Orchestrator

Known Affected Releases

3.5.1

Description (partial)

Symptom:
in the activity of Execute if we put a value that contains ‘end’ the query will trunk the activity
For example
SELECT DISTINCT user_id
FROM v_md_itsp_p_new_account
WHERE P_Deleted = 1 AND user_id IN ('MUM7WA2','END9WA1','KIB4BH')

That ‘end’ in the second value of in clause, would trunk query on the activity of execute.

How to avoid this unexpected truncation ?

Conditions:
in the activity of Execute if we put a value that contains ‘end’ the query will trunk the activity
For example
SELECT DISTINCT user_id
FROM v_md_itsp_p_new_account
WHERE P_Deleted = 1 AND user_id IN ('MUM7WA2','END9WA1','KIB4BH')

That ‘end’ in the second value of in clause, would trunk query on the activity of execute.

How to avoid this unexpected truncation ?
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.