Guest

Preview Tool

Cisco Bug: CSCun60078 - specific user property "Paid Peers" fails when running report

Last Modified

Apr 04, 2014

Products (1)

  • Cisco MATE Live

Known Affected Releases

5.6

Description (partial)

Symptom:
specific user property "Paid Peers" fails when running report

Conditions:
In the following property list, filter AAA works great and the equivalent filter BBB fails.  The only difference is the order of expressions.   BBB is the same as the pre-existing Cox filter: "Paid Peers."  Works in 5.4.  Note that the expression "^(?!.*lo)" is not Posix compliant - but we have other user UDPs with this - and they work.  Plus, reversing the order works, so the odd regexp isn't the problem.  Probably.  Cox data.  Build: 5.6-46-gfb56ec4

AAA	Interfaces	regexp_extract('$1', description, ';paid peer ([^;]*);', name, '^(?!.*lo)')	 
BBB	Interfaces	regexp_extract('$1', name, '^(?!.*lo)', description, ';paid peer ([^;]*);')

https://ml13:8443/matelive/runReport?outputXml&name="Ad+Hoc-Interfaces-130"&bg&objectType=interfaces&group.bbb="Telia+Sonera+%28AS+1299%29"&reportType=adhoc&time.last=1.week&utilin.p95

03/07 20:15:06.442 JobServer-2-thread-1 ERROR DefaultMloRetriever.getMLObjects() - Caught exception. SQL: SELECT  Interfaces.Node AS Node,Interfaces.Name AS Name,int
erfaces_latest.vc03 AS Description,Interfaces.thingid AS thingid,interfaces_latest.i03 AS ParentThingId,interfaces_latest.i04 AS Type FROM Interfaces Interfaces JOIN
 interfaces_latest ON Interfaces.thingid = interfaces_latest.thingid WHERE 1=1  AND (Interfaces.Name != '' AND REGEXP_MATCH(LOWER(Interfaces.Name),'^(?!.*lo).*')) AN
D Interfaces.CreationTimestamp < '2011-08-19 08:15:00.000' and Interfaces.UpdateTimestamp > '2011-08-12 08:15:00.000' AND 1=1
java.sql.SQLException: ?+* follows nothing
        at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3157)
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.