Troubleshooting data transfer issues

When you encounter issues while transferring data in Atrium Integrator, use this information to resolve the issue.

To create data store connection with an Oracle service name

Prefix your database name with slash (/) when you open the database connection in Atrium Integrator Console.

Alternatively, you can perform the following steps:

1. Create a new data store connection for Oracle database in Atrium Integrator Spoon.  
2. To work with SERVICE_NAME instead of Oracle SID:
   • In the Access list, select Native (JDBC).
   • Leave the Host Name field and the Port Number field blank.
   • Enter service description in the Database Name field.
     For example, 
     (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PRIMARY_NODE_HOSTNAME)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=SECONDARY_NODE_HOSTNAME)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=DATABASE_SERVICENAME)))
3. Enter DB Username and Password. 
4. Click OK. 

To troubleshoot data population on a remote Atrium Integrator carte server

CSV or XML data may not get populated with remote Atrium Integrator carte server due to the following reasons:

• Job_FileMetaLoader is not started. To troubleshoot, see Troubleshooting-jobs-running-in-the-Atrium-Integrator-console. 
• Source files are not present on the configured server.