Best answers and resolutions to the most common questions about Atrium Integrator.

Q. What are the best practices to ensure the successfully operation with Atrium Integrator?
A. See Best Practices when Configuring Atrium Integrator

Q. What are the best practices to ensure the best performance of Atrium Integrator?
A. See Improving the performance of Atrium Integrator

Q. How can I investigate performance issues with the Atrium Integrator console?
A.  See Performance Issues when using the Atrium Integrator console.

Q. What can I do if Atrium Integrator scheduled jobs are not running as expected?
A.  See Atrium Integrator Troubleshooting Job Schedules

Q. How can I resolve java memory issues when running Atrium Integrator jobs?
A. See Increasing Java heap for Atrium Integrator

Q. Atrium Integrator Spoon does not load after Java is updated.  How do I update Java used by the diserver (carte) and the Spoon client?  
A. See How to update Java for Carte and Spoon on AR Server systems when AI stops working after Java upgrade

Q. After copying/refreshing the ARSystem database from another system, the AI jobs no longer work. How do I resolve issues when AI jobs are not working after the database is refreshed?
A. See Atrium Integrator Jobs Do Not Work After A DB Refresh

Q. I see this error when the DB step tries to connect:
Error connecting to database: (using class com.microsoft.sqlserver.jdbc.SQLServerDriver) The TCP/IP connection to the host DBHost, port 1433 has failed. 
How do I resolve MSSQL database connection errors?
A. See Atrium Integrator/Spoon: MS-SQL DB Connection error

Q. How do I resolve issues when transformations cannot open when they include CMDB related steps?
For example I see this error:
Error creating dialog Unable to create a dialog for step com.bmc.atrium.ngie.cmdbinput.CMDBInputDialog /org/ai/cmdb/utils/CMDBUtils
A. See Spoon Client missing CMDB steps

Q. How do I configure the checksum?
A. See Configuring the checksum value for loading data into BMC Helix CMDB

Q. How to migrate AI Jobs between environments

A. How to migrate Atrium Integrator (AI) jobs between environments (Dev <--> QA <--> Prod)

Q. How to address common issues post-upgrade to 23.3.04 Pentaho 9

A. Common issues addressed Post Upgrade - 23.3.04 Pentaho 9

Background: BMC Customer Support analyses case trends to identify topics that are trending with customers, the resources we share most often to assist them, and how we can improve them. This Best FAQ article provides links to the resources and shares resources most recommended by BMC Customer Support on the topic.

Currently BMC Helix CMDB version 25.1.01 and March 2025