Oracle BAM数据量限制64000解决办法

最近用BAM在做报告是时候发现报告的数据量跟实际数据量有出入，而且差的不是一般的多，统计了下，BAM中数据量刚好64000，应该是BAM给限制了最大数据量，以关键字“Oracle BAM 64000”谷歌，官方文档对该问题的描述为：

The maximum number of rows to fetch from external data sources is controlled by Import_MaxSize property which is defaulted to -1 (negative one). The property gets a value of 64000 from ADCMaxViewsetRowCount when Import_MaxSize property is set to -1, so the net default is 64000.

If you need to increase the number of rows to be fetched, you can do so in the BAMServerConfig.xml file. Increasing this value beyond 64000 can have performance implications, so it should only be increased as much as necessary.

Normally, this increase may not be required. It may be required only in the cases where you must run a report that has an aggregate column on the external data object that has more than 64000 rows (for example, sum, count, average).

最为一款数据监控软件，竟然只支持64000的数据量，而且还不建议调，又一次被BAM给坑了，照着文档上的方法去搜配置文件 BAMServerConfig.xml，分别在两个目录下

修改两个BAMServerConfig.xml里面的Import_MaxSize 字段，重启服务器。

早就想到，Oracle的东西能一下子搞定是不正常的，各种重启服务器，重启物理机，修改配置文件，依然没有生效，谷歌上全是官方介绍的方法，去Support上搜了一下，发下下面这条SR

BAM 11g: Report Limited to 64K Records when DO is Created from External Datasource (Doc ID 1566121.1)

官方除了给出上面的方法外，在最后还附了一条NOTE

Note:

There is a know issue " Adding or changing configuration values to BAMServerConfig.xml has no effect on SOA 11.1.1.6 " . To fix this issue on SOA 11.1.1.6 please download and apply Patch 13942491> and then follow the above steps

机子上装的SOA版本刚好是11.1.1.6，无奈，打补丁去。

打补丁也遇到了一些问题，按照补丁包中的教程一步步做，还是出现如下问题：

The following patch(es) are already installed in the Oracle Home.
[13942491]
Please roll back the existing identical patch(es) first.

按照提示将环境变量ORACLE_HOME修改成SOA服务器目录

export ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_SOA1

重新运行opatch，补丁顺利打了上去，重启BAM服务器，配置已经生效。

最后再说一句。。。官方对该BUG的描述是，一个二逼程序员将加载BAMServerConfig.xml的方法给注释掉了。。。ORACLE你能再搞笑一点吗。

 

 补丁13942491下载http://pan.baidu.com/s/1cfNE9