Release Notes
Abstract
A comprehensive list of defect corrections for major releases, refresh packs, fix packs and generally available interim fixes of Cognos Controller 10.2.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 Controller 10.21 Fix List
| Number | Description |
|---|---|
| PI14506 | Acquisition calculation: correction of double E770 values when moving a company |
| PI20198 | Acquisition calculation: correction of double E770 values when moving a company |
| PI21428 | Import structures: difference between v8 and v10 in rights to import Exchange Rates corrected |
| PI21716 | Copy company journals: error message when logged in with restricted rights |
| PI24112 | Excel Link returns correct values for linked actuality |
| PI25095 | Error message 'Microsoft Excel has stopped working ... APPCRASH ... C8ITKShared.dll' when clicking on cube inside TM1 Perspectives |
| PI25320 | Report Books: The user can choose an output file format *.XLSX (Excel 2007/10) when exporting *REPORT BOOK* to file via 'Reports - Run' |
| PI25515 | Acquisition calculation: Corrected problem for accounts with 'C' translation code |
| PI25879 | Intercompany elimination: Correct storing of intercompany transactions when moving a company |
| PI25884 | Group/Reconcile/Btw acc opening balance by aut jrnls is now showing the report according to entered value in contribution version |
| PI26458 | Audit Trail: some audit log trail records missing corresponding audit log report |
| PI26489 | Excel link: AJTASBASE gets correct values when selection of a contribution version with all automatic journals |
| PI26627 | Consolidation: When consolidating a locked period the user gets message 'Period locked, consolidation aborted ' instead of an error message |
| PI27316 | Change in Company Structure creates an error message |
| PI27397 | DB2: user group->company group security overrule user company group security after upgrade to 9.7.900.205 |
| PI27613 | FAP: On 2nd Initial Publish of a FAP cube, attributes are missing and cube is unusable |
| PI27708 | Consolidation: Fixed problem with consolidation ending with an error after a company was disconnected from the structure |
| PI27732 | Intercompany elimination:Correct IC elimination for split company using S-method |
| PI28089 | Performance: Improvement in import of data (e.g. via flat files or staging tables) |
| PI28615 | Data Entry, Company journals: The last change in the journal by user is correct when printing journals |
| PI29041 | When you press the system audit log and browse an error message occurs |
| PI29314 | Intercompany report: display companies according to user rights |
| PI29315 | Import from Flat Files: Corrected Import Specification Error |
| PI29487 | FAP Service connecting to DB2 database gives error message in log file |
| PI29657 | Excel link: Menus that are opened from the excel link are now translated to the chosen application language |
| PI29750 | FAP Trickle stopped when using multiple data marts |
| PI30263 | Data Entry, Reported values: working as expected, able to see the counterpart in Data Entry form when using intercompany on line matching |
| PI30310 | Consolidation: the time for the 'Consolidation with Status' to receive the status 'Running' is in seconds now instead of minutes |
| PI30311 | Import from Flat Files: Import specification difference between v8 and v10 corrected |
| PI30479 | Acquisition calculation: Corrected difference between Net result in P/L and EQ |
| PI30881 | Export structures: currency rates can be exported successfully |
| PI30893 | UDBR script error corrected |
| PI31470 | Validate Parameter Access Error ...' when trying to save change inside 'Report Books' for a restricted user |
| PI31478 | Automatic journal type 1 shown incorrectly in Reconcile - Between Accounts/Opening Balances for Groups report |
| PI31916 | Import External data: Able to import .csv file containing trailing zeros |
| PI32073 | Consolidation: currency conversion values posted correctly on A coded account |
| PI32456 | Consolidation result differs between running over a range and running it period by period |
| PI32861 | Intermittent 'ValidateUser' error message displayed, caused by application pool timeout |
| PI33166 | Trial Balance with drill down: Full Journal number not visible in report |
| PI33245 | IC Journals missing after consolidation |
| PI33250 | Acquisition calculation: corrected posting on investment (main) account following company disposal |
| PI33928 | DB2 version 9.7.9 - error message displayed when saving standard form with base account in row and movement extension in column |
| PI34035 | Consolidation: Currency translation type U now working as expected |
| PI34080 | FAP: Removal of company structure now working when prefix defined in Data Mart definition |
| PI34515 | Generating summation structure now working after changes in company structure |
| PI34516 | Running Company - Reports - Company Journals on a large company now working |
| PI34994 | Running Change Table now working when Audit Log is on |
| PK98851 | Maintain\Rights\Reports fails to run (RQP-DEF-0177 error) when using system administrator as SQL login user |
| PM33619 | Form Structure Define: Corrected performance issue when saving changes |
| PM64681 | Company journals in column: When copying company journals between companies, the field original company will now be the same as the 'copy to' company |
| PM74241 | Excel link: 'Out of memory' when repeatedly running (F9) large/complex spreadsheet report in Controller 10.1.1 IF2 |
| PM83715 | Excel link: Custom Excel Add-In disappears when the Controller Link is used |
| PM88371 | Group journal: 'The user is allowed to save up to 2000 characters in Group Journal text. If the limit is exceeded the user is prompted that the maximum number of characters that can be used in a group journal type has been reached |
| PM96053 | Performance: Improved performance in generating Summation Structure when account structure has 7500+ accounts |
| PM97082 | System info: Displaying 'Computer Name' information in 'Help / System Info' |
| Number | Description |
|---|---|
| PI37272 | Problem with Excel Link - Copy/paste Excel functionality is not working correctly |
| PI37664 | Ctrl+a Delete causes Excel to hang |
| PI38144 | ERO not working correctly with Report Generator |
| PI38834 | Typing into a 'merged cell' causes Excel to hang 10.2.1 |
| Number | Description |
|---|---|
| PI08822 | The reconciliation code for the copy opening balance is invalid |
| PI10397 | Batch job 'Finished with Error' but no details shown in text box |
| PI15741 | Except this currency |
| PI20305 | "Could not enable structure tracking remotely ... SQLERRMC=ENABLE_TRIGGER" when trying to enable System Audit functionality |
| PI21043 | Incorrect saving behaviour in Cognos Controller configuration |
| PI21305 | Client hangs during logon when using HTTPS/SSL if use port number (e.g. 443) |
| PI21845 | Accounts define with advanced account view, wrong order after making summation changes |
| PI26203 | Error generated when opening reports saved using the 'Save As' functionality in Reports > Run |
| PI27806 | Can't see the end of the udbr script due to bad scrolling |
| PI28617 | DB2 - performance with update form layout |
| PI28625 | Inconsisytency in GUI between menu company and security groups |
| PI32860 | Error in AFC: Unknown LCID: 0! |
| PI33195 | Using Use Transfer Table in export of data, gives error in Controller 10 |
| PI33514 | Slow Excel link report after upgrading from 8.5.1 to 10.1.1 |
| PI33700 | Simultaneous use of the same import specification by two users |
| PI33950 | "ORA-01427: single-row subquery returns more than one row" when performing database optimise |
| PI35065 | For the Z consolidation method cross owned Equity company/group percentages do not sum together when they meet in the structure |
| PI35358 | Account Tree Structure deactivated |
| PI35559 | controller 8.5.2023 - DB2 Journal report is incorrect with value when 2 subsidiaries have same value |
| PI36504 | Customer cannot check FAP data marts, without stopping the system (downtime). |
| PI37137 | IBM Cognos Theme slower compared to Operating system theme |
| PI37272 | Problem with Excel Link - Copy/paste Excel functionality is not working correctly |
| PI37474 | I/C data entry issue following upgrade to 10.2.2025 |
| PI37664 | Ctrl+a Delete causes Excel to hang |
| PI38144 | ERO not working correctly with Report Generator |
| PI38245 | Violation of PRIMARY KEYconstraint 'PKNC_XDB14 |
| PI38622 | Intercompany balances issue |
| PI38733 | Problem with the result (IC adj dim) after consolidation - after upgrade |
| PI38747 | Wrong IC-Elim with CDim after upgrade to 10.2.1 |
| PI38834 | Typing into a 'merged cell' causes Excel to hang 10.2.1 |
| PI38850 | Error opening data entry in excel, ControllerForms12 |
| PI39069 | FAP error suspect due to duplicated companies |
| PI39107 | Slow report |
| PI39404 | Excel closes when closing Data Entry |
| PI40140 | Report missing text values after upgrade |
| PI40705 | Error when disabling add-in |
| PI40722 | Automatic Ownership issue with Cognos Controller 10.2 |
| PM17869 | Company status for locked submission 1 reset to Processing following submission 2 import from Excel Link |
| PM57022 | Controller Configuration using SSO, check Report Server: Invalid Report Server URI |
| PM57170 | Strange behaviour after changing User password |
| PM59082 | Log off users in "active users", the security popup gets hidden and users got stuck into the system |
| PM60473 | AFC values not displayed in Trial Balance report when closing/contribution version data displayed in columns |
| PM75931 | Linked actualities does not work in combination with free forms |
| PM77630 | Scheduling Batch Jobs - default time behaviour changed in 10.1 |
| PM91641 | Inconsistent currency type used in Excel compare to Ad hoc report |
| PM92138 | Report-> currency translation on journals can't show journal text in simplified chinese |
| PM92458 | Colour coding of batch queue does not update after sorting the list (inside manage or view) |
| PM98781 | In account define the overview tab you cannot save changes in the comment column |
| Number | Description |
|---|---|
| PI42985 | Standard Error ... Dynamic SQL generation for the Upd |
| PI43324 | Consolidation results in standard error |
| PI43840 | Bad performance when updating external links in Excel when Excel link installed |
| PI45446 | Issue with Export Data function in Controller 10.2.1 |
| PI47318 | Extra 'EXCEL.EXE' processes get generated when using 'Data Entry - Company Values' |
| Number | Description |
|---|---|
| PI28018 | Not able to store form including macro in format XLSX or XLM |
| PI36558 | Controller crashes/hangs after the laptop goes to standby if using CLEARCACHEONEXIT |
| PI37262 | Audit log screen lacking validation for user ID |
| PI37453 | Period not updated in Run Reports |
| PI37742 | Filtering the new inter company report, if there is not hit it will populate everything |
| PI39584 | Cannot make a historical rate zero |
| PI39984 | How to set up import specification for weekly period is documented in a tech note |
| PI40700 | Consolidation finished with Error |
| PI41737 | Controller master/slave gives error if using slave |
| PI41989 | Company Journals in 'GC' - values not the same running a consolidation in LE and OP |
| PI42302 | Submission order is random in Multi Period Locking |
| PI42679 | Function cc.fCComp() not correct in Report Generator |
| PI42909 | Standard error 5 when opening Investment register from data entry |
| PI42910 | 10.2.1FP1 - Excel link is not working on terminal server |
| PI42982 | Accounts change table failed on DB2 |
| PI42985 | Error when running Calculate Ownership Relations |
| PI43324 | Consolidation results in standard error |
| PI43492 | Function "ERO/Optimise2" fails when name of sheets contains Scandinavian characters |
| PI43840 | Bad performance when updating external links in Excel when Excel link installed |
| PI43872 | Error when configuring for Optimise2/ERO in Controller 10.2.1 FP1 |
| PI44153 | Error when exporting Submission Structure |
| PI44293 | Error in line 30 Data type mismatch when trying to delete accounts inside the 'Overview' tab of 'Define Account Structure' |
| PI44355 | Num Lock on keyboard will be disable if Excel is already open and the user tries to access Excel via Controller |
| PI44747 | Cognos Controller FAP - ApplicationSecurity_RestoreProcess error caused by conflict with user-added rules |
| PI44749 | FAP - Invalid key Dimension Name:")Groups" |
| PI45076 | Oracle error when using Trial Balance with Drilldown |
| PI45252 | FAP - Wrong quarterly aggregation with 13th Period |
| PI45446 | Issue with Export Data function in Controller 10.2.1 |
| PI45542 | Generating Account Structure - Performance and loops after upgrading to 10.2.1 FP1 |
| PI45619 | Large Excel Link Reports throw OLE errors |
| PI45708 | Function cc.fCompCurr() not working |
| PI45890 | cc.fComment() gives no result when referring to cc.fAcc |
| PI46498 | "FAIL:java.lang.NullPointerException: code can not be null" error when attempting to import Job Definitions and Subsets |
| PI46658 | Poor performance running macro when logged in to Controller |
| PI46752 | Bad performance the second time you try to open Run Report from Excel |
| PI46944 | Excel link lost (launched from Controller) |
| PI47015 | Expanded company code length too short |
| PI47318 | Extra 'EXCEL.EXE' processes get generated when using 'Data Entry - Company Values' |
| PI47696 | Problem with cc.fCompGroup in 10.2.1 |
| PI47699 | Looping errors in verify structures after upgrading to 10.2.1 FP1 |
| PI47801 | Strange phenomenon of running the report |
| PI47953 | Vlookup not working after upgrade 10.1.1 to 10.2.1 |
| PI48119 | Create layout and Reports Run turns Num Lock to OFF |
| PI48670 | UdBR rounding issue |
| PI48680 | "Call was rejected by callee"- error when running Trial balance when Fire.sys add-in is enabled |
| PI49030 | Excel F10 in 10.2.1 behaves different than 8.5.1 |
| PI49033 | If file name contains Chinese character, it doesn't retrieve value |
| PI49085 | Cannot edit Browse Data in 10.2.1 |
| PI49646 | FAP crash after Initial Publish |
| PI49666 | To save data in data entry form need to click SAVE button twice |
| PI49909 | Errors occur when the Excel Fire.SYS add-in is enabled alongside the Controller Excel add in |
| PI49912 | Error when Microsoft Excel add-ins enabled together with Controller Excel add-in |
| PI49914 | Excel Add-in conflicting with other Excel add-ins |
| PI50607 | Reports run - calendar days not populating data |
| PI51587 | Intercompany form - counterparty balance not showing |
| PM90441 | Standard error using Excel reports/create after running a weekly report |
| Number | Description |
|---|---|
| PI44455 | Optimise2 is not triggered when running one 'bad' spreadsheet (Excel link report never finish) |
| PI52639 | Server Pref to prevent Excel from open in the background when using 'Reports-Run' |
| Number | Description |
|---|---|
| PI48271 | If function (Excel link report) not working after migration to 10.2.1FP1 |
| PI52591 | No data is picked up by the setExtDimAggr function -UdBR |
| PI52878 | Several errors appear in Data Entry and Excel Link in customer environment |
| Number | Description |
|---|---|
| PI38513 | General Configuration: no OB populated in the cells transfer accounts when account has two OB |
| PI43575 | Import of external data: rounding on positive/negative difference |
| PI44455 | Excel link: performance issue due to no filter on period/actuality per xdb |
| PI45801 | Excel link is no longer interpreting result of cc.fPerM() as value |
| PI48271 | Excel link:IF function not more working after migration to 10.2.1FP1 |
| PI48311 | Reconciliation Between Accounts/Opening Balances: 'An unexpected error has occurred' SEC error |
| PI49561 | Investments for external companies: only the amounts from the beginning of the year to the selected period are fetched |
| PI49853 | FAP: AFC accounts not handled correctly |
| PI49903 | Group > Reconcile > Between Acc./OB option 'Analyze Diff for AJ') doesn't show some AJ |
| PI49993 | Form Layout does not finish when row or/and column elements are expanded |
| PI50079 | Print: Incorrect 'last modified' date on Group Journals |
| PI50640 | Automatic journal: E600 doesn't work with 'D' rate (Period average rate) |
| PI51399 | Group - Reconcile - Investment Elimination Template has performance issue |
| PI52456 | DB2: no access to group menu in Trial Balance (DB2) |
| PI52575 | Command Center: In data entry the extended dimensions can not be selected |
| PI52591 | UdBR: No data is picked up by the setExtDimAggr function if pointing to an aggregated level two levels up |
| PI52639 | Reports run: Excel open in the background when using 'Reports-Run' (server preference to prevent it) |
| PI52878 | Excel link: Several error messages when multiple users |
| PI53513 | Import journals: Transaction amount in GL journal upload missing |
| PI53535 | 'Development Version' message appears after upgrading to 10.1.1 FP3 IF3 GA (10.1.2706) |
| PI53584 | Form layout: Controller hangs when performing process layout |
| PI53677 | Linked actuality: Wrong currency conversion on Automatic Journals with linked actuality and cross owned group |
| PI54050 | Excel link: Functions cc.fComment and cc.fCommentLong are not working if comment does not exists on account. #VALUE! is shown. |
| PI54395 | Excel link: 2 fGetVal formulae in a single Excel cell not computing |
| PI54521 | Excel link: Report hangs when relation between fAcc and fAccName |
| PI54534 | Excel link: Error message when starting Excel from inside controller |
| PI55126 | Excel link: Formula cc.fComment does not return value if it refers to formula ff.cAcc() |
| PI55395 | Excel link: Performance issue with F10 |
| PI55627 | Historical rates are deleted from the database when an edit has been performed or when copied between periods |
| PI55988 | Excel link: The performance of cc.fComment formulas increased dramatically after applying testfix |
| PI56938 | Values not visible in a new form |
| PI57023 | Very slow 'Regenerating Extended Dimension Structures' when running a database optimise |
| PI58066 | FAP "Update Structure" button is triggered to be active when changing Period and/or Actuality when logging in to Controller |
| Number | Description |
|---|---|
| PI58227 | Consolidation finished with error: Violation of PRIMARY KEY constraint 'PKNC_xacq_conv' |
| PI56448 | Formula/calculated value not saved (DE) in a Standard Form with expanding dimensions in columns |
| PI46500 | Bad performance in the Report Generator after upgrading from 10.1.1 FP3 to Controller 10.2.1 FP1 |
| PI54142 | Intermittent slow performance running Excel reports via Citrix |
| Number | Description |
|---|---|
| PI61016 | Expanding Report Generator reports completely wrong |
| PI61384 | The IC elimination not transferred correctly to FAP |
| PI61696 | Problemas con la aplicacion Cognos Controller |
| PI62108 | FAP - Unable to run initial publish |
| PI62903 | Excel Add in - GetVal + Comment formula not working |
| PI63978 | The values in Companydetail & Colsoldated cubes differed between Controller and TM1 |
| PI66414 | Not enough storage is available ... E_OUTOFMEMORY when click Excel 'Calculate Sheet' button (for *large* TM1 Perspectives spreadsheet) when Controller link enabled |
| Number | Description |
| PI77593 | Query timeout expired when publishing data mart |
| PI63539 | Excel export values (CC.FEXPVAL-FORMULA) in group currency (VTYP=G) in 10.2.1 FP3 / FP4 |
| Number | Description |
| PI78685 | Export trial balance drill down to excel and switch to another excel sheet, exported report goes to both sheets |
| PI81504 | Excel linked formulas are not working |
| PI81814 | Some users get "standard error - item has already been added" when importing from flat file |
Related Information
Cognos Controller Software Environments
Download Cognos Controller 10.2.1
Download Cognos Controller 10.2.1 IF1
Download Cognos Controller 10.2.1 FP1
Download Cognos Controller 10.2.1 FP1 IF1
Download Cognos Controller 10.2.1 FP2
Download Cognos Controller 10.2.1 FP2 IF1
Download Cognos Controller 10.2.1 FP2 IF2
Download Cognos Controller 10.2.1 FP3
Download Cognos Controller 10.2.1 FP4
Download Cognos Controller 10.2.1 FP4 IF2
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27045132