IBM Support

Cognos Business Intelligence 10.1.1 FP3 Fix List

Release Notes


Abstract

A comprehensive list of defect corrections for major releases, refresh packs and fix packs of Cognos Business Intelligence 10.1.1.

Details of the APARs listed below can be accessed by clicking the link for the APAR number. If you have questions about a particular defect, please contact Customer Support.

Content

Cognos Business Intelligence 10.1.1 Fix List

Issues corrected since IBM Cognos BI 10.1.1 FP2.
NumberDescription
PK99526BIBus process does not drop DB connection when DB goes offline resulting in sqlPrepareWithOptions status=-121
PM05287LDAP SSO FAILS IF SSO TOKEN CONTAINS ? (CHAR 0241)
PM15971CM-SYS-5043 Content Manager failed to create an object
PM23279If-then-else with current_date gives incorrect result
PM35650"DUPLICATE LOGON ENTRIES IN COGIPF_USERLOGON WHEN SCHEDULES EXECUTE"
PM37379Drill through chart, the icon in Business Insight when hovering does not show hand pointer
PM43283User unable to run reports when user only has Traverse permission on the top level Data Source directory.
PM49327"RUNNING A SPECIFIC LIST REPORT WITH TABULAR SQL AGAINST ORACLE CAUSES A BIBUS CRASH IN ICUIN40.DLL"
PM51476Combination chart can not sort date related value in x-axis
PM52523Go Search errors irregularly
PM52938RSV-AOM-0011 No namespace definition exists in the scope
PM53653Multiple pie charts not rendered in Excel 2007
PM5423710.1.1 - spaces are replaced with plus signs "+" when saving a report o excel
PM55139Report dependencies doesn't work when uncheck maximum reports
PM58509Cannot open Excel output when using a Cognos Navigator portlet
PM58662QE-DEF-0314 when user has only Execute and Traverse permissions on datasource
PM59562Unable to open reports in Studios after Inactivity timeout when using SSO: DPR-ERR-2079
PM60085"""OPEN WITH REPORT STUDIO"" ICON IS MISSING FOR PORTLETS WITH PREFERENCES DIFFERENT THAN ENGLISH LANGUAGE"
PM60167Self drill-through report doesn't pass data item value to a target parameter correctly
PM60209Report title with HTML tags displays HTML tags when exported as excel 2007
PM60575New Tm1 server instance is not unregistered after deleting it from the Cognos configuration window
PM60952CPPWebException occurs when migrating Series 7 bookmark
PM61496CPS-PAG-4801 Error
PM61665Setting "Respect soft page breaks" in Cognos Go causes a report to fail with RDS-ERR-1018
PM61952Multiple deadlock errors on content store after upgrade from 8.2 to 8.4.1
PM62184Browsing a specific sub folder of an AD Namespace locks up the CM and hit's CGI timeout.
PM62296Report Studio report in Excel output displays (2.) instead of (2) for negative numbers
PM62686Charts showing ampersand as & after HS install if legend turned off
PM62829Line chart: Axis range minimum and maximum value may prevent the measure values from displaying
PM62830Legend truncation value is not working as expected
PM63130BMT-MD-5002 error updating a view in FM DQM
PM63246XQE-GEN-0010 RSV-SRV-0042 'The graph is missing nodes.'
PM63785Export to Excel 2007 loses data formatting when using multiple measures in PowerPlay Studio
PM65355Cancel running activities results in "could not be completed" message but cancel successfully
PM66128Users are constantly prompted for credentials when creating a watch rule/alert
PM66455Dispatcher cache causing OutOfMemoryError
PM67186Editing a saved prompt value forces users to navigate through all prompts.
PM67349Linear regression property 'A trendline for each series item' behaves inconsistently using new default chart technology
PM67687"Moving dispatcher into a folder causes duplicate dispatcher registration and service errors"
PM69544Upcoming Activities cannot see when user has a schedule between 8AM to 8AM
PM69917Drill up is not updating correctly with except function in the data item
PM69932"Expand" in PowerPlay Studio results in error: The request failed because of an unknown error
PM70031Firewall security rejection when trying to view configuration of Dynamic Query Mode connection to MSSQL datasource
PM70123Unexpected SQL change when external data is added to the model
PM70436CGSErrorAssert:0:Fatal: Error: All components of GlyphSize must be positive
PM70907Summary and Natural Summary does bring correct results when if then else is used
PM70924Inconsistent behavior when bursting to missing CAMIDs
PM70973Parameters not passed in drillthrough when passing attributes with operations such as substring.
PM72912Carriage return added to email body on edit when rich text is used
PM72926Analysis Studio report fails when package uses more than one datasource
PM73366TM1 based report fails in 10.x worked in 8.4
PM73801List of values unfiltered in filter expression
PM73898When viewing a Line Chart in PDF format, the Y-axis categories names overlap onto the bar graph axis.
PM73903"SAP BW Drill Through parameters are not passed to target report when routing rules are used"
PM74245Drillthrough from Active Report to Cognos Viewer doesn't have toolbar and header
PM74571CNC-SDS-0336 There are no valid recipients for the message
PM74614Missing send date information in email from Cognos reporting
PM74879"Advanced Settings set at /configuration level duplicate on reconfigure"
PM74930Inconsistency in XML returned by RDS based on browser locale
PM74973EXTRA CROSSJOIN WHEN PROCESSING LARGE REPORT VS SAP BW
PM75000Drill-Through does not pass PageSet context
PM75098Minor grid lines not displayed at right side of combination chart
PM75384Background images are tiled when "Do not tile" selected
PM75795Endless looping pop-up window spawned by Analysis Studio with prompt macro on measure
PM75864"Enabling the Enable8Dot2Suppression option in ansproperties.xml results in RSV-SRV-0040"
PM75884OLAP report with detailed filter, upgraded from 8.4 to 10.1.1 FP1 does not yield data
PM75939A behavior change in drill-down affects upgraded reports
PM76065Select multiple rows on several pages does not work as expected
PM76340Performance issue executing a report from Business Insight with the content language set to French
PM76377Webservice Agent fails with CNC-ASV-0007 An error occurred with the agent Web service task
PM76419CV-0002 Error in Portlet When Exporting Report Output to PDF
PM76574Blocking error message prevents report execution using DQM and Netezza
PM76583DQM cache showing users data they don't have access to.
PM76705Using copy paste in a complex report gives script error
PM76780GETTING ERROR "UT-DEF-0115 CAN'T CREATE LOCK FILE"
PM76784Content Manager query with pipes returns inconsistent results
PM76810"MY INBOX LINK STILL VISIBLE IN COGNOS ADMINISTRATION EVEN THOUGH UI_HIDE PARAM IS SET TO HIDE IT."
PM76963"CALCULATION RESULT OF DIVISION IS WRONG WHEN USING SLICER AND TOTAL."
PM77080 Cognos Workspace Advanced displays an error when log off and insert Chart in work area with TM1 Cube package.
PM77196CAF error when drill-through in PDF, when hostname starts with number
PM77642Context Filters in Excel 2007 - Analysis Studio export text hidden inside cell
PM77649Customer doesn't want see the report output icon when he run the job's schedule.
PM77654Workspace reports imported from Report Studio fail with invalid query error
PM77660REPORT RUNNING AGAINST TERADATA CAUSES BIBUS TO CRASH
PM77781Use and Display option for a Slider Filter in Business Insight
PM77801Exporting to Excel via Powerplay Studio causes misalignment when you hide both Parent and Child elements
PM77863Cognos Viewer drop-down menus are displayed at incorrect window locations after scrolling or browser re-sizing
PM78195Analysis Studio throws ANS-MES-0005 when adding members only in Internet Explorer
PM78197Two Report Server crashes occurred on Day #4 of a Batch Reporting Stability test.
PM78217Teradata 13 Date becomes datetime for advanced filter
PM78236Users can't login in the portal due to instability and intermittent error message. The credentials are not valid error.
PM78248Auto generated prompt for variable in else statement is displayed in DQM
PM78260Editing join relationship is not possible
PM78344Running or Validating report results in UDA-SQL0191
PM78408"COGIPF_RUNJOB.COGIPF_STATUS shows Success when job fails and COGIPF_RUNJOB.COGIPF_LOCALTIMESTAMP"
PM78433Add support for printing reports in Cognos Connection multi page portlet
PM78441Drill through to multiple SAP BW queries with an error XQE-PLN-0001 Internal error
PM78455Area Chart - after scale Y axis the chart look overflow
PM78474Export to Excel 2007 fails if a combination chart has a conditional palette in the secondary axis
PM78526Customer cannot use Cognos 10.2 SDK with Oracle Java 1.7 in an SSL environment
PM78600Metrics Studio portlet time out in Sharepoint 2010
PM78670Gateway no longer rejects SDK logon requests
PM78727Incorrect rds:url with ServletGateway and https
PM78734Ampersand "&" in Account Display Name Prevents Tables From Being Imported in Framework Manager
PM78823Users not prompted for new credentials on expiry when using their own data source credentials.
PM78842Deployment export/import stays in "Pending" state when Routing Rules are specified
PM79035Excel 2007 output no longer merging cells when list cells merged
PM79042"ANALYSIS STUDIO ZERO SUPPRESSION KEEPS PROCESSING EVEN AFTER CANCELLING THE REQUEST"
PM79144Burst logic and master detail giving incorrect results
PM79179DQM: Last aggregation rules returning null data or 'no data available' message even if fact data exists
PM79348Clicking on the "bottom" button of a large interactive HTML report results in XQE-GEN-0002 error
PM79352Query studio, clicking save with Novell causes core
PM79428XQE-GEN-0002 ArrayIndexOutOfBoundsException when running a report against a Mondrian/OLAP data source
PM79502Query Studio does not update prompt type after changing it in the model
PM79503Slow HTTPS traffic via CMS .net code
PM79607"Drilling through a few levels deep to multiple target reports causes user to be re-prompted for same prompt values"
PM79610CMS return of HTMLFragment output is truncated. problem is caused by drillthroughurls=true. If removed Cognos returns all data
PM79615"High number of cursors remain open when using Content Store Database"
PM79681Borders Property Not Retained After Converting Chart
PM79753CogAdmin / Upcoming Activities: Filtering upcoming activities by package and owner does not render the correct results.
PM79797Export Excel 2007 loses formatting
PM79814Export Excel 2007 displays an extra column (parent category)
PM79876Mondrian-based DQM request failing with XQE-DEC-0016 Internal Error message
PM80163Report Studio decimal places not showing on pie chart
PM80382'--' displayed when running some reports
PM80969"JAVA PROCESS TAKES UP MORE MEMORY THAN ALLOWED IN COG CONFIG WITH TM1, DQM"
PM81001Join relationship missing on second opening in Report Studio
PM81209In PDF, item can not be displayed by defined expression
PM81450Query Studio Uses Wrong Prompt Type When Prompt Info Reference Values are Set and Filter Item Reference is Hidden
PM81477The Chart DataItems with external Query-references are validated only for the Chart-Query.
PM81711Incorrect drill behavior in Business Insight, drill down then change the measure via a dynamic prompt the dimension resets
PM81777Japanese name saved report cannot be opened in Firefox
PM81793 Report execution failure in PDF (ASYNCH REQUEST) : CCL_ASSERT(i<m_rdis.size())
PM81843Adding text in a report slower in 10.1.1 than it was in 8.4
PM81859Report Studio decimal places not showing on pie chart/non-legacy charts
PM81881The year portion of the start date in a Data Manager build log is incorrect
PM81882Report expression nextMember() with pageSet and master detail relationship is not running in TM1
PM81947QE-DEF-0314 ERROR WITH READ PERMISSION REMOVED FROM DATA SOURCE.
PM81988If query options is different on each advanced options, the summarizing behavior is inconsistent between each format.
PM82125CNC-DS-0008 No output available error when bust key has spaces.
PM82374Parameter value by auto submit is incorrect when data contains '+'
PM82679Report run cause eUnknownCellIteratorAction error
PM82728Cognos viewer can't be resized for PDF output after accessible report output enabled
PM82730Chart loses properties when display type is changed in Business Insight
PM82747Landing page when running excel reports does not function correctly
PM82887Prompt communication passes values to wrong parameters in portlets
PM83279Upgraded 10.1.1 report calculation incorrect compared to 8.4.1 report
PM83291Load external data source (.xlsx file) from network share QE-DEF logon failed error
PM83727Cells not merged when exporting to Excel 2007 from PowerPlay Studio
PM83964Content Manager failover not being reflected properly in Cognos Admin, can't fail back gracefully
PM83983XQE-PLN-0011 CREATING A REPORT USING DQM
PM84065Query Studio should work based on Run Report menu query options after upgrading from ReportNet.
PM84104Row headers are centered instead of left-aligned, when using Export Excel 2007 (.XLSX)
PM84120Formatting lost when Change Display Type from Crosstab to Chart back to Crosstab
PM84121XMD-ERR-0001 Query execution failed error message for master detail TM1 report
PM84249Job option Continue on Error does not work if the job is nested under another job which submits steps all at once
PM84352"Intermittent error: ""PRS-INS-1425: An error encountered executing operation"" when creating package for new Powercube data source."
PM84441Query Studio "prompt every time the report runs" checkbox not checked
PM84490DQM based native SQL/MDX statements don't get written to COGIPF_NATIVEQUERY although logging/logging to audit has been activated
PM84660Publish a package causes BMT-MDC-0001:unable to publish the package error
PM84707Drill Through - Error when using Action -> View most recent report
PM84995System Administrator cannot cancel report
PM85075Links (arrows) are not displayed correctly in Query Explorer
PM85298Can't see all synonyms created in Netezza DB in Framework Manager
PM85581The load window will freeze when a report is opened from Business Insight via the "Do More" menu
PM85885SQL Exception will be thrown when log is inserted to audit table after XQE-V5-0013 error
PM85941"BI report fails against Dynamic Query Mode model running TM1 data Source (Success in Classic)"
PM86086Even though the same query is used for crosstab and chart, division used if clause in the query is incorrect for the crosstab
PM86168Index Update Task takes very long and does not finish
PM86170Zero Suppression Does Not Return Expected Results When Page Sets are Used in Query Studio when Viewed in HTML
PM86228Incorrect sheet name when exporting to excel 2007
PM86428XML characters used in a datasource password cause error
PM86536Cognos Transformer is crashing with a double-free error on Red Hat 6.3 after 9th daily cube build
PM86618XQE-PLN-0020 The V5 Query could not be planned by the Query Service.
PM86634Upgraded report fails with RSV-BBP-0037, RSV-BBP-0022 errors
PM86662"IMAGES USING RELATIVE PATH FAIL TO RESOLVE IN PDF USING SSL AFTER INTERIM FIX 2"
PM86886Even though Query options under Run Report menu are changed, it is not reflected
PM86961Burst report failures with XQE-V5-0011 V5 syntax error found in expression
PM86996CONSISTENCY CHECK REMOVES ALL PERMISSIONS
PM86997XQE-GEN-0002 An unexpected exception occurred
PM87021Drill Up/Down option greyed out
PM87024Macro Function CSVIdentityName returns an empty list of values when used in a Filter
PM87219PRS-TRS-0902 processing the source at location "transforms/CM/post-process.xslt"
PM87285Cursor location does not effect select value in expression in Internet Explorer
PM87293Reports using External Data joined to a Report on Redhat 5.6 experience unusual rounding error when exported to excel
PM87444Series 7 users can't log on Cognos 10 when clustering PowerPlay/TDS service switch over.
PM87558RSV-SRV-0040 on Style Variable after upgrade
PM87562PRS-TRS-0906 The "VALIDATE" when saving email options with a hyperlink in email body
PM87582Routing Rules are not working with Agents
PM87790Drill down on column data to lowest level, then export to PDF, the column data becomes empty.
PM87841Consumer user can not cancel future report execution in My Activities and Schedules.
PM88120"Content Manger Service during cache initialization is experienci ng a long start-up time when connecting to a large content store"
PM88181Error received when search numeric column in filter creation by using Teradata
PM88240xlsColWidth Size Error Generated in a Excel 2007 Report After Fix Pack 2 for 10.1.1 is Applied
PM88288XQE-CON-0007 XQE error encountered: The request was cancelled by the user
PM88355unable to create filter on model calculation in BIA or RS but can in QS
PM88486Excel column not expanding for larger text
PM88525Formatting Issue on schedule email
PM88567XMLA requests need full CAM and CAMPassport information in the biBusHeader
PM88696RSV-VAL-0010(XQE-PLN-0001) validation error when using 'case' statement in join definition
PM88712Installing FP2 results in Powerplay service failure - java.lang.NoClassDefFoundError: com.cognos.pogo.bibus.CommandExecutor
PM89092Minor Grid Lines Not Displayed at Right Side of Combination Chart
PM89325java.lang.StringIndexOutOfBoundsException indexing particular set of reports
PM89405Updating Report - changes output version Settings back to default
PM89418UDA-SQL-0107 exception error occurs in running report
PM89488Report returns incorrect results after applying interim fix 10.1.6301.1234
PM89551Denial of service attack against servlet gateway
PM89653RSV-SRV-0040 Error on Drill Down in Powercube Based report.
PM89793Table cell with text item splits into multi-columns when exporting to Excel 2007
PM90020Columns not aggregated the same way depending on location of column
PM90246Cascading Prompts on Portal Tab do not refresh correctly if you leave the Portal Tab and go to Public Folders and return
PM90378Enabling /LARGEADDRESSAWARE linker flag for cogtr.exe on Windows
PM90927RSV-SRV-0040 Error on Excel output after applying hotsite 10.1.6303.1049
PM90940Excel 2007 chart cannot be generated correctly
PM90992Unexpected gateway URL appears when importing prompt report from MSOffice
PM91158Length of Varchar Column in database is doubled in length in the Report Studio XML output
PM91182List report spans incorrect number of Excel 2007 columns
PM91901Random dispatchers hanging
PM92023Comment disappeared in Cognos workspace report
PM92427Lose a previously completed setting when closing an error screen inside Query Studio
PM92490Trace.CAM.AAA.Provider.ActiveDirectory causes CAM_LPSvr core-if user is member of a group with wide character in the groups name
PM92498DB2 z/OS stored procedure fails to execute when input parameter is prompt expression
PM92531Cognos report studio stacked bar chart Y axis display range formatting issue
PM92803Report output to XML null value tag has changed.
PM92938Out-of-service occurs intermittently which is not recovered sometimes without system reboot
PM93483Framework Manager hangs if filter definition contains '[' parentheses
PM93508Saving a Report View in the folder name with an ampersand "&" character is not possible.
PM93544BI/TM1 report performs very slowly
PM94223Getting incorrect report output after installation of 10.1.1 FP1
PM94386users get the error DPR-GTY-5003
PM94489Unable to run specific event agent after restarting services
PM94782XMLA requests need MD:ReportPath information within the soap header
PM95162NextMember returns incorrect member when a calculation is placed on the left crosstab edge
PM95538Illegal instruction (core dumped) when Transformer builds powercube
PM95773CAM_LPSrvr dump files randomly causing deadlock
PM95775Cognos report not behaving as expected after upgrade from Cognos 8.4.0 to Cognos 10.11.
PM96021Cognos 10.1.1 HTML report output using Excel 2007 datasource not working after updating IE 9.0.11 to IE 9.0.13.
PM96484AAA-AUT-0010: User authentication required message after invoking Cognos gateway uri with h_CAM_action=logoff
PM96709Cognos 8 and 10 does not reflect the timezone Jerusalem correctly that causes critical schedule issues

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27040468