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.
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
SAS System | SAS Customer Intelligence 360 | N/A | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2020-02-25 11:38:02 |
Date Created: | 2017-01-19 11:03:03 |