
simbudj
New User
Apr 8, 2011, 10:20 AM
Post #1 of 1
(3961 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) ###################################
|