Troubleshooting issues with Atrium Integrator migrated jobs

Use this information to troubleshoot issues with migrated jobs.

To verify jobs with BMC CMDB as input and table as output

1. Open the job in Atrium Integrator Spoon. For more information about Atrium Integrator jobs and transformations, see Opening Atrium Integrator job or transformation.
   
2. Double-click the CMDBInput step.
   The CMDBInput dialog box appears.
   
3. Verify the BMC CMDB input details.
4. Click OK.
5. Double-click the InsertUpdate step.
   The Insert/Update dialog box appears.
6. Verify if the fields in the The key(s) lookup the value(s) table are listed accurately in the Updatefields table and the Tablefield and Streamfield mapping is set to Yes.
7. Click OK.
8. Double-click the User Defined Java Class step.
   The User Defined Java Class dialog box appears.
9. Verify if the rules are migrated correctly.
   1. Double-click the Set Rules step.
   2. Click Test Class.
      If there are any errors in the migrated rules an error occurs.
10. Click OK.
11. Save and run the job.
12. Verify the job details in the target database table.

To verify jobs with table as input and BMC CMDB as output

1. Open the job in Atrium Integrator Spoon. For more information, see Opening Atrium Integrator job or transformation.
   
2. Double-click the Table Source step.
   The Table input dialog box appears.
   
3. Click Edit and verify:
   • Target database name: Source DB name
   • User: Source DB user
4. Click OK.
5. Double-click the Add constants step.
   The Add constant values dialog box is displayed.
   
6. Verify the constant values.
7. Click OK.
8. Double-click the CMDBOutput step.
   The CMDBOutput dialog box appears.
   
9. Verify the Atrium Integrator output details.
10. Click Edit and verify:
    • AR System server name
    • TCP Port
11. Click OK.
12. (Optional ) If the job contains rules, verify if the rules are migrated properly.
    See Verifying rules after migration to Atrium Integrator.
13. Run the job.
14. Verify the job details in BMC CMDB.

To verify if rules are migrated correctly to Atrium Integrator

After migrating rules to Atrium Integrator, verify if they are migrated correctly. If there are any errors in the migrated rules an error occurs.

1. Open the transformation in Atrium Integrator Spoon.
2. Double-click the Set Rules step.
3. Click Test Class.

To troubleshoot Remedy AR System data population in table

Remedy AR System data is not populated into the table if the mapping between the AR Input step and the Table output step fails.

1. Open the transformation.
2. Double-click the Table output step.
3. In Table Output dialog box, select the Specify Database fields option.
4. Click OK.
5. Save and run the transformation.

To troubleshoot issues with erroneous brackets at start of data

This issue is specific to Microsoft SQL server. 

1. Log in to the Microsoft SQL server.
2. Set the SET CONCAT_NULL_YIELDS_NULL option to OFF.
3. Run the job again.