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.

Table 1 Error Message Reference

Symptom/Issue

Cause and Solution

Error occurred while formatting! Returning unformatted SQL: SELECT count(*) FROM table_temp;

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:

  1. No valid parameters are specified.

  2. The short keys are in lower case.

Solutions:

  1. Provide all mandatory parameters when performing migration.

  2. Ensure all short keys are in upper case.

.

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 "****" does not map to charset

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

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