Usage Note 57237: Deleting a SAS® Visual Data Builder query might fail with a "500 Internal Server Error"
When you attempt to delete a query, SAS Visual Data Builder might display an exception that is similar to the following:
DataQuery1 could not be deleted
In addition, if you attempt to delete the query in SAS® Management Console, you might see an exception that is similar to this one:
Exception occurred deleting Visual data query "DataQuery1".
Reason: 500 Internal Server Error
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
SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 7.1 | | 9.4 TS1M2 | |
Linux for x64 | 7.1 | | 9.4 TS1M2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Edit the code and replace the following tags with your values:
- <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;
Date Modified: | 2016-01-08 14:12:40 |
Date Created: | 2015-12-10 16:57:26 |