getting error while executing SysAdmin.loadMatView

[dineshnasa]

I am getting following errors while executing

ror: TEIID30168 Remote org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE (('SELECT Name, TargetSchemaName, TargetName, Valid, LoadState, Updated, Cardinality, LoadNumber FROM ' || VARIABLES.statusTable) || crit) AS Name string, TargetSchemaName string, TargetName string, Valid boolean, LoadState string, Updated timestamp, Cardinality long, LoadNumber long INTO #load USING vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = loadMatView.viewName" with the SQL statement "(('SELECT Name, TargetSchemaName, TargetName, Valid, LoadState, Updated, Cardinality, LoadNumber FROM ' || VARIABLES.statusTable) || crit)" due to: Evaluated dynamic SQL expression value was null.

[rareddy]

Are you doing external materialization? if yes see Query remote DB without DB Link | Oracle Community on directions to set it up, before running the "loadMatView"

[rareddy]

Sorry, I think I may have posted a wrong link, I was about to post this External Materialization · Teiid Documentation before running the "loadMatView".