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. |