Error Logging and Troubleshooting under Transformation

This topic provides information about issues encountered during workload transformation. To enhance visibility, diagnose issues, and track them effectively, we provide detailed information in the following message formats: Info, Error, Warning, ToDo, and Alert. This insight facilitates efficient troubleshooting of issues.

Info: Displays informative or neutral message.
Error: Displays critical issues that may affect transformation.
Warning: Displays potential issues that might impact the output but will not stop the transformation.
ToDo: Displays issues that require manual intervention.
Alert: Displays attention-grabbing or non-critical issues.

The table below displays various categories of issues you may encounter when transforming legacy workloads to cloud-native stack.

Category	Description
BTEQ	This category includes workload transformation issues that occur in BTEQ scripts or queries. For instance, incorrect syntax, unsupported commands (e.g., auto-conversion of command logon is not supported on the target platform), etc.
DDL	This category includes workload transformation issues that occur in DDL scripts or queries. For instance, incorrect syntax, missing Primary Key details, Unique Primary Index is not supported in the target, etc.
NOT_SUPPORTED_IN_TARGET	This category includes issues related to the patterns, clauses, statements, constraints, etc., for which auto-conversion is not supported in the target.
DML	In workload transformation, issues that occur in DML scripts or queries are categorized as DML related issues. For instance, incorrect syntax, missing Primary Key details, Unique Primary Index is not supported in the target, etc.
FUNCTION	Issues related to functions are categorized into this category. For instance, auto-conversion of the UNPIVOT function is not supported in the target, the function has an invalid number of arguments, etc.
FLD	This category includes issues related to source input FLD files.
PROCEDURE	This category includes issues related to the transformation of procedures.
VARIABLE	This category includes issues related to the transformation of variables in queries. For instance, some variables could not be auto converted to the target.
EXPRESSION	This category includes issues related to the transformation of expressions in queries. For instance, could not auto-convert various expressions such as date format, mathematical expressions, etc., to the target.
METADATA_NOT_FOUND	This category includes transformation issues caused by missing metadata for tables, columns, databases, and queries.
DATA_TYPE_ISSUE	This category includes issues related to the transformation of various data types in queries.
UNSUPPORTED	This category includes issues related to the transformation of various unsupported statements, operations, arguments, etc. For instance, auto-conversion of various statements such as signal and resignal is not supported on the target platform.
EXCEPTION	This category includes workload transformation issues caused by unexpected errors such as handler exceptions in stored procedures.