IBM Support

"Standard Error ... ORA-00955: name is already used by an existing object" trying to import from flat files (CSV)

Troubleshooting


Problem

User clicks "Transfer – External data – Import from Flat File". User chooses an import specification, and selects a file (for example CSV or TXT). User tries to import the file. Error #1 appears. If the user tries to perform the same import again, Error #2 appears. User will continue to get Error #2 in the future (during an import) unless they perform a database optimise. After this, they will initially get Error #1, but then (from then onwards) get Error #2 again.

Symptom

Error #1 (immediately after a database optimise):

Standard Error

Details:


Source: System.Web.Services
Description: Server was unable to process request. ---> Object reference not set to an instance of an object.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Cognos.Controller.ControllerSoapHttpClientProtocol.Invoke(String methodname, Object[] parameters)
at Cognos.Controller.Proxy.FrDImportBT.WSFrDImportBT.clsExtImport_DoImport(String sGuid, String sUser, Boolean bCaseExpVal, Int32 iBatchId, String sSpecName, String sStructureType, String sPrompts, Int32 iLLocale, Boolean& bError, Int32& iError, String& sErrorMsg, DataSet dsFileDataAndInfo, DataSet& dsRecon, DataSet& dsLog, Boolean bIsExcelImport)
at Cognos.Controller.Direct.DIimportD.ImportExternalData(String sSpecName, String sStructureType, String sPrompts, DataSet dsFileDataAndInfo, DataSet& dsLog, Boolean bCaseExpValue, Int32 iBatchId, Boolean& bIsExcelImport, Boolean& bErr, Int32& iError, String& sErrorMsg, Int64& lImportedRows)
at Cognos.Controller.ControllerDImport.clsDImport.ImportData(String sSpecName, String sStructureType, Int32 iBatchId, String sImportDir, String sImportFile, String sPrompts, DataSet& dsLog, Boolean& bErr, Int32& iError)
at Cognos.Controller.Forms.Form.frmDIstartimp.ImportExternalData()
at Cognos.Controller.Forms.Form.frmDIstartimp.IForm_DoClick(Int32 lCmd, String& sTag)

Error #2 (subsequent tries, before a database optimise):


Source: System.Web.Services
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: ORA-00955: name is already used by an existing object
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at ControllerServerCommon.RaiseErrSrv.RaiseException(Int32 number, Exception ex)
at FrDImportBT.clsExtImport.DoImport(String sGuid, String sUser, Boolean bCaseExpVal, Int32 lBatchId, String sSpecName, String sStructureType, String sPrompts, Int32 lLLocale, Boolean& bError, Int32& lError, String& sErrorMsg, RecordSet rsFileDataAndInfo, RecordSet& rsRecon, RecordSet& rsLog, Boolean bIsExcelImport, Int64& lImportedRows)
at Cognos.Controller.Proxy.CCRWS.clsExtImport_DoImport(String sGuid, String sUser, Boolean bCaseExpVal, Int32 iBatchId, String sSpecName, String sStructureType, String sPrompts, Int32 iLLocale, Boolean& bError, Int32& iError, String& sErrorMsg, DataSet dsFileDataAndInfo, DataSet& dsRecon, DataSet& dsLog, Boolean bIsExcelImport)

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg22004011

Page Feedback