Wednesday, October 22, 2014

OBIEE 11g PDF printing bug related to Page Number on Footer of analysis

When attempting to print an analysis that has a Page Number variable displayed in the page header or  footer, the following error is displayed:

Error: "Sax parser returned an exception. Message: Expected whitespace. Error Codes: UH6MBRBC"

The problem is related to OBIEE 11g bug 18601947 which is described on Oracle Support below:


When Exporting a Dashboard to PDF with a Page Number in the Header or Footer
(Doc ID 1913713.1)
https://support.oracle.com/epmos/adf/images/t.gif


https://support.oracle.com/epmos/adf/images/t.gif

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.140415 to 11.1.1.7.140527 [Release 11g]
Information in this document applies to any platform.
**Updated on 15-Oct-2014**

Symptoms

When you export a dashboard that has a page number (@{pageNumber}) in the footer or header to PDF, the following error appears:
Error
====
Sax parser returned an exception. Message: Expected whitespace, Entity publicId: , Entity systemId: , Line number: 33, Column number: 21
Error Details
Error Codes: UH6MBRBC
Location: saw.subsystem.portal, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

Note: If you remove the page number (@{pageNumber}) from the footer that has been set at the dashboard properties level, this error no longer occurs.

Cause

Bug 19010387 - SAX ERROR WHEN EXPORT A DASHBOARD TO PDF WITH PAGE NUMBER (FOOTER OR HEADER)
Bug 18601947 - PM: RESOLVE BASIC HTML IN VIEWS CONTAINING FMAP AND PAGENUMBER
 

Solution

