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

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in 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 (2534 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)

###################################

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

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