About infmja

infmja · ‎06-04-2018

Thanks. I checked the logs in these folders. I found the following, which seem related to my problem: ACCESS LOG (C:\sas\config\Lev1\Web\WebServer\logs) 10.254.55.17 - - [14/May/2018:16:22:42 +0200] "GET /SASVisualAnalyticsHub/?saspfs_request_path_url=SBIP%3A%2F%2FMETASERVER%2FKundenreporting%2FUKB%2FStatistik+Portal_UKB%28Report%29 HTTP/1.1" 302 - LOCALHOST ACCESS LOG (C:\sas\config\Lev1\Web\WebAppServer\SASServer1_1\logs) 10.10.130.20 - - [14/May/2018:16:22:42 +0200] "GET /SASVisualAnalyticsHub/?saspfs_request_path_url=SBIP%3A%2F%2FMETASERVER%2FKundenreporting%2FUKB%2FStatistik+Portal_UKB%28Report%29 HTTP/1.1" 302 - I can't find any authorization logs for the customer who tested it. Seems correct, since he never was able to actually login. Any ideas?

infmja · ‎05-29-2018

Hi @JuanS_OCS They are not in Windows 10. They use the Internet Explorer, but I think they tried with other browsers as well. I couldn't find anything in the log files. Any specific log files I should have a look at? Whitelists are configured.

infmja · ‎05-24-2018

Hello community Current SAS version: 9.4_M3 Current situation: A customer, which is not in our domain, but has a user in our domain, needs to view some reports in our SAS environement which is inside our domain. We configured a site-to-site VPN, which is accessible for our customer. The idea is that they access the Visual Analytics Hub and then get an authentication window because their currently logged in user is not found in our Active Directory and they could then log in to SAS with the user we specified in our Active Directory. The problem: They get to the "Welcome to SAS - Congratulations! You have successfully set up SAS Web Server" page. But if they try to access the Visual Analytics Hub for example, they get an error: "The DNS name does not exist INET_E_RESOURCE_NOT_FOUND". It definitely sounds like a network configuration error, but since they can access the "Welcome to SAS" page without any problems, I doubt it's the network's fault. Is there something I have to configure in our SAS environment itself to work with a site-to-site VPN? Kind regards Martin

infmja · ‎03-05-2018

Thank you very much Nik! It worked! Is there a documentation about these XMLs somewhere or how/where did you figure it out?

infmja · ‎03-02-2018

Hey there I added a user to the SAS metadata using the XML Metadata Interface. In the "Add Metadata" tab, I used the following XML: <Person Desc="" DisplayName="Testuser" IsHidden="0" Name="Testuser Test" Title="Tester"/> This worked absolutely fine. Now I need to add the user to a group which is already existing in the metadata. I tried the following in the "Update Metadata" tab: <Person Id="A5NUQPXO.AP00002V"> <IdentityGroups> <IdentityGroup Id="A5NUQPXO.A500001C" Name="REU" Desc="REU Reporting"/> </IdentityGroups> </Person> This didn't work and it responded with the following error: Error: com.sas.iom.SASIOMDefs.GenericError: The association from IdentityGroup : A5NUQPXO.A500001C to Person : A5NUQPXO.AP00002V cannot be created. The association from IdentityGroup : A5NUQPXO.A500001C to Person : A5NUQPXO.AP00002V cannot be created. The IDs should actually be correct. I used the Metadata browser in the SAS Foundation and copied the IDs from there. Do you know how I can add a user to a group using the XML Metadata Interface? Kind regards Martin

infmja · ‎12-22-2017

I applied the configuration from your links. Now I can access /SASVisualAnalyticsHub and the DNS stays, but as soon as I want to access something like the Report Viewer, there is the following error message: HTTP401 Ticket does not match the supplied service What is causing the error message? How can I fix it?

infmja · ‎12-11-2017

