Exceeded configured maximum number of allowed output prompts, sections, rows-优快云博客

本文链接：https://blog.youkuaiyun.com/iteye_15315/article/details/82201490

本文介绍了解决 BIEE 在检索数据时出现的 'Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.' 错误的方法。通过修改 instanceconfig.xml 文件中的配置参数，可以增加数据展示的最大限制。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

BIEE检索数据时提示如下错误：
'Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.'

解决办法：
原文地址：[url]https://cn.forums.oracle.com/forums/thread.jspa?threadID=2263447[/url]

在D:\BIEE\instances\instance2\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.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>