Problem when trying to export large PDF/XLSX file from OBIEE 12

If you try to export large report in PDF / XLSX format you will get error codes: "AGEGTYVF".

Reason is thread limit that is being encountered when streaming data from the presentation server to the javahost. To implement the solution, execute the following step:

• Open with text editor "config.xml" file from location:
  $OMWHOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH
• Set value "InputStreamLimitInKB" to "0" (zero, without the quotes).
  
  <XMLP><InputStreamLimitInKB>0</InputStreamLimitInKB>     <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing></XMLP>
• Save changes and restart all BI services (including weblogic components)

0 means that this limit is deactivated. If this solves the issue and you would like to limit the maximum input size (in kilobytes) for requests that are sent to the JavaHost service, then gradually increase the parameter's value until you can export correctly.

Cheers!

OBIEE 12.2.1.2.0 is available

Oracle Business Intelligence 12.2.1.2.0 is available now for download.

You can download it from this link.
Documentation is available on this link.

It's available as usual for Windows, Linux, Solaris on Sparc, Solaris on x86, IBM AIX and HP UX Itanium platforms.

Enable Multiple RDP Sessions in Windows Server 2012

Something little bit different but something you need if you are running OBIEE 12c on Windows 2012 server. When you want to start/stop services you need to run scripts from Oracle. They will start in one user session. If other user log in via RDC with same credentials, your services will stop work. Best practice for this is to disable single Remote Desktop Services session as described below.

By default, Windows Server 2012 allow single Remote Desktop session. If only one session is available and you take over another person's live session, you may choose to enable multiple RDP sessions. 

Enable Multiple RDC Sessions

- Log into the server using Remote Desktop.- Open the start screen (press the Windows key) and type gpedit.msc and open it- Go to Computer Configuration > Administrative Templates > Windows Components > Remote Desktop Services > Remote Desktop Session Host > Connections- Set Restrict Remote Desktop Services user to a single Remote Desktop Services session toDisabled.
- Double click Limit number of connections and set the RD Maximum Connections allowed to 999999.