Previous Topic Next topic Print topic


Compare Data Tool Error Messages

This topic describes the error messages that are related to the Compare Data tool.

Error Message Description or Cause Resolution
A shared task cannot have a local transfer list A shared task must associate a shared transfer list. Make sure the shared radio button is checked for the transfer list.
Build Query failed Build customized query by OpenESQL failed. Make sure the source database connection is still open.
Command file is invalid or was not found The file does not exist in the specified folder; or the file contains syntax errors. Make sure the file exists and has correct syntax in its content.
Compare list file is empty Compare list file has no meaningful content. Add the desired content to the file.
Connection failed Connection to either source database or destination database failed. Make sure the user ID and password are correct.
Data comparison terminated for this table, error count exceeds mismatch limit Error count exceeds the mismatch limit. Check the mismatch errors to figure out which table causes the failure.
Data comparison test FAILED! Data comparison test failed due to unmatched rows or columns. Make sure the data in both source table and destination table are of the same set.
Data for following column does not match The values of data in the two databases do not match. Check if the data tables contain the same set of data in terms of rows, columns and ordering
Error in writing to file Error in writing a task to XML file. Check task name or path for illegal characters.
Execution Error Execution of compare data failed due to connection failure. Check database connections.
File Access Violation Either READ or WRITE permission is not granted to the user. Depending on the security policy of the organization, the resolution can be either Run as Administrator or Grant the user file access.
Following required parameter is missing A required command line parameter is missing. Provide the required parameter.
Invalid command line parameter The specified parameter value is empty or out of range. Assign a proper value to the parameter.
Invalid command line syntax Some parameter names are incorrect. Use the correct parameter names.
Invalid Data Source Name The name of the data source or data destination is empty. Add the name of the data source or data destination to the command line argument.
Invalid number of arguments The command line has no arguments. Add the required arguments to the command line.
Invalid target object list The XML target list file has syntax errors. Check the target list file content or try regenerating the target list.
No task name is set No task name is set on GUI. Select the desired task name on GUI.
Number of result set columns do not match The number of table columns in the destination database does not match the corresponding one in the source database. Check the DDL generation script.
Number of result set rows do not match The number of rows in the destination table does not match that in the source table. Rerun the Transfer Data tool.
Query Failed = … Execution of the query failed. Check query syntax, database connection, and database access permission.
The destination DSN is not found The destination DSN is not set or it is not defined. Specify an existing connection or create one if the connection you want to use does not exist.
The process does not have the READ permission to the file The process does not have READ permission to the specific file. Depending on the security policy of the organization, the resolution can be either Run as Administrator or Grant the user READ permission.
The process does not have the WRITE permission to the file The process does not have WRITE permission to the specific file. Depending on the security policy of the organization, the resolution can be either Run as Administrator or Grant the user WRITE permission.
The source DSN is not found The source DSN is not set, or it is not defined. Set the source DSN or create one if it does not exist.
The transfer list is not found in the directory The transfer task file does not exist in the specified path. Make sure the specified file exists in the path; or the file name is correct.
Unable to read list file The transfer list file is corrupted. Check the file content for syntax errors.
Previous Topic Next topic Print topic