About Nigel_Pain

Nigel_Pain

Hi Siddhu Something we see sometimes with EG with a dialogue is that it opens on a different, non-existent, screen. Happens when you've had more than one screen in the past and now fewer. It might be this that is happening. Try the following when you try to join tables and EG appears to be hung: Press ALT-Space, M, followed by one of the cursor keys. Now move your mouse, and you may well find that the Tables and Joins dialogue pops onto your mouse pointer. You can then simply left-click to position the dialogue where your mouse pointer is. Hope this helps

Nigel_Pain · ‎03-13-2024

That's a bit surprising with the advanced search. My initial thought was that it might have been an upper/lower case issue but it seems to be case-insensitive on our system. The other thing I've used to good effect, not having access to the Metacoda plugins, is the metadata browser in a desktop SAS session (Solutions>Accessories). It's a good way of seeing the metadata structure. I note your comments about using IWA and connections to SQL Server being blocked. I seem to remember that the issue here is that authentication isn't propagated through to the database. It's one reason why we don't use IWA. We are also on Windows Server 2019 and have many connections to database servers. We're able to use the DefaultAuth authdomain for the SQL Server ones but because we aren't using IWA the authentication is done for each connection.

Nigel_Pain · ‎03-13-2024

I'm not on M8 (yet...) but in SMC for us the Advanced button in the identity search allows a search on user ID. If this doesn't work try: data _null_; length loginuri personuri name $256; nobj=metadata_getnobj("omsobj:login?@userid = 'domain\userid'",1,loginuri); rc = metadata_getnasn(loginuri,"AssociatedIdentity",1,personuri); rc = metadata_getattr(personuri,"Name",name); put _all_; run;

Nigel_Pain · ‎03-12-2024

Thanks, that did the trick. I wondered if there was a way to do it programmatically but I haven't delved much into changing metadata that way.

Nigel_Pain · ‎03-08-2024

SAS 9.4M7 on 4 Windows Server 2019 platforms (metadata, compute, mid-tier, LASR) I was doing a bit of tidying up of metadata folders, specifically removing the user folders of people who no longer have access. I found a couple of Visual Data Queries for one such user but I am unable to delete them. I'm using the sasadm@saspw account and have ensured that metadata permissions are set on them and their containing folder to allow me to do this. But I'm getting an error message: Any suggestions? Thanks.

Nigel_Pain · ‎03-05-2024

I'm not sure this would work. What goes in the quotes should simply be a path. If you need to store the data on a different machine I think you'd need to look at using a shared drive (Windows) or a Network Filesystem (UNIX/Linux). In a mixed environment, the two OS types can be persuaded to use each other's drive share protocols. I'm very open to being corrected...!

Nigel_Pain · ‎01-30-2024

That answers my question. I'll give it a try. I don't think there's any data of anything else listening on port 8561. Thanks Greg (and Carl).

Nigel_Pain · ‎01-29-2024

This looks exactly like what I was wanting. But will it test whether there is a response on the port, or just whether the port is open?

Nigel_Pain · ‎01-29-2024

SAS 9.4M7 on four Windows Server 2019 platforms (metadata, compute, mid-tier, LASR) Does anyone know a way to test from a Windows Powershell command whether the metadata server is started? After applying Windows Updates on our servers they are scheduled to reboot overnight. However, the metadata server is taking significantly longer to restart than the other three and so any SAS services on the other servers which rely on the metadata server are failing to start. I have Powershell scripts on all the servers to start all the SAS services but some won't start properly if there's no metadata (crucially, Object Spawners). So I wanted them to check for the metadata before continuing. The scripts are run by Windows Task Scheduler as internal System accounts so they can't use WMI or CIM to check the metadata service. Of course, I could simply delay the restarts to a time when the metadata server should have restarted but that has the possibility of failing too if it's not given long enough. Thanks.

Nigel_Pain · ‎01-22-2024

I think I'll have to take a bit of time to investigate that further. There are some bits I'm not understanding, and there are metadata settings which I can't find in SASMC for turning on auditing. But thanks again.

Nigel_Pain · ‎01-19-2024

Excellent! Helpful as always. Thanks very much.

Nigel_Pain · ‎01-19-2024

Thank you Greg. This must be in the documentation somewhere? I thought I'd seen something in the past, but searched around for it unsuccessfully in both the EV and VA documentation.

Nigel_Pain · ‎01-19-2024

SAS 9.4M7 on four Windows Server 2019 platforms (metadata, compute, mid-tier, LASR) We recently enabled the Service Architecture but are not getting the KITS.VALASR_INFO data set in the data mart populated. I have a feeling there is something else we need to do on the LASR server to enable this to happen but I can't find the relevant documentation.

Nigel_Pain · ‎01-12-2024

I haven't looked to see if that's possible but, if it's just about applying the same ACT, then I'd suggest putting the libraries in the same metadata folder and applying the ACT to that rather than explicitly to the libraries. Which is what I'd recommend anyway. If you store table definitions in the metadata then the ACT will also apply to them, which wouldn't necessarily be the case otherwise. The danger with concatenating database libraries is if there are duplicate table names in different schemas. With my suggestion, to get round this, you could actually make subfolders for each library within the folder that the ACT is applied to.

Nigel_Pain · ‎12-19-2023

Hi Elena You haven't said what version you are using. If it is SAS 9.4 and you have the Service Architecture enabled in Environment Manager to collect ARM data then you should have the information that you require in the library "SASEV - ARTIFACT" (libref "ARTIFACT"). And the Environment Manager Report Centre has predefined reports which use this and could give you most of what you want. There's documentation here: https://documentation.sas.com/doc/en/evcdc/2.5_M1/evug/p0md48tpfq4yy7n1xxqn0re5v30l.htm

Online Status	Offline
Date Last Visited	Monday

Re: Issue with the SAS EG and the Query Builder

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: Problem deleting metadata objects

Problem deleting metadata objects

Re: Connection between FTP (S3) and SAS server.

Re: Test whether the metadata server is started

Re: Test whether the metadata server is started

Test whether the metadata server is started

Re: Missing data in the Service Architecture data mart

Re: clinical sas

Re: AMO integrated into SAS Studio

SAS-wsm is available for use with SAS 9.4 deployments

Re: Automate rebuilding and redeploying web apps

Re: connection to OneDrive

Re: Issue with the SAS EG and the Query Builder

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: Problem deleting metadata objects

Re: Is it possible to declare concateneted libraries in Management Con...

Re: Issue with the SAS EG and the Query Builder

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: Problem deleting metadata objects

Problem deleting metadata objects

Re: Connection between FTP (S3) and SAS server.

Re: Test whether the metadata server is started

Re: Test whether the metadata server is started

Test whether the metadata server is started

Re: Missing data in the Service Architecture data mart

Re: Missing data in the Service Architecture data mart

Re: Missing data in the Service Architecture data mart

Missing data in the Service Architecture data mart

Re: Is it possible to declare concateneted libraries in Management Con...

Re: Extracting SAS Library Usage Information

SUGA