Troubleshooting a Task
The activity monitor and activity log show the number of rows that failed to load into the target. For more information about the reason for each failure, view the error rows file.
You can find the error rows files in the following directory:
<Secure Agent installation directory>\apps\Data_Integration_Server\data\error
If a task or task flow does not complete, you can click the Stop Job option in the activity monitor.
Task Errors
- My task failed to complete and the following message appears in the Activity Log:
DTM process killed for workflow [wf_dss_<workflow id>] session [s_dss_<session id>] because agent is shutdown.
The Secure Agent that was running the task was stopped or restarted while the task was in progress.
- My tasks are failing after I installed a 64-bit Secure Agent on Windows. The following message appears in the Activity Log:
Failed to run job because of missing VC++ libraries on the machine that runs the Secure Agent.
The Secure Agent machine that runs the task is missing the MSVCR.DLL files. Install the Microsoft Visual C++ 2008 Redistributable Package (x86) on the Secure Agent machine.
- My task failed to complete and the following message appears in the Activity Log:
The DTM process failed to start due to [CreateProcess error=14001, The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail]. 'Failed to run job because of missing VC++ libraries on the machine that runs the Secure Agent'
The Secure Agent machine that runs the task is installed on a Windows 2008 machine that is not correctly configured. Install the Microsoft Visual C++ 2008 Redistributable Package (x86) on the Windows 2008 machine.
- I need to review details for a task, but I can't find the task anywhere!
You do not have read permission for the task. You need read permission to view task details. Ask your organization administrator for the appropriate permissions.
- I can view task details, but I cannot edit a task.
You do not have update permission for the task. To edit a task, you need read and update permission for the task, and you need read permission for all objects used in the task. Ask your organization administrator for the appropriate permissions.
- When I edit a task, one of the connections displays a blank field instead of the connection name.
You do not have read permission for the connection. To edit a task, you should have read permission for all objects used in the task. To avoid unexpected results, cancel all changes and ask your organization administrator for the appropriate permissions.
After you cancel out of the wizard, you can view the task details to determine the names of the objects for which you need permissions.
- When creating a task, the connection that I want to use does not appear in the list of available connections.
You do not have read permission for the connection. You need read permission on all Informatica Cloud objects that you want to use in a task or task flow. Ask your organization administrator for the appropriate permissions.
- The following error appears:
Unknown SQL datatype for field [<Object name.Field name>]. [<Number that represents the datatype>]
Informatica Cloud does not recognize the datatype of a source or target field.