Exceeded configured maximum number of allowed output prompts

本文主要是介绍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>

 

 

 

 

这篇关于Exceeded configured maximum number of allowed output prompts的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---