ACF2 Import Errors [LDAP: error code 1 - code 1 (OPERATIONS_ERROR): failed on search operation 'OBJ.T3OPR' is not a column in the target table.

Document ID : KB000117305
Last Modified Date : 10/10/2018
Show Technical Document Details
Issue:
The ACF2 Import Process completes but has errors.

The IG log indicates that the ACF2 import failed because a column(n 'OBJ.T3OPR' ) could not be found.

08:18:41,120 ERROR [com.eurekify.batch.connectors.imports.AbstractEmbeddedClientConnectionLayerImport] (import-connector thread-3) Import Failed!: com.eurekify.command.CommandExecutionException: com.ca.clientconnection.clientapi.ClientConnectionException: com.ca.clientconnection.clientapi.ClientConnectionException: java.util.concurrent.ExecutionException: com.ca.clientconnection.clientapi.ClientConnectionException: com.ca.iam.model.IAMPersistenceException: javax.naming.NamingException: [LDAP: error code 1 - code 1 (OPERATIONS_ERROR): failed on search operation: eTDYNDirectoryName=ACF2,eTNamespaceName=ACF2 ACFESAGE,dc=im,dc=etasa: JCS@prdcaerver01: Acf2AcfesageMetaConnector: Column 'OBJ.T3OPR' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'OBJ.T3OPR' is not a column in the target table.]; remaining name 'eTDYNDirectoryName=ACF2,eTNamespaceName=ACF2 ACFESAGE,dc=im,dc=etasa'
at com.eurekify.command.AbstractCommand.execute(AbstractCommand.java:54) [eurekify-common-14.2.0-SNAPSHOT.jar:]
Resolution:
In the case above, restarting the JCS ACF2 ACFESAGE connector on the Connector Server resolved the problem. The ACF2 Import was successful.