ERROR: Unresolved reference to table/correlation name null., Dump stack trace & continue.

neetavarma — Fri, 15 Aug 2025 05:52:36 GMT

I am getting this error while running a template. We have checked the Infomap and its data items for the customised properties, all are good. We have created the new business context and it is connected to the Infomap. If the template has single data item then the count is reflecting but then more than two data items (conditrions) The SAS code is generating the code which is pointing to some null. table

PROC SQL;
Create table WORK.MA6 as
SELECT
( count(*) ) AS DII_1 LABEL=''
FROM
(
SELECT DISTINCT
table0.'cifno'n AS CIFNO LABEL='cifno' FORMAT=$400.
FROM
CMDMLIB.'cinfomap_final'n table0

Inner join CMDMLIB.'cc_infomap'n table1

on table0.'cifno'n = null.'cifno'n
WHERE
table1.'cc_active_customer'n = '1' AND
table0.'cc_ever_hold'n = 1
) table2 ;

ERROR: Unresolved reference to table/correlation name null., Dump stack trace & continue.

Please suggest how to resolve this?

Re: ERROR: Unresolved reference to table/correlation name null., Dump stack trace & continue.

MarkKorey_sas — Sat, 16 Aug 2025 00:02:04 GMT

Hi @neetavarma -

This looks like a pretty technical issue specific to your environment.

To get you some dedicated support, please contact Tech Support and include as much detail as possible. On the CI360 Home Page --> Resource Center you'll find a link to "Contact technical support". This will launch a email w/ a template for you.

topic Re: ERROR: Unresolved reference to table/correlation name null., Dump stack trace & continue. in SAS Customer Intelligence

ERROR: Unresolved reference to table/correlation name null., Dump stack trace & continue.

Re: ERROR: Unresolved reference to table/correlation name null., Dump stack trace & continue.