topic Re: SASVIYAINVENTORY and SASVIYATYPES tables cannot be found in Administration and Deployment

SASVIYAINVENTORY and SASVIYATYPES tables cannot be found

achilleask — Sun, 13 Aug 2023 12:37:48 GMT

Hi to all SAS community users,

While using SAS Environment Manager, I found a report SAS Viya Inventory that was not working. When I opened it, I got the error "Cannot find the requested data source" for tables SASVIYAINVENTORY and SASVIYATYPES. Are there any steps to fix this issue ? I attached a zip file with 2 screenshots ,which maybe helpful.

Thanks in advance,

Achilleas Karavas

Re: SASVIYAINVENTORY and SASVIYATYPES tables cannot be found

JosvanderVelden — Sun, 13 Aug 2023 16:54:36 GMT

Can you please provide some more details. We need to know what viya version you are using. If you are using SAS Viya for Learners that is Viya 3.5.
If you have screenshots please insert them in the post as images. Most participants in this forum, myself included, will not open attached zip-files because of security risks. That includes other attached file-types.

Re: SASVIYAINVENTORY and SASVIYATYPES tables cannot be found

achilleask — Sun, 13 Aug 2023 20:54:11 GMT

Thank you for your reply. Version is SAS Viya 3.5 installed on Red Hat Enterprise Linux release 8.3. I understand your concern for zip files, thus I attached the following images :

Re: SASVIYAINVENTORY and SASVIYATYPES tables cannot be found

ronf_sas — Mon, 14 Aug 2023 12:31:39 GMT

Hi. The inventory report is not enabled out-of-the-box. There are some steps you must take to publish the data for these tables. If at one time you had enabled this report and it was working, you might want to contact SAS Technical Support. If you have never published the data for this report, then the errors you are seeing are expected and do not indicate a problem.

See this SAS Communities article for more information: Viya Inventory CLI and Reports - SAS Support Communities

Re: SASVIYAINVENTORY and SASVIYATYPES tables cannot be found

achilleask — Fri, 18 Aug 2023 08:30:53 GMT

Thank you @ronf_sas !!! I didn't notice if this report was working before, but I think not, because we never ran the steps you provided. I will follow these steps and I'll send a feedback !!!