Data Importer services doesnt start post ITAM upgrade from 14.1 to 17.3

Products

• CA IT Asset Manager Asset Portfolio Management

Issue/Introduction

CA Asset Portfolio Management - Data Importer Engine  Services doesnt start post ITAM upgrade from 14.1 to 17.3 

 

Error Message : 
============
2021-04-17 18:46:03,026 UTC [ImportMgr] INFO  CA.Applications.DataImporterEngine.ImportServiceManager - ..Initializing Web Server [HTTP://SERVERNAME:99/ITAMService/Service.asmx] access for Import Service
2021-04-17 18:46:03,136 UTC [ImportMgr] INFO  CA.Applications.DataImporterEngine.ImportServiceManager - ..Initializing Storage Manager Server [HTTP://SERVERNAME:99/SMService/Service.asmx] access for Import Service
2021-04-17 18:46:03,136 UTC [ImportMgr] ERROR CA.Applications.DataImporterEngine.ImportServiceManager - An error occurred while accessing the Storage Manager Server:{0}System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
   at System.Net.HttpWebRequest.GetResponse()
   at CA.Applications.DataImporterEngine.ImportServiceManager.IsSMServiceUp(String serviceUrl)
2021-04-17 18:46:03,136 UTC [ImportMgr] FATAL CA.Applications.DataImporterEngine.ImportServiceManager - Import Service aborted due to errors.  Review previous error messages for details.
[Footer]

 

Environment

Release : 17.3

Component : ARGIS (WEB VERSION)

Resolution

Edit web.config  Location: C:\Program Files (x86)\CA\ITAM\Storage Manager Service

# Command the oracle client code :
From
<add assembly="System.Data.OracleClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
To
<!--<add assembly="System.Data.OracleClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>-->

# Remove this below section of code : 
<DbProviderFactories>
      <!-- Remove in case this is already defined in machine.config -->      
      <remove invariant="Oracle.ManagedDataAccess.Client"/>
      <add name="Oracle Data Provider for .NET" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
    <remove/><add/></DbProviderFactories>
  <DbProviderFactories/></system.data>

# Restart IIS :  IISReset.