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


Description (partial)

specific user property "Paid Peers" fails when running report

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 ([^;]*);')


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(
Bug details contain sensitive information and therefore require a 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.