How to fix PeopleSoft connectors that are in a non-deployed state after installing RSA Via Lifecycle and Governance (L&G) 6.9.1 P07
Originally Published: 2015-11-16
Article Number
Applies To
RSA Product/Service Type: Appliance
RSA Version/Condition: 6.9.1 P07
Platform: Linux
Platform (Other): JBoss
O/S Version: SUSE Linux 10
Issue
PeopleSoft connectors are failing after the upgrade to RSA Via L&G 6.9.1 P07. There are many AFX connectors, all of which are green and running with the exception of the PeopleSoft connectors. They are in a red and and in a "Not Deployed" state. DB2 missing files have been uploaded and the 6.9.1 P07 connector templates also uploaded.
Refer to the aveksaServer.log for the errors as shown below:
11/08/2015 13:22:42.550 INFO (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider] Found 12
Connectors to migrate...
11/08/2015 13:23:14.488 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-1-Tst
11/08/2015 13:23:14.908 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider] Unable to
migrate connector AFX-PeopleSoft-1-Tst using migrator
com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:23:33.554 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-2-Tst
11/08/2015 13:23:33.948 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider] Unable to
migrate connector AFX-PeopleSoft-2-Tst using migrator
com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:23:52.878 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-3-Production
11/08/2015 13:23:53.299 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider]
Unable to migrate connector AFX-PeopleSoft-3-Production using
migrator com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:24:11.893 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-4-Development
11/08/2015 13:24:12.309 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider]
Unable to migrate connector AFX-PeopleSoft-4-Development using
migrator com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:24:31.131 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-5-Test
11/08/2015 13:24:31.527 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider]
Unable to migrate connector AFX-PeopleSoft-5-Test using
migrator com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:24:51.029 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-6-Development
11/08/2015 13:24:51.449 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider]
Unable to migrate connector AFX-PeopleSoft-6-Development
using migrator com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:25:10.022 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-7-Production
11/08/2015 13:25:10.439 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider]
Unable to migrate connector AFX-PeopleSoft-7-Production using
migrator com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:25:29.358 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-8-Tst
11/08/2015 13:25:29.772 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider]
Unable to migrate connector AFX-PeopleSoft-8-Tst
using migrator com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:25:48.650 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-9-Production
11/08/2015 13:25:49.068 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider]
Unable to migrate connector AFX-PeopleSoft-9-Production
using migrator com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:26:08.871 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-10-Test
11/08/2015 13:26:09.287 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider]
Unable to migrate connector AFX-PeopleSoft-10-Test using
migrator com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:26:27.989 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-11-Development
11/08/2015 13:26:28.401 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider]
Unable to migrate connector AFX-PeopleSoft-11-Development
using migrator com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:26:47.056 INFO (main) [com.aveksa.afx.common.migration.connector.AbstractConnectorMigrator]
Begining Migrating Connector: AFX-PeopleSoft-12-Test
11/08/2015 13:26:47.691 ERROR (main) [com.aveksa.afx.server.service.AFXMigrationServiceProvider]
Unable to migrate connector AFX-PeopleSoft-12-Test using
migrator com.aveksa.AFX.connector.database.migration.DatabaseMigrator
11/08/2015 13:26:47.697 INFO (main) [com.aveksa.afx.common.packagemgmt.repository.RepositoryManager]
Initializing
11/08/2015 13:26:47.698 INFO (main) [com.aveksa.afx.common.packagemgmt.repository.RepositoryManager]
Check for Package Updates
11/08/2015 13:26:47.699 WARN (main) [com.aveksa.afx.common.packagemgmt.repository.RepositoryManager]
Could_Not_Find_Connector_Repository #set this to a directory from which to install connector packages
11/08/2015 13:26:47.708 INFO (main) [com.aveksa.afx.common.service.AFXBaseService] Service
[AFX Fulfillment Service]: service Started
Resolution
The connectors (i. e., conn_name.AFX.xml) were modified to have the db2 driver entry (com.ibm.db2.jcc.DB2Driver) but the template didn't have that entry. So the migration fails and the connectors are not in the deployed state.
The following steps are provided to modify the database connector template and introduce that db2 (com.ibm.db2.jcc.DB2Driver) driver entry, which resolves the issue.
1. Export the 'Database' connector template.
2. Export the twelve connectors, including the ones that are not working.
3. Make a backup of the ConnectorType.xml.
4. Open the ConnectorType.xml of the template exported above, which is present inside the CONNECTOR_TYPE folder of the downloaded template's zip.
5. Add the following:
Property_Driver
In the Property_Driver section, add the following lines, as in the screenshot below:
<entry> <key>com.ibm.db2.jcc.DB2Driver</key> <value>DB2 - com.ibm.db2.jcc.DB2Driver</value> </entry>
Property_JdbcUrl
In the Property_JdbcUrl section, add the following lines, as in the screenshot below:
<entry> <key>com.ibm.db2.jcc.DB2Driver</key> <value>jdbc:db2://[host]:[port]/[database]</value> </entry>
6. Save the modified ConnectorType.xml.
7. Import this modified template again to the Aveksa system.
8. After the successful import of this template, all twelve connectors of PeopleSoft can be imported.
9. After the connectors are imported successfully, they should go in the running state this time.
Notes
