Problem Note 59742: The SAS® 360 Discover customer extended view (CXT) ETL can fail when there are duplicates in the session attribution table
 |  |  |  |  |
In rare instances, the SAS 360 Discover module can fail when there are duplicates in the session attribution table. The SAS 360 Discover CXT extract, transform, and load (ETL) process fails with the following error:
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.
When this problem happens, the SAS 360 Discover ETL reset job does not run, which prevents the ETL process from continuing.
Contact SAS Technical Support for help with running your ETL reset job and resuming your SAS 360 Discover ETL flow.
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#59742| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-02-25 11:38:02 |
| Date Created: | 2017-01-19 11:03:03 |