APAR status
Closed as program error.
Error description
Logon as a 'bad' user (for example u183113). Click 'Transfer - External data - Import from flat files'. Choose import spec 'SAP_FLOWS'. Browse to the attached file "30669.300.624.US29_FLOW_2017-03.TXT" and try to import. User receives an error: =========================== Standard Error Source: mscorlib Description: Item has already been added. Key in dictionary: '' Key being added: '' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Cognos.Controller.Forms.Common.clsDIlog.InitSecurity() at Cognos.Controller.Forms.Common.clsDIlog.Class_Initialize_Renamed () at Cognos.Controller.Forms.Common.clsDIlog..ctor() at Cognos.Controller.Forms.Common.frmDIshowstat.AssignLog(DataSet& rsLog, String sStructureType) at Cognos.Controller.Forms.Form.frmDIstartimp.ImportExternalData() at Cognos.Controller.Forms.Form.frmDIstartimp.IForm_DoClick(Int32 lCmd, String& sTag) =========================== Problem affects users that have a security on an extended dimension. It works fine for an unrestricted user or if the user is moved from this security group.
Local fix
Delete the user and create a new one. or 1 create a backup of the database 2.delete these invalid entries: delete from xnyst where frgrptyp='U'
Problem summary
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * Some users get "Standard error - item has already been * * added" when importing from flat file * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Controller 10.3 RP1 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PI81814
Reported component name
COG CONTROLLER
Reported component ID
5724W24CO
Reported release
A21
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-05-18
Closed date
2017-11-23
Last modified date
2017-11-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
COG CONTROLLER
Fixed component ID
5724W24CO
Applicable component levels
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 August 2024