IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Error log format not proper in wM8.2

  • 1.  Error log format not proper in wM8.2

    Posted Fri November 23, 2012 09:27 AM

    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


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Error log format not proper in wM8.2

    Posted Mon November 26, 2012 03:02 PM

    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


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 3.  RE: Error log format not proper in wM8.2

    Posted Tue November 27, 2012 07:04 AM

    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


    #Integration-Server-and-ESB
    #webMethods-General
    #webMethods