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

[neetavarma]

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?

[MarkKorey_sas]

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.