Javascript querydef error, not able to select attributes calling xxlmig-snowflake

[Bpagadal]

var kEvents = xtk.queryDef.create(
<queryDef schema="xxlmig:newValidation" operation="select">
<select>
<node expr="@student"/>
</select>
</queryDef>).ExecuteQuery();

for each (var row in kEvents)
{
logInfo("@student: "+row.@student);
logInfo("----End----");

}

[ShashankNigam02 · Accepted solution]

Hi @Bpagadal , Please check for any syntax errors in the srcSchema and regenerate it.

[MeitMedia]

Hi @Bpagadal,

The error message indicates that the schema you've defined in your queryDef function, i.e., "xxlmig:newValidation", does not exist in your Adobe Campaign (AC) database.

Here’s what you can do:

1. Validate that the schema name is correct, including the proper character case as defined in the schema definition.
2. If this is a newly created schema, ensure you publish it to your AC database by navigating to Tools > Advanced > Update database structure, and then re-execute the JavaScript activity.

Best regards,

MEIT MEDIA (https://www.meitmedia.com)

Find us on LinkedIn

Contact Us: infomeitmedia@gmail.com

[aggabhi]

Thanks @MeitMedia ,

It was very helpful