IBM Support

Error 'Server was unable to process request...type mismatch' when importing into a database

Troubleshooting


Problem

Error encountered when importing structure that include accounts/forms.

Symptom

Screen message:
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException (0x800A000D): Type mismatch
at FrTransferBT.ImportStructuresTClass.UpdateImpServer(String sGuid, String sUser, String sXmlDoc)
at Cognos.Controller.Proxy.CCRWS.ImportStructuresT_UpdateImpServer(String sGuid, String sUser, String sXmlDoc)

Event viewer log:
The VB Application identified by the event source logged this Application FrTransferBT: Thread ID: 5780 ,Logged: Error occured at 10/2/2007 11:34:05 AM in FrTransferBT, Error No=-2147217873, Source=ClearImp;FrTransferBT.ImportStructuresT.UpdateImp, Description=ORA-00001: unique constraint (ABSCBN2.NC_XFDLINECOL) violated, HelpFile= HelpContext=0

Cause

TIP: There are several different possible causes for the 'type mismatch' error - see separate IBM Technote 1348020 for more scenarios.

This Technote specifically deals with the scenario where the cause is a third party (non-IBM) bug in the original version of the Oracle 10G release 2 (rel2) client, which is installed on the Controller application server..

  • Specifically, the problem is with the Oracle 'Oracle OLE DB' DLL component.
  • For more details, see (3rd party) Oracle article 'Doc ID/Note #369814.1' titled 'Invalid data for type 'numeric' when Executing a Query against a Linked Server with SQL Server 2005'.

NOTE:
  • This bug causes corrupt data when exporting data from an Oracle database into a file.
    • Therefore it is possible to get this error if importing data into a Microsoft SQL database if the data has previously been exported from a 'bad' Oracle system.

Environment

The structures either came from, or are being imported into a Controller database repository stored inside Oracle database, with the Controller application server having Oracle 10G (not 9i) client installed.

In other words, you will receive this error message if either (or both) of the following Controller application servers have not been patched:

  1. The Application server which was used to originally *export* the structures (source)
  2. and/or the Application server which was used to *import* the structures into (target)

Therefore, you may need to apply this patch on more than one application server!

Resolving The Problem

Upgrade/patch the Oracle 10G rel2 client on the Controller application server, and then re-perform the data/structure export.

TIP:

  • The specific module that must be upgraded is the Oracle Provider for OLE DB, which must be upgraded to version 10.2.0.2.20 or higher
    • For example, use Oracle patch number 5473334 to download the 10.2.0.2.20 32-bit version.
  • This can be downloaded from Oracle's Metalink website: http://metalink.oracle.com

Steps:
Either:
  • Follow the instructions provided by the 3rd party vendor (Oracle).
  • Alternatively, follow the instructions inside the Cognos 'Proven Practice' document 'Step-by-Step guide to installing Oracle 10G Client on a Controller 8.3 Application server'.
  • TIP: For more details, see separate IBM Technote 1361692 here: http://www-01.ibm.com/support/docview.wss?uid=swg21361692

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5.1;8.5;8.4;8.3","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1036613

Document Information

Modified date:
15 June 2018

UID

swg21347434

Page Feedback