OBIEE 11G: June 2014

1) General Errors

Above error occurs when Temp space is less.Same report will work without any errors if you apply any filters.So make sure to delete temp file data and try to increase the temp file size to overcome above issue.

2) Errors like View Display Error

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

Error Details

Error Codes: IRVLJWTA:OI2DL65P

Location: saw.views.dashboard, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

SQL Issued: 4308~80c8q8r5gug71seva984g62ahu

For above error pls make sure to check your instance config file have below changes or not.If not please make it and restart all services.Report will disply without any error.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<WebConfig xmlns="oracle.bi.presentation.services/config/v1.1">
   <ServerInstance>
      <CatalogPath>C:\OBIEEHOME\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\cpxbi</CatalogPath>
      <DSN>coreapplication_OH270360339</DSN>
      <Logging>
         <Writers>
            <Writer implementation="FileLogWriter" name="Global File Logger" writerClassId="1" dir="{%ORACLE_BIPS_INSTANCE_LOGDIR%}" filePrefix="sawlog" maxFileSizeKb="10240" filesN="10" fmtName="ODL-Text"/>
            <Writer implementation="CoutWriter" name="Console Logger" writerClassId="2" maxFileSizeKb="10240"/>
            <Writer implementation="EventLogWriter" name="System Event Logger" writerClassId="3" maxFileSizeKb="10240"/>
            
            <Writer implementation="FileLogWriter" name="Webcat Upgrade Logger" disableCentralControl="true" writerClassId="5" dir="{%ORACLE_BIPS_INSTANCE_LOGDIR%}" filePrefix="webcatupgrade" maxFileSizeKb="2147483647" filesN="1" fmtName="ODL-Text"/>
         </Writers>
         <WriterClassGroups>
            <WriterClassGroup name="All">1,2,3,5,6</WriterClassGroup>
            <WriterClassGroup name="File">1</WriterClassGroup>
            <WriterClassGroup name="Console">2</WriterClassGroup>
            <WriterClassGroup name="EventLog">3</WriterClassGroup>
            <WriterClassGroup name="UpgradeLogFile">5</WriterClassGroup>
         </WriterClassGroups>
         <Filters>
            
            <FilterRecord writerClassGroup="File" path="saw" information="1" warning="31" error="31" trace="0" incident_error="1"/>
            <FilterRecord writerClassGroup="File" path="saw.mktgsqlsubsystem.joblog" information="1" warning="31" error="31" trace="0" incident_error="1"/>

            
            <FilterRecord writerClassGroup="UpgradeLogFile" disableCentralControl="true" path="saw.subsystem.catalog.initialize.upgrade" information="1" warning="32" error="32" trace="1" incident_error="32"/>
            <FilterRecord writerClassGroup="UpgradeLogFile" disableCentralControl="true" path="saw.subsystem.catalog.upgrade" information="1" warning="32" error="32" trace="1" incident_error="32"/>
         </Filters>
      </Logging>
      
      <Views>
      <Pivot>

<DefaultRowsDisplayedInDelivery>9999</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>9999</DefaultRowsDisplayedInDownload>

<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>3000</MaxVisibleColumns>
<MaxVisiblePages>10000</MaxVisiblePages>
<MaxVisibleRows>1000</MaxVisibleRows>
<MaxCells>40000</MaxCells>
<MaxVisibleSections>25000</MaxVisibleSections>
</Pivot>
<Cube>
<CubeMaxRecords>10000000</CubeMaxRecords>
<CubeMaxPopulatedCells>40000000</CubeMaxPopulatedCells>
</Cube>
<Table>

<DefaultRowsDisplayedInDelivery>9999</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>9999</DefaultRowsDisplayedInDownload>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>5000</MaxVisibleRows>
<MaxCells>40000</MaxCells>
<MaxVisibleSections>25000</MaxVisibleSections>
</Table>
</Views>
<Charts>
<SectionSliderDefault>5</SectionSliderDefault>
<SectionSliderLimit>100</SectionSliderLimit>
</Charts>
   <Catalog>
         <UpgradeAndExit>false</UpgradeAndExit>
      </Catalog>
      <Listener port="9710" ssl="false"/>
      <JavaHostProxy ssl="false">
         <Hosts>
            <Host name="coreapplication_obijh1" address="praveen.com" port="9810"/>
         </Hosts>
      </JavaHostProxy>
      <Alerts>
         <ScheduleServer ssl="false" ccsPrimary="XXXXXX.com" ccsPrimaryPort="9706"/>
         <OfflinePresentationServicesURL>http://IPADDRESS:7001/analytics/saw.dll</OfflinePresentationServicesURL>
      </Alerts>
      <ActionFramework>
         <ActionExecutionServiceEndPoint>http://IPADDRESS:7001/analytics/actions/ActionExecutionService</ActionExecutionServiceEndPoint>
         <TargetBrowsingServiceEndPoint>http://IPADDRESS:7001/analytics/actions/ActionRegistryService</TargetBrowsingServiceEndPoint>
         <LocationServiceEndPoint>http://IPADDRESS:7001/analytics/actions/LocationService</LocationServiceEndPoint>
         <WorkflowServer>http://IPADDRESS:7001</WorkflowServer>
         <WorkflowService>ANALYTICS</WorkflowService>
         <WorkflowSystem>obiaftests</WorkflowSystem>
      </ActionFramework>
   <Security>

<ClientSessionExpireMinutes>210</ClientSessionExpireMinutes>
</Security>
<ODBC>

<ResultRowLimit>9999999</ResultRowLimit>
</ODBC>

<OracleHardwareAcceleration>false</OracleHardwareAcceleration>
<Dashboard>

<ShowPageTabsAlways>false</ShowPageTabsAlways>

<ShowSectionHeadingsDefault>false</ShowSectionHeadingsDefault>

<CollapsibleSectionsDefault>true</CollapsibleSectionsDefault>
</Dashboard>
<BIComposer>

<Enabled>true</Enabled>
</BIComposer>
<DeploymentProfile>

<DeploymentMode>onsite</DeploymentMode>
</DeploymentProfile>
<AsyncLogon>

<NewLogonWaitSeconds>30</NewLogonWaitSeconds>

<NewSyncLogonWaitSeconds>900</NewSyncLogonWaitSeconds>
</AsyncLogon>
<Marketing>
<ContentServer>

<URL>http://localhost:8765</URL>
</ContentServer>
</Marketing>
<Authentication>

<EnabledSchemas>UidPwd,Impersonate,UidPwd-soap,Impersonate-soap</EnabledSchemas>
</Authentication>
</ServerInstance>
</WebConfig>

OBIEE 11G

Tuesday, June 3, 2014

General Errors

Blog Archive

About Me

photos