Exceeded configured maximum number of allowed input records
自己查询啦一个,先备份,以备后面使用
下面是本机跑的时候出现的问题:
Exceeded configured maximum number of allowed input records.
错误详细资料
错误代码: EKMT3FK5:OI2DL65P
Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads
发出的 SQL: 145020~hji8lkh4hn45mdftt7bvm40m4i
解决办法:
原文地址:https://cn.forums.oracle.com/forums/thread.jspa?threadID=2263447
在D:\BIEE\instances\instance2\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml文件中添加如下代码:
Xml代码 收藏代码
<ServerInstance>
...........
<Views>
<Pivot>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DisableAutoPreview>false</DisableAutoPreview>
<!--++++++++add start++++++++++++++++++++++++++++++++++++-->
<MaxVisibleColumns>3000</MaxVisibleColumns>
<MaxVisibleRows>1500</MaxVisibleRows>
<MaxVisibleSections>50</MaxVisibleSections>
<MaxVisiblePages>1000</MaxVisiblePages>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Pivot>
<Cube>
<CubeMaxRecords>35000</CubeMaxRecords>
<CubeMaxPopulatedCells>65000</CubeMaxPopulatedCells>
</Cube>
<Charts>
<MaxVisibleColumns>2000</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>2000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<JavaHostReadLimitInKB>6144</JavaHostReadLimitInKB>
</Charts>
<!--++++++add end++++++++++++++++++++++++++++++++++++++-->
<Table>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<!--++++++++add start++++++++++++++++++++++++++++++++++++-->
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>1500</MaxVisibleRows>
<MaxVisibleSections>50</MaxVisibleSections>
<MaxCells>65000</MaxCells>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
<!--++++++add end++++++++++++++++++++++++++++++++++++++-->
</Table>
</Views>
...........
</ServerInstance>
自己查询啦一个,先备份,以备后面使用
下面是本机跑的时候出现的问题:
Exceeded configured maximum number of allowed input records.
错误详细资料
错误代码: EKMT3FK5:OI2DL65P
Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads
发出的 SQL: 145020~hji8lkh4hn45mdftt7bvm40m4i
解决办法:
原文地址:https://cn.forums.oracle.com/forums/thread.jspa?threadID=2263447
在D:\BIEE\instances\instance2\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml文件中添加如下代码:
Xml代码 收藏代码
<ServerInstance>
...........
<Views>
<Pivot>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DisableAutoPreview>false</DisableAutoPreview>
<!--++++++++add start++++++++++++++++++++++++++++++++++++-->
<MaxVisibleColumns>3000</MaxVisibleColumns>
<MaxVisibleRows>1500</MaxVisibleRows>
<MaxVisibleSections>50</MaxVisibleSections>
<MaxVisiblePages>1000</MaxVisiblePages>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Pivot>
<Cube>
<CubeMaxRecords>35000</CubeMaxRecords>
<CubeMaxPopulatedCells>65000</CubeMaxPopulatedCells>
</Cube>
<Charts>
<MaxVisibleColumns>2000</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>2000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<JavaHostReadLimitInKB>6144</JavaHostReadLimitInKB>
</Charts>
<!--++++++add end++++++++++++++++++++++++++++++++++++++-->
<Table>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<!--++++++++add start++++++++++++++++++++++++++++++++++++-->
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>1500</MaxVisibleRows>
<MaxVisibleSections>50</MaxVisibleSections>
<MaxCells>65000</MaxCells>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
<!--++++++add end++++++++++++++++++++++++++++++++++++++-->
</Table>
</Views>
...........
</ServerInstance>