Troubleshooting¶
This section contains a list of troubleshooting steps and solutions for issues encountered while using DSC.
The table lists the troubleshooting symptoms/issues along with their cause and solution.
Symptom/Issue | Cause and Solution |
---|---|
Error occurred while formatting! Returning unformatted SQL: SELECT count( | Cause: This could be due to inconsistency in the number of opening and closing parentheses in the input file. Solution: Ensure each opening parenthesis has a corresponding closing parenthesis. |
ERROR QueryConversionUtility:249 Query is not converted as it contains unsupported keyword: LAST | Cause: Input query file contains an unsupported keyword. Solution: Ensure no unsupported keywords are present in the scripts to be migrated. |
Disk is almost full. Please clear the space and re-run the tool. | Cause: Insufficient space on the disk. Solution: Free space from the disk and retry the operation. |
Please enter valid input parameters, Kindly refer the user manual to execute. | Cause: The possible cause could be:
Solutions:
. |
No SQL files found in input folder. Hence stopping migration. | Cause: No valid SQL files are present in the input folder during the migration process. Solution: Ensure SQL files to be migrated are present in the input folder. For details, see Migration Process. |
Migration Application failed to start : Currently we are not supporting this Database : <database-name> | Cause: Incorrect database name mentioned in the source database parameter. Solution: Use only Teradata or Oracle as values to the source database parameter. |
Output folder is not set. Please enter an output folder and refer the user manual for syntax. | Cause: The output folder path is not specified. Solution: Specify a valid path for the output folder parameter. |
java.lang.OutOfMemoryError: GC overhead limit exceeded. | Cause: During migration, if the memory usage exceeds the preset value, DSC displays the error message and exits. Solution: Change the values of initialJVMMemory and maxJVMMemory in the application.properties configuration file to allocate more memory. |
ascii " | Cause: DSC cannot detect the encoding format of the file input, and the character set configured in the system does not match that of the file input. As a result, an alarm is reported. Solution: Set encodingFormat to the actual encoding format and try again. Example: testmigration@BLR1000026522:~/18.1_RETEST/DSC/scripts/teradata> perl sqlTDtoGS.pl -i ../../PERL -o ../../PERL_OUT/ -m /home/testmigration/18.1_FORMAT_RETEST/sep6thpackage/DSC
Extracting SQL contents from perl files started
ascii "\xFF" does not map to Unicode at core/teradatacore.pm line 1270.
ascii "\xFE" does not map to Unicode at core/teradatacore.pm line 1270.
ascii "\xFE" does not map to Unicode at core/teradatacore.pm line 1270.
ascii "\xFF" does not map to Unicode at core/teradatacore.pm line 1270.
Extracting SQL contents from perl files completed
********************** Schema Conversion Started **********************
DSC process start time : Mon Jan 20 17:24:49 IST 2020
Statement count progress 100% completed [FILE(1/1)]
Schema Conversion Progress 100% completed
**************************************************************************
Total number of files in input folder : 1
**************************************************************************
Log file path :....../DSC/DSC/log/dsc.log
DSC process end time : Mon Jan 20 17:24:49 IST 2020
DSC total process time : 0 seconds
********************* Schema Conversion Completed ************************
|
Error codes¶
Error Code | Error Information |
---|---|
Teradata | |
DSC_ERR_003_001 | Query/statement is not supported since the Teradata view "dbc.indices" is supported only for the indextype P and Q. |
DSC_ERR_003_002 | Error in Bteq processing. Something went wrong while processing the BTEQ commands. |
DSC_ERR_003_003 | Query/statement is not supported in ddl DSC. Please check the same and refer user manual for the supported feature list. |
DSC_ERR_003_004 | Unsupported format decimal format like ZZZ99Z, ZZZ.ZZ9 |
DSC_ERR_003_005 | The tool does not support the "IN/NOT IN to EXISTS/NOT EXISTS conversion" for the query in which its outer query refers multiple tables and the column(s) specified with IN / NOT IN operator do not have table reference. |
DSC_ERR_003_006 | The tool does not support the query in which its outer query refers multiple tables and the column(s) specified with IN / NOT IN operator do not have table reference. |
DSC_ERR_003_007 | Primary Index without column is not supported. |
DSC_ERR_003_008 | TeradataQuerySplitter config file contains list is not supported |
DSC_ERR_003_009 | Gauss does not support WITH CHECK OPTION in CREATE VIEW. Please enable the config_param tdMigrateVIEWCHECKOPTION to comment the WITH CHECK OPTION syntax in the statement. |
DSC_ERR_003_010 | Gauss does not have an equivalent syntax for CHARACTER SET & CASE SPECIFIC option in column-level. Please enable the config_param tdMigrateCharsetCase to comment the CHARACTER SET & CASE SPECIFIC option syntax in the statement. |
DSC_ERR_003_011 | Gauss does not have equivalent syntax for LOCK option in CREATE VIEW and INSERT statement. You can rewrite this statement or set the configuration parameter tdMigrateLOCKOption to TRUE to comment the LOCK syntax in this statement. |
DSC_ERR_003_012 | Invalid width (Number of rows) parameter in MDIFF function |
DSC_ERR_003_013 | First 2 parameters should be present in MDIFF function |
DSC_ERR_003_014 | Query/statement is not supported as ORDER BY clause is not present in TOP WITH TIES. Please check the same and refer user manual. |
DSC_ERR_003_015 | Column mismatch for the TITLE conversion. |
DSC_ERR_003_016 | Query/statement is not supported as same Table alias is addressed in both inner and outer query. Please check the same and refer user manual for the supported feature list. |
DSC_ERR_003_017 | Sub query list does not have columns. |
DSC_ERR_003_018 | Number of expressions specified in the outer query does not match with inner query. |
DSC_ERR_003_019 | Error while loading the .RUN FILE from given location. |
DSC_ERR_003_020 | Unable to delete the file, file not found. |
DSC_ERR_003_021 | Unable to delete the file, failed with IOEXception |
DSC_ERR_003_022 | Please specify the value for enviroment_file_path parameter in features-teradata.properties |
Application | |
DSC_ERR_004_001 | Application has timed out, exceeded the hours specified in the config file. Please configure the Timeout parameter in the application.properties to higher value. |
DSC_ERR_004_002 | Error while loading the property files from config directory. |
DSC_ERR_004_003 | Error while loading the property files from config directory, directory is not readable. |
DSC_ERR_004_004 | Error while loading the property file. |
DSC_ERR_004_005 | Unable to load the JSON file. |
DSC_ERR_004_006 | DSC tool does not support this Conversion type provided. |
DSC_ERR_004_007 | Error occurred while framing output replacement query. |
DSC_ERR_004_008 | Invalid index value while parsing the script. |
DSC_ERR_004_009 | Error in conversion process, unable to convert the script. |
DSC_ERR_004_010 | No SQL files found in the input directory with the extension specified in the fileExtension property in application.properties. |
DSC_ERR_004_011 | The query length parameter (MaxSqlLen) value is not valid. |
DSC_ERR_004_012 | Since the input folder has write privileges to Group and/or Others, process is stopped due to security reason. |
DSC_ERR_004_013 | Since the output directory has write privileges to Group and/or Others, process is stopped due to security reason. |
DSC_ERR_004_014 | Disk is almost full. Please clear the space and re-run the tool. |
DSC_ERR_004_015 | DSC has been cancelled as configured by the user. |
DSC_ERR_004_016 | Error occurred while formatting the sql scripts. |
DSC_ERR_004_017 | Invalid index specified for fetching the element from list while formatting the scripts |
DSC_ERR_004_018 | Error occurred while converting from string to integer. |
DSC_ERR_004_019 | Input File is modified while DSC is in progress. |
DSC_ERR_004_020 | Process is null, unable to read encoding format. |
DSC_ERR_004_021 | Target File does not have write permissions. |
DSC_ERR_004_022 | The target directory does not have write privileges to Group and/or Others, process is stopped due to security reason. |
DSC_ERR_004_023 | PL/SQL object contains incorrect DDL/Query. Please check the script for the query position specified in the log. |
DSC_ERR_004_024 | PreQueryValidation failed due to bracket mismatch or invalid terminator. |
DSC_ERR_004_025 | Conversion task name is not valid. |
DSC_ERR_004_026 | Database entered by the user is not supported by the DSC tool. |
DSC_ERR_004_027 | Gauss db password should not be empty. |
DSC_ERR_004_028 | Gauss db password should not be empty. |
DSC_ERR_004_029 | Target db entered in the Gaussdb.properties is not valid. |
DSC_ERR_004_030 | User name entered in the Gaussdb.properties is empty. |
DSC_ERR_004_031 | Port entered in the Gaussdb.properties is not valid. |
DSC_ERR_004_032 | IP entered in the Gaussdb.properties is not valid |
DSC_ERR_004_033 | Database name entered in the Gaussdb.properties is empty |
DSC_ERR_004_034 | DSC Application failed to start. |
DSC_ERR_004_035 | Since the Enviroment variable path has write privileges to Group and/or Others, process is stopped due to security reason. |
DSC_ERR_004_036 | Error while loading Enviroment parameter File. |
DSC_ERR_004_037 | Invalid input (empty/space/string value) for the parameter NoOfThreads in application.properties. Hence taking the default processes. |
DSC_ERR_004_038 | Input for the parameter NoOfThreads in application.properties is less than 1. Hence taking the default processes. |
DSC_ERR_004_039 | Error in processing the DDL query. |
DSC_ERR_004_040 | Error in processing the PL/SQL query. |
DSC_ERR_004_041 | Error in post processing the query. |
DSC_ERR_004_042 | Invalid application timeout value, default to 4 hours. |
DSC_ERR_004_043 | Error in writing the output file. |
DSC_ERR_004_044 | Error in reading the input file. |
DSC_ERR_004_045 | No valid files found in the input directory for migration. |
DSC_ERR_004_046 | Query is not converted as it contains unsupported keyword. |
DSC_ERR_004_047 | Error while reading the property. |
DSC_ERR_004_048 | PreQueryValidation failed due to query exceeds maximum length (MaxSqlLen config parameter). |
DSC_ERR_004_049 | Thread count entered in the Gaussdb.properties is not valid. |
Wrapper | |
DSC_ERR_005_003 | Reading file Failed with error: File not found Exception. |
DSC_ERR_005_004 | Reading file Failed with error: IOException. |
DSC_ERR_005_005 | Root privileged users are not allowed to execute the DSC tool. |
DSC_ERR_005_006 | Error while getting the id of os user used to execute the DSC tool. |
DSC_ERR_005_007 | Arguments specified is not valid, please check the user manual for the command line arguments. |
DSC_ERR_005_008 | File name is not specified for reading the encoding type. |
DSC_ERR_005_009 | Invalid argument specified for the encoding parameter. |
DSC_ERR_005_010 | Source database is not set. Please enter a valid source db and refer the user manual for syntax. |
DSC_ERR_005_011 | Commandline database specified for source to target is not supported by the DSC tool. |
DSC_ERR_005_012 | Error in loading config file with IOException. |
DSC_ERR_005_013 | Initial JVM memory is greater than maximum JVM memory. |
DSC_ERR_005_014 | Invalid value specified for configValue. |
DSC_ERR_005_015 | Invalid source database specified for source-db option. |
DSC_ERR_005_016 | Invalid target database specified for target-db option. |
DSC_ERR_005_017 | Invalid conversion type specified for dsc-type option. |
DSC_ERR_005_018 | Invalid application language specified for application-lang option. |
DSC_ERR_005_019 | Conversion-type should be DDL for application-lang type as perl. |
DSC_ERR_005_020 | Source-db should be teradata for application-lang type as perl. |
DSC_ERR_005_021 | Please use "-VN [V1R7 | V1R8_330]" or "--version-number [V1R7 | V1R8_330]" to specify the kernel version which can be either V1R7 or V1R8_330. |
DSC_ERR_005_022 | Input directory does not exist. |
DSC_ERR_005_023 | Getting path for input directory failed with IOException. |
DSC_ERR_005_024 | Getting path for output directory failed with IOException. |
DSC_ERR_005_025 | Setting file permission for output directory failed with IOException. |
DSC_ERR_005_026 | Creating output directory failed. |
DSC_ERR_005_027 | Setting file permissions for log directory/file failed with FileException. |
DSC_ERR_005_028 | Error while connecting to GaussDB, Failed with error. |
DSC_ERR_005_029 | Error occurred due to file permission while creating or executing the file. |
DSC_ERR_005_030 | No arguments specified in the commandline. |
DSC_ERR_005_031 | Error occurred in creating output directory. |