This issue has been fixed in Patch 18601947 which can be download from My Oracle Support (http://support.oracle.com).

Thursday, October 16, 2014

More than 5000 people have taken at least one of these #OBIEE quizzes... best free prep for certification exam 1Z0-591

If you can pass these quizzes, you are well prepared to pass the OBIEE certification exam (1Z0-591)

OBIEE 11g Answers Quiz 1
http://quizegg.com/q/67021

OBIEE 11g Answers Quiz 2
http://quizegg.com/q/67377

OBIEE 11g RPD Quiz 1
http://quizegg.com/q/62269

OBIEE 11g RPD Quiz 2
http://quizegg.com/q/62396

OBIEE 11g RPD Quiz 3
http://quizegg.com/q/62397

OBIEE 11g Security Quiz
http://quizegg.com/q/67439

OBIEE 11g Bundle Patch 11.1.1.7.141014 is available for download from Oracle Support #OBIEE

No new features in the 1414014 patch release.   Bug fixes are listed below.

Section 8.1: Oracle Business Intelligence Installer (BIINST)
No new bug fixes.
Section 8.2: Oracle Business Intelligence Publisher (BIP)
New bug fixes in this patch are shown in the following list:
19685263:       QA:SEARCH OPTION FOR SINGLE SELECT PARAMETER NOT WORKING
19236186:         SEARCH VALUES NOT REFLECTED CORRECTLY WHEN CANCEL SELECTED IN SEARCH BOX
19550559:       PARAMETER VALUES GETTING DUPLICATED WHEN CLICK ON REMOVE OR REMOVE ALL
16364586:       MULTIPLE VALUE PARAMETERS ARE NOT PASSED TO NEW ENGINE.
17412119:       JKF - FUSION BI PUBLISHER PAGE HAS STOPPED WORKING ON PRODUCTION
17846765:       BIP - BUG 17463451 - QA: SECTION BACKGROUND COLOR DOES NOT SHOW IN THE EXCEL
17979086:       DEFAULT SELECTED VALUE IN PROMPT NOT APPEARING IN SEARCH WINDOW(ISSUE WHEN PROMP
17979327:       REPORTSERVICE WEB SERVICE ALWAYS RETURNS FALSE FOR MULTIVALUESALLOWED
18025050:       BIP RUNS OUT OF MEMORY WHEN OS IS SET TO NON EN_US LOCALE
18077559:       IYA - MOZILLA FIREFOX CRASHES WHEN EDITING DATA SET
18113617:       R8BP: HTTP 500 ERROR WHILE TRYING TO EDIT PAYABLES TEMPLAT UNDER CUSTOM REPORT
18173394:       Fix for Bug 18173394
18306507:       QA: NO LINE BREAK SHOWS ON EXCEL NARRATIVE VIEW
18332362:       Fix for Bug 18332362
18336186:       11G:SCHEDULE PAGE IS NOT TRANSLATED ACCORDING TO LANGUAGE
18429472:       NLS:BIP WEB UI PAGE CAN NOT BE LOADED IN FA USER LANG IN CERTAIN SCENARIOS
18515334:       SCHEDULING REPORTS FAILS WITH SPECIAL CHARACTERS IN SEARCH CRITERIA FOR BIP 11G
18539339:       PARAMETERS PASSED FROM PROMPT TO BIP CONVERT COMMA (
18542946:       'FIRST WEEKDAY' NOT WORKING CORRECTLY IN SCHEDULER
18609529:       2:PSR:PERF:BIP: NEED OPTION TO SET DATA MODEL SCALABILITY MODE AT INSTANCE LEVEL
18622456:       LAYOUT EDITOR 'REPEATING SECTIONS' DESCENDING SORT NOT WORKING FOR PDF OUTPUT
18632799:       BI REPORT JOBS STOPPED RUNNING AFTER THE POD WAS TAKEN DOWN FOR MAINTENANCE
18665704:       LOV DISPLAYS PRODUCT ID INSTEAD OF PRODUCT NAME FOR SEARCH BEYOND LOV LIMIT
18712052:       PREVIOUSLY SELECTED VALUES NOT REFRESHED WITH DEPENDENT LOVS WITH 1000+ VALUES
18745662:       OPEN FILE HANDLES NOT BEING RELEASED
18816952:       PSR:PERF:BI BIP PLSQL CALL AT THE ROW LEVEL IN THE JDBC LAYER CAUSES OOM
18889966:       EXCEL FOUND UNREADABLE CONTENT IN 'NAME OF EXCEL FILE.XLSX'
18967973:       FOPROCESSOR GENERATES HUGE *.FO FILES UNDER /TMP
19032857:       ONCE CACHE TIMEOUT HAS EXPIRED, ANY OTHER REPORT RUNS ARE NOT FETCHED FROM CACHE
19131461:       SEARCH VALUES NOT REFRESHED IN DM EDITOR WHEN SELECTING LOV FROM SEARCH DIALOG
19214907:       WHEN LOV IS OF FIXEDDATA ,REPORT IS THROWING CLASSCASTEXCEPTION.
Section 8.3: Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
No new bug fixes.
Section 8.4: Oracle Business Intelligence Server (BISERVER)
New bug fixes in this patch are shown in the following list:
17804119:       OBIEE/BIP: UNABLE TO SEARCH LIST OF VALUES WHERE LOV QUERY USES A PARAMETER
18504891:       AFTER UPGRADE FROM 11.1.1.6, %AGE CALCULATION IN PIVOT TABLE IS INCORRECT 
18968751:       BI SERVER TAKES LONG TIME TO PROCESS OTBI LOGICAL REPORTS AFTER REL7->REL8 UPG
15845044:       NEWLY ADDED PRESENTATION TABLE ALWAYS GOT PUSHED TO THE BOTTOM IN SA
16371472:       UNEXPECTED RESULTS WITH LOCATE AND SUBSTRING FUNCTION
16796272:       ENABLE AUTOCOMMIT AND ADD TIMESTEN OPTIMIZER HINTS TO QUERIES
17407252:       REPORT WITH HFM CONNECTOR CRASHES HFM WITH MORE THAN 50 CHOICES
17442448:       FILTER ON HIERARCHY COLUMN WITH HFM CONNECTOR ERRORS:OPR4ONWY:U9IM8TAC:OI2DL65P
17503750:       EXTREMELY SLOW MUD CHECKINS - PARTLY DUE TO CONSITENCY CHECKS
17651328:       REPORT ERRORS OUT WHEN DRILLED DOWN ON A HIERARCHICAL COLUMN.
17820357:       EQUALIZERPDS VERSION STRING STORED IN .DATA SECTION INSTEAD OF .ORACLEVERSION
17831621:       INTERNAL ERROR WHEN TRYING TO DO "KEEP ONLY RELATED PARENTS" FROM ASO APPLICATIO
18160174:       CUSTOMGROUPMEMBERS IN MDX SHOWS NO RESULT BY ESSBASE-METHODS LIKE MEMBER.CURRENT
18171844:       REPORT ERRORS OUT WITH ESSBASE ERROR: REPEATED DIMENSION [ANALYSISCODE] IN MDX
18178380:       DELETING PHYSICAL COLUMNS IS NOT REFLECTED IN MASTER REPOSITORY
18234853:       AGGREGATE DATA INCORRECT FROM SAP BW DATASOURCE
18475438:       CSSTOKEN CODE PATH BROKEN
18615083:       RPD ACCESS CONTROL CHANGES BETWEEN 10G AND 11G
19076537:       OBIEE11.1.1.7.140415 [NQSERROR: 46008] INTERNAL ERROR: SQOIMDXGENERATORHYPERION.
18763373:       TIME DIM CUSTOM GROUP WITH SUM/+ GIVES WRONG RESULT ON TIME BALANCE MEASURE
New bug fixes in this patch are shown in the following list:
19546808:       TRACKING BUG TO DELIVER BUG 16068402 FIX TO 11.1.1.7.141014 (OCT 2014 PATCHSET) 
17311027:       PROMPTING ON GROUPS CAUSES ERRORS WHEN EXPORTING REPORTS.
17220399:       CANNOT GET BACK TO TOTALS USING PIVOT TABLE PROMPT 
19277857:       PSUEDO HTML TAGS IN COLUMN FORMULA FAIL TO EXPORT IN JULY BP
18826493:       OBIEE 11G: NARRATIVE VIEW  EXPORT TO PDF CAUSES SAX PARSER ERROR:UH6MBRBC 
14782647:       CUSTOM CSS STYLE OF COLUMN HEADING DOES NOT WORK ON IE BROWSER
14803272:       QA:EXCEPTION ON EXPORTING A REPORT WITH CUSTOM NUMBER FORMAT EXCEL 2007
16556274:       QA: VALUE MENU NO POPULATED IN CONDITIONAL FORMT>NEW CONDITION IF BINS CASE STMT
16875993:       CHANGING SLIDER VALUE-YEAR,VERTICAL AXIS VALUES DISAPPEAR IN CHART WITH STYLING
16907102:       11G DISPLAY A PRESENTATION VARIABLE IN COLUMN TITLE FOR GRAND TOTALS SHOWS HTML
16919893:       RETURN LINK CLEARS DASHBOARD FILTERS
17057555:       UNABLE TO USE ESCAPE CHARACTERS IN CALCULATED ITEM - FAILS WITH SYNTAX ERROR
17308853:       SSO CANNOT WORK FOR EPM WORKSPACE
17342813:       PARTIAL DATA SHOWN AT PARENT LEVEL WHEN USING HIERARCHY OBJECT IN TABLE/PIVOT
17449621:       SELECTION  ON HIERARCHY COLUMN : CAN'T SELECT MEMBER  'OK GREYED OUT'
17515912:       'NO EDGE DEF: SAW_8834_B' ERROR AFTER CLICKING ON DRILLABLE COLUMN. IE7.
17653504:       HIERARCHICAL PRESENTATION VARIABLE NOT SET WHEN NAVIGATED VIA ACTION LINK.
17719891:       OBIEE 11G: SAVED RESULT SETS NOT PHYSICALLY DELETED
17734913:       CHOPPY AND PAUSED SCROLLING ON 11.1.1.7 SERVER VS 11.1.1.6 SERVER.
18191433:       OBIEE 11G - MULTIPLE DEVICE PROFILE NOT WORKING
18289005:       QA:FATAL ERRORS ARE THROWN WHEN TRYING TO EXPORT COLUMN PROMPT WITHIN DB PAGE.
18299341:       PRINT TO PDF ONLY SENDS FIRST 25 ROWS WHEN USING VIEW SELECTOR
18421243:       RELEASE LABEL VERSION EXTRACTION SHOULD USE UNDERLYING DATED LABEL
18430260:       PSR:FUNC:BI:BETTER THREAD QUOTA ERROR MESSAGE THAN STD::BAD_ALLOC
18512339:       INSERT PAGE BREAK NOT WORKING WHEN USED TOGETHER PLACE VALUE IN NEW ROW
18531410:       AUTO COMPLETE PROMPT BOX NOT DISAPPEARING WHEN TABBING
18601947:       PM: RESOLVE BASIC HTML IN VIEWS CONTAINING FMAP AND PAGENUMBER
18677382:       ADDING CALCULATED ITEM WITH FORMULA $N FAILS IN DIRECT DB REQUEST ANALYSIS
18699238:       LOG REASON FOR SESSION LOGOFF
18770064:       [1602241] SAWSERVER CRASHED ON 11.1.1.7.140225
18787874:       CLICKING ON 'NEXT 25 ROWS' ALWAYS RETURNS COMPOUND VIEW
18828701:       GETCOLUMNVALIDVALUE THROWS AN EXCEPTION WHEN A SEARCH EXPRESSION IS GIVEN
18896901:       PASSING VARIABLES TO THE HTMLVIEWSERVICE WEB SERVICE
18957880:       PAGE BREAKS NO LONGER WORKING IN 11.1.1.7.1.X
19065395:       COPYITEM SHOULD ALLOW COPYING ALL CONTENT OF A READONLY FOLDER TO A NEW FOLDER
No new bug fixes.
Section 8.7: Oracle Business Intelligence ADF Components (BIADFCOMPS)
No new bug fixes.
Section 8.8: Oracle Business Intelligence Platform Client Installers and MapViewer

No new bug fixes.OBIEE