CGI/Perl Guide | Learning Center | Forums | Advertise | Login Site Search: in Perl Guide PerlGuru Forums Learning Ctr

	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

Home: Need a Custom or Prewritten Perl Program?: I need a program that...: Log files parsing

simbudj New User Apr 8, 2011, 10:20 AM Post #1 of 1 (2428 views) Log files parsing Can't Post I need help with a quick perl job to parse weblogic logs and log4j log files. Here is some examples of the logs. The problem I am having is when an error shows up a java dump happens and add carriage returns and I need for those to concatenate to a single line. Log4j log (2011-04-08 08:09:19,189), server, node, bxbgi, ERROR, bgi.dp.impl.AuthorizationdpImpl, (Gle nsink201104080808414212), (Authorization Data insert/update failed) org.springframework.dp.DataIntegrityViolationException: CallableStatementCallback; SQL [{call PKG_SECUR ITY.ir_sec_user(?, ?, ?, ?, ?, ?, ?)}]; ORA-01400: cannot insert NULL into ("bgi"."IR_SEC_USER_ROLE"."RO LE_ID") ORA-01403: no data found ORA-06512: at "bgi.PKG_SECURITY", line 389 ORA-06512: at line 1 ; nested exception is java.sql.SQLException: ORA-01400: cannot insert NULL into ("bgi"."IR_SEC_USER_ROLE "."ROLE_ID") ORA-01403: no data found ORA-06512: at "bgi.PKG_SECURITY", line 389 ORA-06512: at line 1 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQL ExceptionTranslator.java:292) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:952) at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:985) at org.springframework.jdbc.object.StoredProcedure.execute(StoredProcedure.java:117) at org.cmp.bgi.dp.impl.AuthorizationdpImpl$SecurityProcedure.execute(AuthorizationdpImpl.jav a:125) at org.cmp.bgi.dp.impl.AuthorizationdpImpl.updateUserPlans(AuthorizationdpImpl.java:80) at org.cmp.bgi.service.impl.AuthorizationServiceImpl.updateUserPlans(AuthorizationServiceImpl.j ava:104) at org.cmp.bgi.business.delegate.bgiDelegateImpl.updateUserPlans(bgiDelegateImpl.java:216) at org.cmp.bgi.util.bgiUtil.LoginUserIntoObiee(bgiUtil.java:933) at org.cmp.bgi.web.actions.QuickReportsAction.execute(QuickReportsAction.java:104) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java :226) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42) at org.cmp.j2eeinfra.uiframework.webapp.UIInstitutionalFilter.doFilter(UIInstitutionalFilter.ja va:227) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42) at org.cmp.infra.security.SecurityFilter.processSSORequest(SecurityFilter.java:821) at org.cmp.infra.security.SecurityFilter.doFilter(SecurityFilter.java:241) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletConte xt.java:3393) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(Unknown Source) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200) at weblogic.work.ExecuteThread.run(ExecuteThread.java:172) Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("bgi"."IR_SEC_USER_ROLE"."ROLE_ID" ) ORA-01403: no data found ORA-06512: at "bgi.PKG_SECURITY", line 389 ORA-06512: at line 1 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:700) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:632) at oracle.jdbc.driver.T2CCallableStatement.execute_for_describe(T2CCallableStatement.java:847) at oracle.jdbc.driver.T2CCallableStatement.execute_for_rows(T2CCallableStatement.java:1010) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3076) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4273) at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:70) at org.springframework.jdbc.core.JdbcTemplate$5.doInCallableStatement(JdbcTemplate.java:987) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:936) ... 32 more (2011-04-08 08:09:19,366), server, node, bxbgi, REPORT, cmp.bgi.turf.TURFStatistics, (Glensin k201104080808414212), (The TURF transaction ended successfully) (2011-04-08 08:09:19,367), server, node, bxbgi, REPORT, bgi.dp.impl.LoginHistorydpImpl, (Gle nsink201104080808414212), (Storing customer number: 0138900) (2011-04-08 08:09:19,402), server, node, bxbgi, REPORT, bgi.dp.impl.LoginHistorydpImpl, (Gle nsink201104080808414212), (Result:{}) (2011-04-08 08:09:19,402), server, node, bxbgi, REPORT, bgi.dp.impl.LoginHistorydpImpl, (Gle nsink201104080808414212), (Procedure executed successfully ! ) (2011-04-08 08:09:19,404), server, node, bxbgi, REPORT, j2eeinfra.uiframework.util.SDMUtil, (G lensink201104080808414212), (getting selected campuses from SDM) (2011-04-08 08:09:19,490), server, node, bxbgi, REPORT, bgi.dp.impl.ConversionDatesdpImpl, ( Glensink201104080808414212), (PLAN_NUMBER_STRING=337175,337176,337177) (2011-04-08 08:09:19,490), server, node, bxbgi, REPORT, bgi.dp.impl.ConversionDatesdpImpl, ( Glensink201104080808414212), (Conversion Date = 2008-07-01) (2011-04-08 08:09:19,495), server, node, bxbgi, REPORT, bgi.dp.impl.ConversionDatesdpImpl, ( Glensink201104080808414212), (PLAN_NUMBER_STRING=337175,337176,337177) (2011-04-08 08:09:19,496), server, node, bxbgi, REPORT, bgi.dp.impl.ConversionDatesdpImpl, ( Glensink201104080808414212), (Legacy Display Date = 2008-07-12) (2011-04-08 08:09:19,557), server, node, bxbgi, REPORT, bgi.dp.impl.ConversionDatesdpImpl, ( Glensink201104080808414212), (PLAN_NUMBER_STRING=337175,337176,337177) (2011-04-08 08:09:19,557), server, node, bxbgi, REPORT, bgi.dp.impl.ConversionDatesdpImpl, ( Glensink201104080808414212), (Default Start Date = 2009-02-06) (2011-04-08 08:09:19,572), server, node, bxbgi, REPORT, bgi.dp.impl.CalendardpImpl, (Glensin k201104080808414212), (Data Load Date : 2011-04-06) (2011-04-08 08:09:19,582), server, node, bxbgi, REPORT, bgi.dp.impl.CalendardpImpl, (Glensin k201104080808414212), (Recent Month End Date : 2011-03-31) ###################################

Announcements     PerlGuru Announcements Perl Programming Help     Frequently Asked Questions     Beginner     Intermediate     Advanced     Regular Expressions     mod_perl     DBI     Win32 Programming Help Fun With Perl     Perl Quizzes - Learn Perl the Fun Way     Perl Golf     Perl Poetry Need a Custom or Prewritten Perl Program?     I need a program that...     I Need a Programmer for Freelance Work     Throw Down The Gauntlet General Discussions     General Questions     Feedback     Tutorial/Article Suggestions for The Learning Cent     Internet Security Other Programming Languages     Javascript     PHP

Search this forum this category all forums for All words Any words Whole Phrase (options)

Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives