Guest

Preview Tool

Cisco Bug: CSCvu58745 - IOS-XR query failing for 7.0.2 and 7.0.12

Last Modified

Jun 15, 2020

Products (1)

  • Cisco Automation and Integration Platform

Known Affected Releases

12.7

Description (partial)

Symptom:
When a new query is added and users submit projects

Conditions:
failing at backend with below error 

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select distinct pqc.comp , decode( rm.version ) as group_ver
from iosra_iox_vw_rel_map rm,iosra_proj_qry_comp pqc where pqc.comp=rm.ddts_comp(+) and pqc.proj_id=? and nvl(pqc.manual_comps,'-')!= 'R' ]; nested except
ion is java.sql.SQLSyntaxErrorException: ORA-00938: not enough arguments for function
rm.version is not getting populated for few newer versions
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.