About L2Fly

ronan · ‎01-11-2019

Hi, Thanks for providing the LogConfigSweeper tool, this looks very promising. I wasn't able to collect the logs on either a Unix (AIX) OA 9.4 (Metadata-Compute) or a second Linux MidTier machine. In both cases, the SASConfig directory is named <path>/SASCFG/Lev0 ("zero") which, although correct, differs from the Lev1 default naming scheme : might this difference be the cause of the issue ? The LogConfigSweeper sucessfully creates the target folder then stops unexpectedly, folder still empty. ./LogConfigSweeper.sh -output logconfigsweeper logconfigsweeper/20190111-162631 Output File Path: logconfigsweeper/20190111-162631 [logconfigsweeper/20190111-162631] ***** STARTED SAS LOGCONFIGSWEEPER TOOL (version 1.0)*****

Tom · ‎10-20-2018

@L2Fly wrote: Thanks again but I am using the exact lib name "LIBPROD"! LIBNAME LIBPROD ODBC DATAsrc=EISPROD SCHEMA=dbo ; So you don't want to use metadata server to connect? That LIBNAME statement will close any existing libref named LIBPROD and create a new libref using the ODBC engine to connect directly and by-pass the metadata server. If LIBPROD is setup automatically why are you trying to change it? If LIBPROD is not setup automatically then you need to use the same syntax for creating it that EG used to create it. Try using the LIST option to see how it is defined in your EG session. libname libprod list;

FredrikE · ‎10-05-2018

The column properties you could set with a display rule. You can create an expression that is always true and for that expression set font and color, in that way every row in the column will have the secified properties 🙂 //Fredrik

L2Fly · ‎09-17-2018

Thank you @Reeza, got it and it is working. Best

L2Fly · ‎06-27-2018

Agree @AndrewHowell, SAS did the install. I normally like the community first just in-case someone been through the same. I will post the result and my findings from SAS support. Thanks again

L2Fly · ‎06-06-2018

Found it, the file called SaveDlg but it will change each time a file get saved and it keeps the location of last saved file ;-(

LinusH · ‎05-25-2018

I think the flow script is generated when scheduled, or when you issue a Run now from SMC. It would be nice if the script could be created as a separate task/command.

L2Fly · ‎05-11-2018

It is solved now When I was reading the documentation it indicated to make sure to add trailing slash at the end of the URL. After many attempt and per last response from SAS tech support I took out the trailing slash and only one entry and everything started to work. So it looks like if you are redirecting from a SAS URL you need to add the trailing slash but if you are redirecting from a different site in my case internal site you don't need the trailing slash. Thanks again

L2Fly · ‎04-27-2018

Thank you @alexal for your help. I will take a look and try to do the same in my environment. Will keep you posted. Best

L2Fly · ‎04-26-2018

Thank you @SASKiwi for your help and info. Much appreciated, the way I have ours setup is to using ODBC library straight to our DW and registered all of tables we want users to access from EG or SAS Studio. Then based on the business requirement I am moving some of these tables into LASR to be used by our users in visual analytics. I am assuming you "your LASR staging" is the same as my ODBC library. Again thanks for the info.

JuanS_OCS · ‎04-15-2018

Hello @L2Fly, as you might be aware, the gemfire, as any other web app server, is a JVM (a Java Virtual Machine), which has some known memory boundaries, as Heap sizes and Garbage Collection loads. If you would analyze the service with SAS Environment Manager or a JMX Console, you could have some clues on what goes wrong. I can think on several options: handled log too large (solution: change configuration to rollover smaller logs), GC is too high/reaching heapsize limit (solution: further analysis of logs to know more about it)... etc. In the end and in short, the best way to understand your problem is to analyze your logs (increasing the info level to debug level if required) and the status of your memory. The causes could be many.

L2Fly · ‎04-08-2018

Perfect, thanks for the info.

AndrewHowell · ‎04-08-2018

The ice hockey Sat night was awesome - Go Avs!!! So who’s up for baseball Sunday afternoon?

L2Fly · ‎02-24-2018

Hi @SASKiwi, agree with you and again thank you for your time and info. Best

alexal · ‎02-06-2018

@L2Fly, With that libname statement, everything should work. @nhvdwalt, That's funny, thanks. Sometimes, all you need is just a second pair of eyes.

Online Status	Offline
Date Last Visited	‎02-05-2019 08:32 PM

Re: List of dataset names in a library is differ from the list based o...

Re: List of dataset names in a library is differ from the list based o...

Re: List of dataset names in a library is differ from the list based o...

Re: List of dataset names in a library is differ from the list based o...

List of dataset names in a library is differ from the list based on a ...

Change the color of a column with External Link

Re: How to loop through a proc sql select statement result

Re: How to loop through a proc sql select statement result

Re: How to loop through a proc sql select statement result

Re: How to loop through a proc sql select statement result

Re: How to add Description to a LASR table when loading it via code an...

Re: Dress Code

Dress Code

Re: How to display row numbers in SAS Enterprise Guide?

Re: LogConfigSweeper tool for automated log and configuration data col...

Re: How to loop through a proc sql select statement result

Re: Load SAS LASR Servers with script

Re: Understanding SAS working directory and Orphaned folders

Re: Can you use a batch file .bat to start a SAS Flow object under Sch...

Can you use a batch file .bat to start a SAS Flow object under Schedul...

Re: LogConfigSweeper tool for automated log and configuration data col...

Re: List of dataset names in a library is differ from the list based o...

Re: Change the color of a column with External Link

Re: How to loop through a proc sql select statement result

Re: Load SAS LASR Servers with script

Re: Understanding SAS working directory and Orphaned folders

Re: Can you use a batch file .bat to start a SAS Flow object under Sch...

Re: URL referer from internal site to SASVisualAnalyticsHub site Error...

Re: How to add Description to a LASR table when loading it via code an...

Re: LASR table name standards

Re: HTTP Status 500 - GemFire on <HostName>(7959)<v18>:36179/45490: Me...

Re: I am new in SAS Admin Role, love to meet some SAS Admin's while I ...

Re: What to do in Denver?

Re: Changing measure to category upon loading the lasr

Re: Print list of datasets in LASR

SAS Global Forum 2018