Users unable to see only particular datasets in a library under shared service.

chandru1dev — Fri, 18 Oct 2013 10:26:48 GMT

Hi,

We face an issue, where we cannot see a particular dataset under a library which is a predefined library in SMC.

Following error in EG:

The data operation failed. The following error occured. <?xml version="1.0" ?> <Exception ><SASMessage severity = "None">

When we tried to open the same dataset in DI Studio, where this dataset is being created, following error message:

An error occured while fetching data for <dataset name>. Details of error are mentioned in the details section. Do you want to ignore and retry querying the table?

Unable to execute query: SQL passthru expression contained errors.

We had refreshed the metadata to update the metadata, and waiting to restart the service. Meanwhile is this the right solution for this error.

Kindly help, Thanks.

Re: Users unable to see only particular datasets in a library under shared service.

LinusH — Fri, 18 Oct 2013 11:06:19 GMT

How is the data set pre-defined in SMC?

How is the library assigned?

It seems that there is a miss-match between the physical table attributes and it's metadata. Try "Analyze" in DI Studio, or issue your own PROC CONTENTS to verify this.

topic Users unable to see only particular datasets in a library under shared service. in SAS Enterprise Guide

Users unable to see only particular datasets in a library under shared service.

Re: Users unable to see only particular datasets in a library under shared service.