You can view the number of rows that failed to load into the target when you view the details for a job. For more information about the reason for each failure, view the error rows file.
To view job details, in Data Integration, select My Jobs and then click the job name. You can also view job details in Monitor on the All Jobs or Running Jobs page.
You can find the error rows files in the following directory:
If a job does not complete, you can stop the job on the All Jobs, Running Jobs, or My Jobs page.
Task errors
My task failed to complete and the following message appears in the job details:
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 job details:
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 job details:
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!
The role to which you are assigned might not have privileges to read this type of task, or you might not have Read permission for the task. To view task details, you must be assigned a role that has Read privilege for the task type. If permissions are set for the task, you also need Read permission for the task. Ask your organization administrator for the appropriate privileges and permissions.
I can view task details, but I cannot edit a task.
The role to which you are assigned might not have privileges to update this type of task, or you might not have Update permission for the task. To edit a task, you need to be assigned a role that has Update privilege for the task type and Read privilege for all asset types used in the task. If permissions are set for the task, you need Update and Read permissions for the task. If permissions are set for any of the assets in the task, you also need Read permission for the assets. Ask your organization administrator for the appropriate privileges and permissions.
When I edit a task, one of the connections displays a blank field instead of the connection name.
The role to which you are assigned might not have the Read privilege for connections, or you might not have Read permission for the connection. When you edit a task, you should have Read privileges for all asset types used in the task. If permissions are set for assets in the task, you should also have read permission for the assets. To avoid unexpected results, cancel all changes and ask your organization administrator for the appropriate privileges and 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.
The role to which you are assigned might not have the Read privilege for connections, or you might not have Read permission for the connection. When you create a task, you need Read privileges for all asset types that you want to use in the task. If permissions are set for the assets you want to use, you also need Read permission for the assets. Ask your organization administrator for the appropriate privileges and permissions.
The following error appears:
Unknown SQL datatype for field [<Object name.Field name>]. [<Number that represents the datatype>]
Data Integration does not recognize the data type of a source or target field.