When you attempt to delete a query, SAS Visual Data Builder might display an exception that is similar to the following:

In addition, if you attempt to delete the query in SAS^® Management Console, you might see an exception that is similar to this one:

Queries are stored in both metadata and in the SAS^® Web Infrastructure Platform Database. If the database entry has been deleted but the metadata object still exists, then this problem can occur.

If you encounter this problem, you can run the SAS^® code on the Full Code tab in this SAS note to completely delete the query.

Operating System and Release Information

• <hostname> = The host name of your metadata server
• <port> = The port for your metadata server (default is 8561)
• <admin user> = The SAS Administrative User (for example, sasadm@saspw)
• <password> = The password for the SAS Administrative user
• <query name> = The name of the Visual Data Query that you want to delete

options metaserver="<hostname>" metaport=<port> metauser="<admin user>" metapass="<password>";

 

data _null_;

    length id $17;  

   id = '';    

   rc = metadata_resolve("omsobj:Transformation?@Name='<query name>'", '', id);

   put id=;

   if rc > 0 then do;

       rc=metadata_delobj(id);        

   end;

run;