Error log format not proper in wM8.2

, ,
1

I have configured in IS for error log to store in a local logs directory of webMethods82 directory, serverlog has standard format of logs where as errorlog file is not in proper format.

please let me know if there are any setting to be done to get errorlog in properformat similer to serverlogs.

Example, serverlog :
2012-10-05 14:29:14 IST [WmAuditingSC.destination.1122E] Destination ‘ErrorDBDest’ caught unexpected Throwable logging audit event: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
2012-10-05 14:29:14 IST [WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘Error Queue’ failed to log event to destination ‘ErrorDBDest’; reason '[sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
'; stack trace follows
2012-10-05 14:29:14 IST [WmAuditingSC.queue.2416I] In queue ‘Error Queue’ worker, the preceding error is non-recoverable; failing-over
2012-10-05 14:29:14 IST [WmAuditingSC.queue.2098E] The following record could not be written to the Failed Audit Log: WMERROR ef779370-0eca-11e2-86f3-e6de3c1b67e3 ef779370-0eca-11e2-86f3-e6de3c1b67e3 9f9ab307-a482-41bd-bb3b-12ec6e3d4e08 BDC6A-L-7G3J6Q1.GDNINDIA.COM:5555 2012-10-05T08:59:13.831Z 2012-10-05T08:59:14.353Z [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
java.sql.SQLSyntaxErrorException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
at com.wm.dd.jdbc.oraclebase.ddb9.b(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddb9.a(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddb8.b(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddb8.a(Unknown Source)
at com.wm.dd.jdbc.oracle.ddm.q(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddel.v(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddel.u(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddel.a(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddel.u(Unknown Source)
at com.wm.dd.jdbc.oraclebase.ddde.executeQuery(Unknown Source)
at com.wm.app.b2b.server.scheduler.ScheduleDB.checkTaskForConsistency(ScheduleDB.java:1131)
at com.wm.app.b2b.server.scheduler.ScheduleDB.init(ScheduleDB.java:949)
at com.wm.app.b2b.server.scheduler.ScheduleManager.init(ScheduleManager.java:40)
at wm.server.schedule.init(schedule.java:212)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:449)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:643)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:276)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:363)
at com.w…wm.server.schedule:init

errorlog :

WMERROR fd34a9a0-2fb1-11e2-a6c2-e803eba19fdb fd34a9a0-2fb1-11e2-a6c2-e803eba19fdb f5364e98-1c7e-4eee-984d-e43b2440affc BDC6A-L-7G3J6Q1.GDNINDIA.COM:5555 2012-11-16T05:53:47.834Z 2012-11-16T05:53:48.748Z com/sap/conn/jco/JCoTraceListener
Caused by: java.lang.ClassNotFoundException: com.sap.conn.jco.JCoTraceListener java.lang.ClassNotFoundException: com.sap.conn.jco.JCoTraceListener
at com.wm.app.b2b.server.ServerClassLoader.findClass(ServerClassLoader.java:464)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at com.wm.app.b2b.server.ServerClassLoader.loadClass(ServerClassLoader.java:783)
at com.wm.app.b2b.server.ServerClassLoader.loadClass(ServerClassLoader.java:731)
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631)
at java.lang.ClassLoader.defineClass(ClassLoader.java:615)
at java.lang.ClassLoader.defineClass(ClassLoader.java:465)
at com.wm.app.b2b.server.ServerClassLoader.classFromBytes(ServerClassLoader.java:597)
at com.wm.app.b2b.server.ServerClassLoader.findClassLocally(ServerClassLoader.java:514)
at com.wm.app.b2b.server.ServerClassLoader.findClass(ServerClassLoader.java:455)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at com.wm.app.b2b.server.ServerClassLoader.loadClass(ServerClassLoader.java:783)
at com.wm.app.b2b.server.ServerClassLoader.loadClass(ServerClassLoader.java:731)
at wm.sap.Admin.log(Admin.java:231)
at wm.sap.Admin.registerAdapter(Admin.java:269)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:439)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:643)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
at…wm.sap.Admin:registerAdapter
WMERROR fdc7e8f0-2fb1-11e2-a6c3-9aacbda5e633 fdc7e8f0-2fb1-11e2-a6c3-9aacbda5e633 42f70aa3-29eb-461b-a17d-cd1b253608b1 BDC6A-L-7G3J6Q1.GDNINDIA.COM:5555 2012-11-16T05:53:48.800Z 2012-11-16T05:53:49.778Z com/sap/conn/jco/JCo
Caused by: java.lang.ClassNotFoundException: com.sap.conn.jco.JCo java.lang.ClassNotFoundException: com.sap.conn.jco.JCo
at com.wm.app.b2b.server.ServerClassLoader.findClass(ServerClassLoader.java:464)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at com.wm.app.b2b.server.ServerClassLoader.loadClass(ServerClassLoader.java:783)
at com.wm.app.b2b.server.ServerClassLoader.loadClass(ServerClassLoader.java:731)
at wm.sap.Admin.registerAdapter(Admin.java:273)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:439)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:643)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:276)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:363)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:547)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:386)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:234)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:109)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:81)
at com.wm.app.b2b.server.SessionInvoke.run(Session.java:939)
at com.wm.util.pool…wm.sap.Admin:registerAdapter
WMERROR fe1bae40-2fb1-11e2-a6d7-c9917fb3d5e9 fe1bae40-2fb1-11e2-a6d7-c9917fb3d5e9 3b0b6013-202b-4e2d-8117-21b63e153c2e BDC6A-L-7G3J6Q1.GDNINDIA.COM:5555 2012-11-16T05:53:49.348Z 2012-11-16T05:53:49.781Z com/sap/conn/jco/JCoRecord
Caused by: java.lang.ClassNotFoundException: com.sap.conn.jco.JCoRecord java.lang.ClassNotFoundException: com.sap.conn.jco.JCoRecord
at com.wm.app.b2b.server.ServerClassLoader.findClass(ServerClassLoader.java:464)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at com.wm.app.b2b.server.ServerClassLoader.loadClass(ServerClassLoader.java:783)
at com.wm.app.b2b.server.ServerClassLoader.loadClass(ServerClassLoader.java:731)
at com.wm.adapter.sap.listener.RoutingListener.getInstance(RoutingListener.java:102)
at wm.sap.Admin.registerRoutingListener(Admin.java:460)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:439)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:643)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51)
at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:276)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:363)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:547)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:386)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:234)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:109)
at com.wm.app.b2b.server.ServiceManager.invoke(Servic…wm.sap.Admin:registerRoutingListener
WMERROR fe2dd6b0-2fb1-11e2-a6eb-e3ae075a8c77

2

You can try this in the extended setting and restart the IS and see how it goes:

watt.debug.layout=new

But why did you choose Error logging to File system rather than using database?..

I would say DB for error logging is preferred as opposed to overhead using file system based per the SAG guidelines:

HTH,
RMG

3

Thanks for your reply, I have developed a tool which analyzes the logs(serverlog/errorlog), tool works fine servlog, but to test the error log i wanted the errorlog file to be stored in file system.

Regards,
Sastry