In the SQL statement, the first time a table alias name appears, the table alias name is the same as the table name. For subsequent occurrences of the same table name, the automatic entity creation component generates the table alias name in the following format:
AZ_<table ID>_<number of occurrence>
. This format ensures that the table alias name is unique each time it occurs in the SQL statement. This format also prevents the table alias name from exceeding the maximum number of characters allowed by the database.
Previously, the table alias name was
<schema name>_<table name>
regardless of the number of times it appeared in the SQL statement. The table alias name could exceed the maximum number of characters than that allowed by the database. Consequently, the archive job failed.