Skip to Content

Troubleshooting Atrium Integrator Spoon issues

The following topics provide information for resolving some common Atrium Integrator Spoon issues:

To run Atrium Integrator jobs created in Windows on Unix and Solaris

If you create a job by using Microsoft Windows OS with target connection as the localhost, the job will not run on UNIX or Oracle Solaris because neither of these platforms support the localhost command.

  1. Open the migrated job.
  2. Replace the localhost server name with the actual server name.
  3. Run the job.

Related topics

Triggering jobs to import data into BMC Atrium CMDB

User-interface-overview

Creating-a-job-in-Atrium-Integrator-Spoon

To run XML or CSV jobs created in UNIX or Solaris on Windows

You cannot run XML or CSV jobs that were created on UNIX or Oracle Solaris directly on Atrium Integrator Spoon Windows client.

  1. Copy the XML or the CSV files from UNIX or Solaris to the computer where the Atrium Integrator Spoon Windows client is installed.
  2. Open the job on Atrium Integrator Spoon Windows client.
  3. Update the new file path.
  4. Save and run the job.
Warning

Note

The default behavior of Atrium Integrator Spoon Windows client is to run the job locally. But, you can indicate Atrium Integrator Spoon Windows client to run the job remotely. This error should not occur, if you run the job remotely.

To fix error connecting to a Microsoft SQL Server database using Windows Authentication

On a 32-bit JVM, Windows Authentication when connecting to a Microsoft SQL Server in Atrium Integrator Spoon works correctly. But, Windows Authentication displays an error on a 64-bit JVM. For more information, see MSSQL connectivity.

Use the following steps to fix the error:

  1. Navigate to the following directory: 
    <ARSystemInstallationDirectory\diserver\data-integration\libswt\win32>
  2. Rename the ntlmauth.dll file as ntlmauth_32.dll.
  3. Navigate to the following URL: 
    http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zip/download
  4. Download the jtds-1.2.5-dist.zip file and unzip it.
  5. Copy the jtds-1.2.5-dist\x64\SSO\ntlmauth.dll file to the following directory: 
    ARSystemInstallationDirectory\diserver\data-integration\libswt\win32
  6. Close the Atrium Integrator Spoon window.
  7. Launch Atrium Integrator Spoon.
  8. Open your job or transformation.
  9. Double-click Table input.
  10. Click New (next to the Connection field).
  11. In the Database Connection dialog box (General tab), specify appropriate values for the following fields:
    • Connection Name
    • Host Name
    • Database Name
    • Port Number
  12. Select the Options tab.
  13. In the Parameter column, enter domain and in the Value column, enter the domain of the database server.
  14. Click Test to ensure that the database connection is valid.
  15. Click OK.

To view the job run history in the Atrium Integrator console

  1. Open the job in Atrium Integrator Spoon.
  2. Click Edit > Settings. The Job Properties dialog box is displayed. 
  3. Click the Log tab. 
  4. Click Job. 
  5. Enter the <AR server name> in the Log Connection field. 
  6. Enter UDM:JobLog form name in the Log table field.
  7. Click Job Entry. 
  8. Enter the <AR server name> in the Log Connection field. 
  9. Enter UDM:JobEntryLog form name in the Log table field.
  10. Click OK. 

To view the transformation run history in Atrium Integrator console

  1. Open the transformation in Atrium Integrator Spoon.
  2. Click Edit > Settings. The Transformation Properties dialog box is displayed. 
  3. Click the Logging tab. 
  4. Select Transformation. 
  5. Enter the <AR server name> in the Log Connection field. 
  6. Enter UDM:TransformationLog form name in the Log table field.
  7. Click Step. 
  8. Enter the <AR server name> in the Log Connection field. 
  9. Enter UDM:StepLog form name in the Log table field.
  10. Click OK.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Helix CMDB 25.2