Architecting, installing and maintaining your SAS environment

Error in validating SAS Pooled workspace server

Reply
Occasional Contributor
Posts: 15

Error in validating SAS Pooled workspace server

Error in validating pooled workspace which in turn affects the reports in the IDP portal.

Unable to fetch the reports which shows the same error. Expecting this to be an error with pooled worksapce error or something related to ports utilisation.

Could anyone please help me with this.Appreciate your response.

Thanks,

Sriram

Valued Guide
Posts: 3,208

Re: Error in validating SAS Pooled workspace server

any log information?

any steps done in SMC?

Verified Object spawner restarted after changes.

   The non personal account like sassrv is correct  etc etc.

Checked metadataserver logs?

Verified the check on the service using SMC?

---->-- ja karman --<-----
Occasional Contributor
Posts: 15

Re: Error in validating SAS Pooled workspace server

The Error states "Failed to start the server".

Over SMC tried validating Stored process server, Workspace server , but unable to validate.For Stored process server validation the error shown is "The Load balancing  Object Spawner timed out". and for Workspace server and pooled workspace server the error  is "Failed to restart the server".

Object spawner is up but the sassrv process are not available with the Unix boxes.

Is there a need to go for a retstart of Object spwaner which in turn may help in restarting Workspace and pooled workspace server. or is there any other options available without restart?

Thanks

Valued Guide
Posts: 3,208

Re: Error in validating SAS Pooled workspace server

The validation with SMC is telling you there is something wrong.

There must be logs having more information the metadata server log is the one to start at.

The object spawner log must have the same errors as you have experienced but should have some additional information.  

The sassrv account should be an operational Unix account capable of running the sas processes.

Possible causes:

- The password could be configured wrong.  If you are ale to verify that...

  SAS(R) 9.4 Intelligence Platform: Installation and Configuration Guide ( Troubleshooting the SAS Server Tier)
  39891 - Using PROC PERMTEST to diagnose UNIX host authentication issues in SAS® 9.2 and later releas...

  

- In the metadata server log you should find the objectspawner has read those.

  The objectspawner can be started to early and the metadataserver does not react or come changes have been made on the metadataserver sassrv/application server(s).

  A restart of the object-spawner is necessary.   (since 9.3 in SMC)

  Not all metadata settings are allowed for all users.

  36244 - The SAS® Stored Process Server fails to authenticate if the sastrust or sassrv account is an... 

  

- the sasauth, sasperm modules are configured not correctly.   SAS(R) 9.4 Intelligence Platform: Application Server Administration Guide

---->-- ja karman --<-----
Occasional Contributor
Posts: 15

Re: Error in validating SAS Pooled workspace server

Hi Jaap,

The issue has been resolved now.

The ERROR with the pooled workspace server said "Library WORK does not exist" , which made us to check for the WORK path location , which was in turn pointing to two paths , of which one was mounted . We  found the problem to be with the mount path and changed accordingly in sasv9_locale.cfg file and got it resolved.

Thanks a lot for your support. Appreciate your response

Sriram

Valued Guide
Posts: 3,208

Re: Error in validating SAS Pooled workspace server

That is good news. And as almost always it was something not been thought of.

After the installation you can verify that part using SAS foundation with a terminal (x11) approach. There are several SAS config settings related tot the OS/hardware to get tuned well.

As you have found the SAS work as being the root cause. Rethink about this resource. With heavy loads it can be a bottleneck. Segregation by users/usage is possible.

There is an option:  utilloc  that is meant to segregate the sort and proc sql temporary files  (#Util... namings). All for performance reasons.

good luck

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 5 replies
  • 1476 views
  • 0 likes
  • 2 in conversation