Guest

Preview Tool

Cisco Bug: CSCus50870 - intermittent report failure causes missing results

Last Modified

Feb 03, 2015

Products (1)

  • Cisco MATE Live

Known Affected Releases

6.1

Description (partial)

Symptom:
intermittent report failure causes missing results

Conditions:
This is hard to reproduce - I've only seen it twice: Occasionally a "Cannot read system catalog (sysattrtypes)" SQL error occurs and some results go missing from the resulting report.  The report succeeds (which is a different bug,) but not all objects will be present.  See attachments for a larger stack.  In this case, the report which was run was:
http://ml3:8080/matelive/runReport?bg&outputXml&name="Ad+Hoc-LSPs-demo-2048"&objectType=lsps&custom.query="market+per+router"==".*"&reportType=adhoc&time.last=9.hour&adminstatus.changecount&sum.group=Tags

This was using the demo db, running build:Cisco MATE (TM) v6.1a0-2375-g6931bcf
It's unknown whether this is a regression.

01/14 18:51:16.821 HistoricalReportContentJob-13-thread-1 ERROR TSeries._getTimeSeries() - Why SQLException? SQL: SELECT thingid, projectedclip(series, GETNEXTVALID(series, ?::datetime year to fraction(5)).ts, ?::datetime year to fraction(5), 0, 'vc01')::timeseries(row(ts datetime year to fraction(5), vc01 varchar(255))) FROM LSPs WHERE  GETNEXTVALID(series, ?::datetime year to fraction(5)).ts IS NOT NULL AND thingid IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
java.sql.SQLException: Cannot read system catalog (sysattrtypes).
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.