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