Problem Note 59757: The SAS® 360 Discover customer extended view (CXT) ETL reset job fails and generates an error on occasion
 |  |  |  |  |
Occasionally, the SAS 360 Discover extract, transform, and load (ETL) reset job fails, generating the following error shown below:
MPRINT(CXT_ETL_RESET): create table idx as select table_name, index_name, index_type, column_name, uniqueness from
&dropped_indexes where table_name =
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
NOTE 139-205: Line generated by the macro function "SUBSTR".
466 &tblnmqt
_
22
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, CONNECTION, DICTIONARY.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.
&dropped_indexes where table_name =
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
WARNING: Apparent symbolic reference TBLNMQT not resolved.
NOTE 139-205: Line generated by the macro function "SUBSTR".
466 &tblnmqt
_
22
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, CONNECTION, DICTIONARY.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.
This problem happens when the ETL reset job fails to resolve all tables.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence 360 | N/A | ||
A fix for this issue for SAS Customer Experience Targeting Server 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y67.html#59757| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-02-07 10:00:07 |
| Date Created: | 2017-01-20 09:13:39 |