4 Testing and Troubleshooting

After you deploy the connector, you must test it to ensure that it functions as expected. This chapter discusses the following topics related to connector testing:

• Testing the Connector

• Troubleshooting

Testing the Connector

You can use the testing utility to identify the cause of problems associated with connecting to the target system and performing basic operations on the target system.

To use the testing utility:

1. Open a command window, and change to the OIM_home\xellerate\JavaTasks directory in which the dbadapter.jar file is stored.

2. Run the following command:

   java -jar dbadapter.jar
   
   

3. Select the test that you want to run.

4. Depending on the test that you select, you are prompted to enter the required information as shown in the following table.

   Test	Required Information
   Create a user	User ID First name Last name . . . (All other information that is required to create a user account)
   Update a user attribute	User ID Attribute name Attribute value
   Delete a user	User ID

   
   

   If you select the test to update a user, then you can specify any one of the following as the user attribute name:

   • xel_usr_first_name

   • xel_usr_last_name

   • xel_usr_password

   • xel_usr_group

   • xel_usr_group

   • xel_usr_role

   • xel_usr_title

   • xel_usr_dept

   • xel_usr_email

   • xel_usr_comm_lang

   • xel_usr_logon_lang

   • xel_usr_tel_no

   • xel_usr_time_zone

   • xel_usr_date_fmt

   • xel_usr_dec_ntn

5. Check if the required action has been successfully carried out.

Troubleshooting

The following table provides solutions to some commonly encountered issues associated with this connector.

Problem Description	Returned Error Code	Solution
Oracle Identity Manager cannot establish a connection with the target database.	DATABASE CONNECTION FAILED	Ensure that the drivers of the database are specified in the CLASSPATH environment variable of the Oracle Identity Manager server. Ensure that Oracle Identity Manager is running. Ensure that all the adapters have been compiled. Use the IT Resources form to examine the Oracle Identity Manager record. Ensure that the IP address, administrator ID, and administrator password are correct.
	DATABASE DRIVER NOT LOADED	Ensure that the database driver is available in the CLASSPATH environment variable of the Oracle Identity Manager server.
A provisioning operation fails with an error code other than those described in the following rows.	CONFIGURATION ERROR	Ensure that the configuration XML file given in the IT resource definition exists at the specified file system path. Ensure that the XML schema file exists at the location specified in the configuration XML file. Ensure that the configuration XML file adheres to the XML schema specified inside the file itself.
	DATA SIZE MISMATCH	Ensure that the data size of the user profile attributes in the configuration XML file adheres to the process form limitations.
	MANDATORY FIELD MISSING	Ensure that values are provided for all user attributes specified as required in the configuration XML file. This error is thrown even if a blank string is provided. Ensure that the process form includes the fields marked as required in the configuration XML file.
	DATABASE OPERATION FAILED	Ensure that the maximum size of user profile attributes given in the configuration XML file matches the size defined in the actual database schema. Ensure that all the mandatory fields of the database table are marked as required in the configuration XML file.
Create User provisioning operation fails	USER ALREADY EXISTS	Check if the target database table already has a record with the same user ID (or a combination of whichever primary key fields exist for the table).
Create User or Reset Password provisioning operation fails	ENCRYPTION INTERFACE MISSING	Check if password encryption is set to true in the configuration XML file. Ensure that the encryption interface implementation class is available in the CLASSPATH environment variable of the Oracle Identity Manager server.
	ENCRYPT/DECRYPT ERROR	This error occurs if an exception is thrown from the encryption implementation class. Check if the encryption implementation class is working correctly. Check the logs for a description of the error and stack trace.
Update Any User Profile Attribute, Delete a User, or Revoke a Provisioned Resource Object from a User provisioning operation fails	USER DOES NOT EXIST	Check if the record for the user exists in the target database tables.