OSW Analyzer分析oswbb日志发生异常

具体OSW Analyzer详细介绍可以参考MOS文档:

  • OSWatcher Analyzer User Guide (Doc ID 461053.1)

我们常用的就是拿到一份osw数据到自己电脑,使用下面的方法进行分析:

Usage java -jar oswbba.jar -i <input archive directory containing the oswatcher log files>

我电脑系统是macOS,目前想参照这样的方法使用OSW Analyzer对一份从客户AIX环境生成的osw数据进行分析,执行如下命令:

java -jar oswbba.jar -i /Users/jingyuzhao/Documents/oswbb/archive/

结果屏幕大量输出异常,类似这样:

...省略大量输出...
Parsing file xxdb1_iostat_20.06.02.1400.dat ...
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 0
...省略大量输出...
An exception occured in processTopData on line 450
Timestamp Error. Expected format: May 3 16:11:12 2006.
Timestamp Error. Found format: Jun 2 10:36:49 2020
An exception occured in insertVmstatLists on line 461
An exception occured in processTopData on line 463
An exception occured in processTopData on line 464
An exception occured in processTopData on line 465
An exception occured in processTopData on line 466
An exception occured in processTopData on line 467
An exception occured in processTopData on line 468
An exception occured in processTopData on line 469
An exception occured in processTopData on line 470
An exception occured in processTopData on line 471
An exception occured in processTopData on line 472
Timestamp Error. Expected format: May 3 16:11:12 2006.
Timestamp Error. Found format: Jun 2 10:37:19 2020
An exception occured in insertVmstatLists on line 483
An exception occured in processTopData on line 485
An exception occured in processTopData on line 486
...省略大量输出...

最开始走了弯路,以为是osw版本不一致导致,但换用相同版本的osw依然如此。
之后重新从这些大量的异常输出中看到还有时间格式的问题,开始尝试依据这个关键点先尝试解决时间格式问题,MOS有一篇在Win平台的格式问题:

  • OSWatcher Analyzer Failed with “Cannot format given Object as a Date” and “Invalid data found” on Windows Platform (Doc ID 2247572.1)

核心内容就是说系统的日期格式设置是非英文的:date format is set to non-English
参考解决方案:

You can modify the java command to below to resolve this issue:
java -Duser.language=en -Duser.country=us -jar oswbba.jar -i

虽然我不是Win平台,但看起来应该是类似问题,所以重新尝试用这种方式重新解析osw日志:

java -Duser.language=en -Duser.country=us -jar oswbba.jar -i /Users/jingyuzhao/Documents/oswbb/archive/

这次执行发现不再报任何错误,最终能够成功解析出OSW的采集数据。

This entry was posted in Oracle故障处理 and tagged . Bookmark the permalink.