The RA Informatica Agent will not start after a v2.0.0 to v3.0.0 upgrade in Applications Manager

Document ID : KB000088643
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message: Details: ORA-20035: Could not find "Db login -" 
 
 Symptoms
After an upgrade from RA Informatica v2.0.0j or above to RA Informatica v3.0.0, the agent fails to start.


 

Cause

There were file transfer options added in special patch v2.0.0j and above, which have been removed in version 3.0.0 to improve performance. If a special patch was applied, the options would have been displayed on the Agent's Informatica tab as shown in the image below.


.png



If a change is made to the Informatica Agent after upgrading to version 3.0.0, the Agent will not start and will display an error similar to the following:



INFO36_80RA:ErrorMsg: AwE-5102 Agent error (11/16/12 5:05 PM) 
Details: java.sql.SQLException: ORA-20035: Could not find "Db login -"
ORA-06512: at "AM80.AWAPI2", line 473
ORA-06512: at "AM80.AWAPI2", line 446
ORA-06512: at "AM80.AWAPI", line 111
ORA-06512: at "AM80.AWAPI", line 1108
ORA-06512: at "AM80.AWAPI", line 1226
ORA-06512: at line 1
Resolution:
To fully remove the added options from the special patch, please perform the following instructions. This is a two step process to remove the FTP login in the client and execute a sql script to update the Agent's XML in the database. After completing these steps, restart the Informatica Agent.

Step One: Removing the FTP login in the AM client (if it exists):
  1. Log in to the Applications Manager Client
  2. Open the Logins Selector Window (Object Admin->Administration->Logins)
  3. Delete ALL of the Informatica FTP logins (if there is more than one).
To display Informatica FTP logins, sort the Description field (click on the column to sort) and find all with FTPConnection-InformaticaAgent as shown in this image. 
.png


Step Two: Updating the Agents' XML
 
  1. Transfer the infa_ftp_migration.sql file to your Master server: infa_ftp_migration.sql
  2. Login to sqlplus as the AM Oracle user and install the migration script by issuing the following:
SQL>@ infa_ftp_migration.sql;

SQL> commit; 

      3. Execute the remove_ftp_ref procedure for either a single agent or all agents to update their XML data.
     
      4. Use one of the following options:

          a. To Remove XML ftp information for a specific Informatica agent where agentname is your Informatica Agent name
              
SQL> execute remove_ftp_ref ('AGENT_NAME');

               SQL> commit;
   
          b.To Remove XML ftp information for all Informatica agents


              SQL>execute remove_ftp_ref (null);

              SQL> commit;

This SQL procedure will print out the Before and After XML update values.

You can verify the Agent's XML data to ensure it has successfully been updated by checking the SO_OPERATORS table to compare what is printed out by the procedure. To do this:

SQL> set long 1000

SQL> select so_xml from so_operators where so_oper_name='AGENT_NAME';

Example entry prior to FTP reference removal:

<data>

 <job

appStatusIntervalTime="5" clientPath="/home/info/Informatica/9.1.0/server/bin"

componentName="InformaticaAgent" connectionTimeout="20"

ftpConnection="dummyinfo" logFileIntervalTime="5" sessionLogMechanism="2"

statusPollingCycle=""/>

 <connection value="dummyinfo" xmlName="ftpConnection"/>

</data>

Example entry after FTP reference removal:

<data>

 <job

appStatusIntervalTime="5" clientPath="/home/info/Informatica/9.1.0/server/bin"

componentName="InformaticaAgent" connectionTimeout="20" logFileIntervalTime="5"

sessionLogMechanism="2" statusPollingCycle=""/>

</data>

After completing these two steps, Restart the Informatica Agent.

Please contact Automic Product Support if you have any questions regarding this issue or the Resolution instructions
 
File Attachments:
000008442.zip