Exceeded configured maximum number of allowed output prompts

视图显示错误   Exceeded configured maximum number of allowed output prompts,

 

 

 

注意：记得提前把要添加的xml 做好备份再进行修改，否则，一旦出错会导致重新安装biee 酿成悲剧啊

 

BIEE检索数据时提示如下错误：

'Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.'

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

在D:\BIEE\instances\instance2\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml文件中添加如下代码：

 

 

 

 

 

View Code

<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>