So, I tried changing the FQDN only this time. Everything was still working fine, but the DNS changed always back to the hostname when accessing SAS with the DNS (e.g. http://something.something.loc/SASVisualAnalyticsHub). If I type the DNS only, without "SASVisualAnalyticsHub" behind the last slash, it opens up the "Congratulations! You have successfully set up SAS Web Server" page and keeps the DNS in the URL (which would be the correct behaviour). Do you have any ideas how I can change the configuration so it always keeps the DNS?

infmja · ‎11-03-2017

Hello everyone We configured a DNS (something.something.loc) which then resolves to the serverhostname. If we access SAS with the DNS (e.g. http://something.something.loc/SASVisualAnalyticsHub), the URL changes back to the serverhostname (http://serverhostname/SASVisualAnalyticsHub). I ran the Update Hostname Utility replacing the serverhostname with our DNS something.something.loc, which, obviously, caused a lot of problems afterwards, because something.something.loc is not the server's hostname. But the URL didn't change back to serverhostname now. I ran the Update Hostname Utility again to change something.something.loc back to the serverhostname so everything works again. So, where exactly do I have to replace the serverhostname with our DNS (something.something.loc) in order to keep the URL at something.something.loc instead of the serverhostname? (In both cases, accessing SAS worked without any problems) Kind regards Martin

infmja · ‎10-31-2017

Thanks for all the answers. I found time to continue to work on this topic and I would like to learn how the programming/scripting language works. Are there any tutorial series, docs or something similar?

infmja · ‎10-17-2017

How do I check if a variable contains a specific string?

infmja · ‎10-17-2017

Thanks for the answer, but the users are spread across multiple OUs and in those OUs are users I don't need to sync. Therefore I cannot sync the whole OU. That's the reason why I wanted to get the users from groups and sync only the those. I think I'm going to try to filter for group memberships (if user is in group a or b or c then sync). It should be possible to differentiate the users to sync from the users not to sync that way, right?

infmja · ‎10-17-2017

Hello everyone I know how to sync users from a specific OU in the AD. In the current case I need to sync users from specific groups. Is that possible? If yes, how? SAS version 9.4 VA version 7.3 Kind regards Martin

infmja · ‎09-11-2017

Thanks for the help so far! 🙂 Looks like that's the case. It's now working as expected again. Not sure if it's already working for our customers. I have to test that. Do they need Read permissions on the report/parent folders of the report itself too or just on the tables/parent folders of the tables? Checked the version now in the frontend, and yes, it's version 7.3.

infmja · ‎09-11-2017

Does it take a while before the permissions take effect? It seems so odd and completeley random to me... I remove all my permissions - it obviously doesn't work anymore RM permissions - it works RM + R permissions - it works Back to RM only - it doesn't work RM + R again - it still doesn't work After getting angry, giving up, wating for quite a while and changing the permissions again, it starts magically working again... Is there something like a reload happening? Can I trigger a reload or whatever it needs to acutally update the permissions? And yes, you are right, it's "You are not authorized to view the data that is used in this report object.". I had that wrong in mind, sorry. Looks like VA version is 7.3 if I'm reading the deploymentregistry txt file correctly.

infmja · ‎09-11-2017

Hello everyone A lot of our customers get the error mentioned in the subject line when they open a report. The report opens properly, but the error is shown everywhere where the actual data should be. I was not yet able to reproduce the error on purpose, but I've seen it myself too from time to time. Not sure where it's coming from. One important side note might be, that I was changing the permissions of my user to test some settings. If I've seen the error, it was after changing my permissions. The problem with this; it doesn't happen always... As already mentioned in the subject line, the error is the following; "You are not allowed to view data used in this report". Maybe I missed something with the permissions? The users, groups to be exact, have the ReadMetadata permission on the folder which contains the reports and therefore also on the reports in the folder. Everything else, WriteMetadata, Read, Administer etc., is denied. SAS Version: 9.4 Every help is very well appreciated. Kind regards Martin

Online Status	Offline
Date Last Visited	‎09-06-2018 05:45 AM

Re: Site-to-Site VPN to SSO SAS Environment

Re: Site-to-Site VPN to SSO SAS Environment

Site-to-Site VPN to SSO SAS Environment

Re: XML Metadata Interface Adding User to Group

XML Metadata Interface Adding User to Group

Re: DNS Changing Back to Hostname

Re: DNS Changing Back to Hostname

DNS Changing Back to Hostname

Re: Active Directory Sync Users from Groups

Re: Active Directory Sync Users from Groups

Supress creating *.lst output in batch mode via SAS Management Console

Re: Supress creating *.lst output in batch mode via SAS Management Con...

Re: XML Metadata Interface Adding User to Group

Re: XML Metadata Interface Adding User to Group

Re: DNS Changing Back to Hostname

Site-to-Site VPN to SSO SAS Environment

Re: XML Metadata Interface Adding User to Group

Active Directory Sync Users from Groups

Re: Active Directory Sync Users from Groups

Re: Site-to-Site VPN to SSO SAS Environment

Re: Site-to-Site VPN to SSO SAS Environment

Site-to-Site VPN to SSO SAS Environment

Re: XML Metadata Interface Adding User to Group

XML Metadata Interface Adding User to Group

Re: DNS Changing Back to Hostname

Re: DNS Changing Back to Hostname

DNS Changing Back to Hostname

Re: Active Directory Sync Users from Groups

Re: Active Directory Sync Users from Groups

Re: Active Directory Sync Users from Groups

Active Directory Sync Users from Groups

Re: You are not allowed to view the data used in this report

Re: You are not allowed to view the data used in this report

You are not allowed to view data used in this report