{"id":6426,"date":"2017-07-31T12:27:13","date_gmt":"2017-07-31T17:27:13","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=6426"},"modified":"2017-07-31T12:27:13","modified_gmt":"2017-07-31T17:27:13","slug":"splunk-query-to-extract-jsp-from-stack-trace-in-error-log","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2017\/07\/31\/splunk-query-to-extract-jsp-from-stack-trace-in-error-log\/","title":{"rendered":"Splunk query to extract JSP from stack trace in error log"},"content":{"rendered":"<p>We used what is below to parse through stack traces that had been logged in JBOSS.  We were looking for the page most frequently impacted by a persistent transaction blocking issue.<\/p>\n<pre>\r\nhost=cmhlpecomecm* (ORA-00060 OR ORA-02049) AND org.apache.jsp \r\n  | rex field=_raw \"(?<page>(?m)org.apache.jsp.*?\\()\" \r\n  | stats count by page\r\n<\/pre>\n<p>This will show output with counts for the first line (from the top) in a given call stack.  This is the page that triggered the exception.<\/p>\n<pre>\r\norg.apache.jsp.check_002dout.basket_jsp._jspx_meth_dsp_005fdroplet_005f3(\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>We used what is below to parse through stack traces that had been logged in JBOSS. We were looking for the page most frequently impacted by a persistent transaction blocking issue. host=cmhlpecomecm* (ORA-00060 OR ORA-02049) AND org.apache.jsp | rex field=_raw&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2017\/07\/31\/splunk-query-to-extract-jsp-from-stack-trace-in-error-log\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[49,81],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/6426"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=6426"}],"version-history":[{"count":2,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/6426\/revisions"}],"predecessor-version":[{"id":6429,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/6426\/revisions\/6429"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=6426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=6426"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=6426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}