topic Re: SAS VA: can't load tables in Administration and Deployment

SAS VA: can't load tables

MariaD — Wed, 03 Nov 2021 13:41:33 GMT

Hi Folks,

We recently restarted our SAS server, everything back to normal without any error. After starting the LARS servers, I can't load any new table. If you see, the browse for load table appears empty. Do you know why?

When select browse, does not show anything

Server is up

Regards,

Re: SAS VA: can't load tables

alexal — Wed, 03 Nov 2021 13:46:12 GMT

What error did you get when you tried to load a table into the memory?

Re: SAS VA: can't load tables

gwootton — Wed, 03 Nov 2021 13:46:21 GMT

Do all your application servers validate successfully (Workspace Server, Pooled Workspace Server, Stored Process Server)?

Re: SAS VA: can't load tables

MariaD — Wed, 03 Nov 2021 13:50:21 GMT

Does not show any error. After I select "Load table" (to load a new table), click on "Source table name" to browse the table, and the windows appear completed empty.

Re: SAS VA: can't load tables

MariaD — Wed, 03 Nov 2021 13:51:13 GMT

Thanks @gwootton . Yes, I'm working without any problem in SAS EG, for example.

Re: SAS VA: can't load tables

alexal — Wed, 03 Nov 2021 13:52:58 GMT

Check the object spawner and the workspace server logs. Do you see any errors there?

Re: SAS VA: can't load tables

gwootton — Wed, 03 Nov 2021 13:56:44 GMT

Enterprise Guide uses the Workspace Server, do the others validate in SAS Management Console? I think the VA Admin application uses the pooled workspace server for some actions.

Re: SAS VA: can't load tables

MariaD — Wed, 03 Nov 2021 14:20:06 GMT

Thanks, @gwootton . In fact, there is an error on Pooled Workspace Server. I'm verifying the error right now and let you know.

Regards,

Re: SAS VA: can't load tables

MariaD — Wed, 03 Nov 2021 14:34:30 GMT

Thanks everyone, for some crazy reason the server was deselected from Pooled Server. After adding it and restarting it, it returns to work.

Re: SAS VA: can't load tables

gwootton — Wed, 03 Nov 2021 15:05:08 GMT

Glad to hear it's back up and running! Please mark this topic as resolved.