Skip to main content
Kofax

ORA-03137: malformed TTC packet from client rejected Incorrect Database Version error during project database upgrade

Article # 3033834 - Page views: 3273

3033834

Question / Problem: 

This error displays after upgrading Insight and attempting to upgrade a project (including Kofax Analytics products).

Answer / Solution: 

  • This issue can occur if ODP.Net is lower than 19c on the Insight server. Only the 64-bit ODP.Net provider is required.
  • As documented in Insight's Installation Guide for v6.3 and newer, use ODP.Net 19c driver for Oracle 19c installations and follow the steps documented to register the library at the machine level. 
  • ODP.Net is the only component required for Insight - do not install the entire ODAC package, rather, select just ODP.Net from the list of options.
  • It is also advised to remove older drivers and confirming the un-install of 32- and 64-bit ODP.Net libraries from .Net's Global Assembly Cache (GAC).
    • This can be done by searching as follows from an administrative CMD prompt in the Windows directory:  DIR Oracle.DataAcccess*.dll /s /p
  • The common symptom in this case is an error when attempting to upgrade the project database from Admin or Studio:  "Project <ProjectName> is the incorrect database version"
  • NOTE: 
    • Oracle registers their ODP.Net drivers for both 64 and 32 bit using the same public key token.
    • We have seen cases where Insight server's C:\Windows\Microsoft.NET\assembly\GAC_32 and GAC_64 folders both had Oracle.DataAccess folders with the same keys.
    • If this happens, you may need to remove all providers, including 19c and load just 12c ODP.Net 64.bit.
      • Doing that may lead to the ora-03137 malformed packet errors.
    • After removing 12c 64bit and going to 19c 64 bit, you may see object reference errors that could be caused by a missing tnsnames.ora file.
      • Once that created, you would be able to log into admin, update the KAMV project meta and data databases OK.

 

Applies to:  

Product Version
Insight

6.3

6.4

 

  • Was this article helpful?