BookmarkSubscribeRSS Feed
Izzati
Calcite | Level 5

Hi all,

I’m facing an issue where one job node (Update Metadata) fails after we run a masking step.

Here’s the situation:

  • Environment: SAS DI Studio

  • Library: Result Mart - PPK (points to a folder with tables, most with date suffixes)

  • Masking job writes to a ppk_mask folder, then masked tables are copied back into the main ppk folder.

  • After that, one fixed table (PPK_DTL) that normally appends new rows starts causing this error: (my hypothesis)
    ERROR: No metadata objects found matching specific URI.

  • The physical table PPK_DTL.sas7bdat exists and the append job runs fine; only the Update Metadata node fails.

I suspect the physical-to-metadata link or URI got broken when the masked data replaced the file.

I’ve checked that PPK_DTL exists in metadata under the same library. And the same update metadata is used for other libraries as well and can run well. The only difference this node is that in this Result Mart - PPK library has a fixed table. What should I do to be able to run the update metadata node?

Thanks in advance!

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 106 views
  • 0 likes
  • 1 in conversation