About Nigel_Pain

Nigel_Pain · ‎08-19-2024

If you don't have the database specified in the DSN, it'll use the master database by default. Check out the contents of your odbc.ini file (if you're not on a Windows machine). Or else use a complete connection string rather than specifying a DSN. https://www.connectionstrings.com/microsoft-odbc-driver-13-for-sql-server/ has some guidance on this.

Nigel_Pain · ‎08-16-2024

It would be worth trying an ODBC special catalog query: proc sql; connect to odbc as MyODBCName (dsn="MyODBCName" user="username" password="password"); select * from connection to MyODBCName ( ODBC::SQLTables(,"dbo") ) ; disconnect from MyODBCName ; quit; It should produce a list of the tables in the dbo schema. If you want the tables from all schemas then remove the contents of the brackets in the ODBC::SQLTables statement. I've found this an invaluable tool for investigating connection problems to ODBC data sources. More information in the documentation here: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/p1f29m86u65hken1deqcybowtgma.htm

Nigel_Pain · ‎06-19-2024

Hi Kumar Each individual SAS product is maintained with hotfixes separately. So in your example, the threaded extension for SQL Server hasn't had any hotfixes applied (maybe because there haven't been any) whereas Management Console has had one, I9E001. The first three characters of the hotfix identify which product it is for. Hope that helps.

Nigel_Pain · ‎04-22-2024

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.

Online Status	Offline
Date Last Visited	a month ago

Re: Suggestions for Managing SAS Enterprise Guide Updates

Re: Suggestions for Managing SAS Enterprise Guide Updates

Re: Running the SMU

Re: Running the SMU

Re: Running the SMU

Running the SMU

Re: SASHFADD blocked by group policy

Re: Considerations for Updating to SAS 9.4 M8

Re: Considerations for Updating to SAS 9.4 M8

Re: Users removed from accessing the library

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: Suggestions for Managing SAS Enterprise Guide Updates

Re: Suggestions for Managing SAS Enterprise Guide Updates

Re: Mid-Tier config drive keeps filling up

Re: ODBC Connection from SAS 9.4 M6 on Windows Server Cannot see tabl...

Re: Metadata Migration Preserve Permissiosn

Re: Tables not shown up

Re: Tables not shown up

Re: Content of Deployment Registry file

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

SUGA