Log messages
SQL-015
| Identifier | SQL-015 |
| Message | 'Internal issue during %s, because of %s' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which could mean that the following CAST rule may not be triggered and its results will not be available: Avoid using SQL queries inside loops (7424). |
| User Action | Contact CAST Support and provide the full warning message. |
SQL-014
| Identifier | SQL-014 |
| Message | 'There is no SQL file to analyze.' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis: the results of the database extraction do not conform to the correct format and it is not possible to analyze them. E.g.: you have selected a database extraction in a different format, i.e an Oracle Forms extraction. |
| User Action | You should repeat the database extraction process to ensure that the results are correct, deliver these files for analysis and then re-analyze them. Contact CAST Support if the issue persists. |
SQL-013
| Identifier | SQL-013 |
| Message | 'Links could not be moved from synonyms to aliased objects because of %s ' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which is preventing the creation of links between synonyms and the aliased objects. |
| User Action | This issue can be remediated by creating a Knowledge Base Update SQL Tool job (using the CI_LINKS table) to add the links that you require. Contact CAST Support if the issue persists. |
SQL-012
| Identifier | SQL-012 |
| Message | 'Internal issue during %s, because of %s' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which could mean that the following CAST rule may not be triggered and its results will not be available: Prefer UNION ALL to UNION (7436). |
| User Action | Contact CAST Support and provide the full warning message. |
SQL-011
| Identifier | SQL-011 |
| Message | 'Internal issue during %s, because of %s' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which could mean that the following CAST rule may not be triggered and its results will not be available: Avoid Artifacts with High Depth of Nested Subqueries (7130). |
| User Action | Contact CAST Support and provide the full warning message. |
SQL-010
| Identifier | SQL-010 |
| Message | 'Internal issue during %s, because of %s' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which could mean that the following CAST rule may not be triggered and its results will not be available: Avoid Artifacts with SQL statement including subqueries (7808). |
| User Action | Contact CAST Support and provide the full warning message. |
SQL-009
| Identifier | SQL-009 |
| Message | 'Internal issue during %s, because of %s' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which could mean that the following CAST rule may not be triggered and its results will not be available: Avoid Artifacts with lines longer than X characters (7784). |
| User Action | Contact CAST Support and provide the full warning message. |
SQL-008
| Identifier | SQL-008 |
| Message | 'Internal issue during %s, because of %s' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which could mean that the following CAST rule may not be triggered and its results will not be available: Avoid Artifacts with High Depth of Code (7768). |
| User Action | Contact CAST Support and provide the full warning message. |
SQL-007
| Identifier | SQL-007 |
| Message | 'Temporary objects cannot be removed, because of %s ' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which could cause duplicated synonyms. |
| User Action | This issue can be remediated by creating a Knowledge Base Update SQL Tool job (using the CI_NO_OBJECTS table) to remove the duplicated synonyms. Contact CAST Support if the issue persists. |
SQL-006
| Identifier | SQL-006 |
| Message | 'Symbol %s cannot be analyzed.' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which could mean that some Views will not be resolved. |
| User Action | Contact CAST Support and provide the full warning message. |
SQL-005
| Identifier | SQL-005 |
| Message | 'Non supported RENAME TABLE between different schemes/databases' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis. The syntax "RENAME TABLE schema1.tableName1 TO schema2.tableName2" is not supported and the statement will be ignored. |
| User Action | There is no remediation for this issue. The syntax is not supported. |
SQL-004
| Identifier | SQL-004 |
| Message | 'Analysis issue between line %s and %s %s'. |
| Severity | Warning |
| Explanation | This warning indicates an issue in a file during the analysis, which could mean that some links/properties for the object(s) declared between the lines reported in the warning message will be missing. |
| User Action | Contact CAST Support and provide the full warning message and the statement you have between the lines reported in your warning message. |
SQL-003
| Identifier | SQL-003 |
| Message | 'Issue during link saving %s'. 'At line %s, during saving %s'. 'During saving %s'. |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which could mean that some links between objects will not be resolved. |
| User Action | Contact CAST Support and provide the full warning message and impacted file. |
SQL-002
| Identifier | SQL-002 |
| Message | 'Parsing issue between line %s and line %s : %s'. 'Parsing issue on file %s, because of %s' |
| Severity | Warning |
| Explanation | This warning indicates an issue during the analysis which could mean that some objects will not be resolved. |
| User Action | Contact CAST Support and provide the full warning message and file. |
SQL-001
| Identifier | SQL-001 |
| Message | 'No schema found for file %s' |
| Severity | Warning |
| Explanation | This warning occurs when a .src file in your source code delivery is not specified in the accompanying .uaxdirectory file (either the extraction contains errors or the .uaxdirectory file has been manually modified). In this situation, the object defined in the .src file will be automatically added to the DEFAULT schema. |
| User Action | The database extraction should be re-run to ensure that the results are correct and will be accepted by the analyzer. |