Troubleshooting
Problem
User launches Controller. User clicks on 'Transfer - External Data - Import from Flat files'. User chooses 'Import Specification' (e.g. "IMPORTGL"). User selects 'client' and clicks on browse (...) button. User selects CSV file (e.g. TXT file). User clicks on 'Run'. User receives error message.
Symptom
Information
Standard Error
Source: ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable
to process request. ---> System.Runtime.InteropServices.COMException (0x800A000D):
Type mismatch
at FrDImportBT.clsExtImportClass.DoImport(String sGuid, String sUser, Boolean
bCaseExpVal, Int32 IBatchId, String sSpecName, String sStructureType, String sPrompts,
Int32 ILLocale, Boolean& bError...
<....>
--- End of inner exception stack trace ---
OK
Event Viewer (Application log):
Log Name: Application
Source: Cognos Controller
Date: 29/03/2012 13:20:34
Event ID: 0
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVERNAME
Description:
Standard Error
Source: ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException (0x800A000D): Type mismatch
at FrDImportBT.clsExtImportClass.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)
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)
--- End of inner exception stack trace ---
at Cognos.Controller.ControllerSoapHttpClientProtocol.Invoke(....
Log Name: Application
Source: VBRuntime
Date: 29/03/2012 13:20:34
Event ID: 1
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVERNAME
Description:
The VB Application identified by the event source logged this Application FrDImportBT: Thread ID: 3100 ,Logged: Error occured at 29.03.2012 13:20:34 in FrDImportBT, Error No=13, Source=#clsDIengine.ImportData, Description=Type mismatch, HelpFile= HelpContext=0
Log Name: Application
Source: VBRuntime
Date: 29/03/2012 13:20:34
Event ID: 1
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVERNAME
Description:
The VB Application identified by the event source logged this Application FrDImportBT: Thread ID: 3100 ,Logged: Error occured at 29.03.2012 13:20:34 in FrDImportBT, Error No=13, Source=FrDImportBT#clsDIengine.String2Numeric#clsDIengine.PerformOperation#clsDIengine.ParseLine#clsDIengine.ImportDataToLocalRS, Description=Type mismatch, HelpFile= HelpContext=0
Cause
There are several possible causes for similar errors when importing CSV data
- For more examples, see separate IBM Technote #1347811.
This Technote specifically relates to the scenario where the cause are incorrect Windows Regional Settings on the Controller application server, inside the Windows user profile that relates to the COM+ User Account.
More Information:
Specifically, in one customer's case, the problem was caused by the COM+ User running with "Norwegian" regional settings:
Resolving The Problem
Modify the Regional Settings on the Controller application server, inside the Windows user profile that relates to the COM+ User Account.
- In one real-life customer's case, the problem was solved by changing the "Format" from "Norwegian, Nynorsk (Norway)" to "English (United Kingdom)".
Steps:
- Obtain a short period of downtime (no users on the Controller system)
- Logon to the Controller application server as an administrator
- Launch "Controller Configuration" from the Start Menu
- Open the section "COM+ Server"
- Make a note of the Windows user that is specified inside this section (this is the COM+ user)
- Logoff from Windows
- Logon to the Controller application server as the COM+ Windows user
- Open "Control Panel"
- Open "Regional Settings"
- Modify the regional settings (e.g. to English (UK))
- To be sure that the changes have taken place, reboot the Controller application server
- Test.
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21587877