Troubleshooting issues with Atrium Integrator migrated jobs

Use this information to troubleshoot issues with migrated jobs.

To verify jobs with  as input and table as output

1. Open the job in

   Some content is unavailable due to permissions.

   Spoon. For more information about

   Some content is unavailable due to permissions.

   jobs and transformations, see Opening Atrium Integrator job or transformation.
   
2. Double-click the CMDBInput step.
   The CMDBInput dialog box appears.
   
3. Verify the  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  as output

1. Open the job in

   Some content is unavailable due to permissions.

   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

   Some content is unavailable due to permissions.

   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 .

To verify if rules are migrated correctly to

Some content is unavailable due to permissions.

After migrating rules to

Some content is unavailable due to permissions.

, verify if they are migrated correctly. If there are any errors in the migrated rules an error occurs.

1. Open the transformation in

   Some content is unavailable due to permissions.

   Spoon.
2. Double-click the Set Rules step.
3. Click Test Class.

To troubleshoot  data population in table

 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.