Trying to query a SQL view using the FEDSVR engine might result in an error when the following is true:

• SAS^® Federation Server Manager cached the SQL view.
• You access the view using FEDSVR.
• You create the view with a READ= or PW= option.

As a result, the following errors occur:

ERROR: CLI prepare error: Table " mycatalog.myschema.myview " does not exist or cannot be accessed : BASE driver, Table myschema.myview does not exist or cannot be accessed or created : Invalid or missing READ password on data set mycatalog.myschema.myview.DATA

ERROR: CLI prepare error: Table "mycatalog.myschema.myview" does not exist or cannot be accessed : Invalid or missing READ password

There is no workaround for this issue.