You have to update the certificates on the middle tier using SAS Deployment Wizard. ... View more

If you have VA 8.1 or later, or VA 7.5, then you can use a Web Content object to display the page in VA.   There are likely workarounds for the earlier releases, but I'm not sure what they are. You might be on the right track with stored processes.   I think that the code samples here: https://communities.sas.com/t5/SAS-Stored-Processes/Can-the-SAS-Stored-Process-Web-Application-display-static/td-p/166275 might be applicable.   Sam ... View more

90% it's a firewall or other part of the network infrastructure that drops connection. ... View more

Hi David,   When registering the MAPSCSTM library as described in http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n09tvhnyrosr8mn1nmw7u3akrb1e.htm - have you properly registered this library in the autoexec as well as restarted the object spawner to let changes take affect? Also, every time you update the lookup tables - you will need to restart the web application server as tables are cached.   Can I assume you followed the specific example code for importing US counties as shown at http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n04ecrgh5srx06n1r4j4i8ggss08.htm ?   When you say - nothing is plotted. Have you tried both a geo bubble as well as geo region map? Does the geo bubble plot render? If so - it indicates that the overall registration is correct and entries in centlookup contain the correct centroids for each region. If geo region doesn't work - it usually indicates that the table references in centlookup can't be resolved (e.g. library not registered, table missing, etc.).   Finally, when defining the geographical item in VA - make sure to follow http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#p16obhz546nr6tn1aqkhaxlelswx.htm (Subdivision (State, Province) Names and select the entry matching you registered custom region)   Hope this helps. Let me know how you go.   Regards, Falko ... View more

Hello @Djones4822,   this is a really great question. Thanks for raising it.   I wonder what other think about it. My general best suggestion is to use metadata promotion (export / import spks), without the dependencies and in the right order od dependencies.   In that way, wehn you import, the import wizard will prompt you to provide the new mappings for its dependencies of the object.   However, once this is done, you probably should reload the data, and you might need to adjust any code/based operation, such as data queries and such, enything that would be using SAS metadata paths. Hence, you might want to do a good inventory upfront and action plan.   Your metadata security might suffer too, in the sense that the security will change after the folder structure change, right?    In any case, if you have a development/test environment, better to start there, to ensure there is no impact in your production environment, but also to ensure every step is clear and recorder when you apply it in production, to reduce time and even possible downtime to minimum.     ... View more

Can you tell us:    What version of Visual Analytics?  Are you viewing the report in the Flash version of the Viewer or the HTML5 (modern) version of the Viewer? If you were viewing in Flash, did you happen to test the HTML5 version to see if the same problem occurred? What browser are you using? Did you happen to test in a different browser?    ... View more

@Djones4822 Maintaining permissions in two places is going to be a pain for sure!     ... View more

Hi @Djones4822,   Support for elapsed time (time8.) and other duration formats were added in the latest release, VA 8.3. Prior to that release, I'm not aware of any other way for aggregating number of seconds and displaying it as hh:mm:ss, other than showing three separated columns for hours, minutes, and seconds. Here is an example using VA 8.3:     ... View more

What ended up happening was that I needed to go into Management Console and literally open and close the dialogue. it says to do this but the key point is that it doesn't matter if nothing's changed, you STILL need to do it. I don't have the exact dialogue box in front of me but the tech support agent knew right away what to do.    Just follow the instructions better than I do and you'll be fine! ... View more

Manually setting up TLS involves lots of steps and there are several places where it could go wrong. We can provide some guidance in this forum, but for complex things like this, my recommendation would be to get some help from SAS Professional Services or a SAS Partner in your region (who have done this many times before).   You have changed the config and hopefully restarted the SAS Web Server so have a look in the recent log files in /opt/sas94m5/config/Lev1/Web/WebServer/logs to see if there are any obvious messages.   Is the SAS Web Server running and listening on the expected HTTPS port? You could check using:   netstat -lntp | grep 8343   If it is running, then I would inspect the certificates it is using the command:   openssl s_client -showcerts -connect sasserver.example.com:8343 ... then Control-D to exit and inspect the response to make sure it is sending what you expect.   You should also check the various SAS Web App Server logs e.g. /opt/sas94m5/config/Lev1/Web/Logs/SASServer1_1 /opt/sas94m5/config/Lev1/Web/WebAppServer/SASServer1_1/logs ... and see if there are any obvious recent error messages in those.   Those are a few things to start with. I hope it helps. ... View more

@PaulHomes     Upon closer inspection you're right, my full JVM_OPTS is very long and the missing settings are there.    Thank you, I'm going to try now since my team has left for the day.  ... View more

@Djones4822 wrote: I'm not sure this would work for me as we don't have a local SAS executable installed on my machine. I was under the impression that EG worked because it connects to the host machine where the code is executed.    Am I mistaken? Is there some way for me to execute sas code from my machine?  Save the code to the server and schedule it there. Either use SMC and SAS built-in scheduling, or use your company-wide scheduling system (preferred, if one exists).   ... View more

A data provider library is used with the reload-on-start feature. This is turned on by default for the Public LASR library.   http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n1s2hnpd892n7fn1dp18x2xgffel.htm     ... View more

Hello @Djones4822,   may I suggest something?   SAS VA is very specialized and meant basically to upload data, already prepared and local (preferably a SAS table, but not necessarily), into the RAM memory and have some reports that take that data. Any other data preparation and complex queries should be left out of VA, the more the better. In simple words, SAS VA will report data with High Performance.   If you need to query data out of VA (such as databases) or prepare the final data (a datamart), my best advise for you would be to have a SAS Data Management or SAS Data Integration server, where you can prepare all your data as simple as possible and make it local, and push it into SAS VA.   Otherwise, you might find unpleasant surprises.    Of course, you can technically code into SAS VA on many ways, some of them already showcased to you: SAS Base, SAS Studio, Stored Processes (try to use them as less as possible) SAS EG, SAS DI, etc etc.   However, as said, technically possible, but also technically not good for performance and, even more interesting, perhaps the license/contract is not meant for that, so I advise to be careful with that as well (The SAS Base license provided to VA only environments are exactly that, a special SAS Base license to run LASR, not normal Base code).   Message: use the interface as @Madelyn_SAS mentioned. For other purposes, take the functionality out of SAS VA.   ... View more