About mrtball

mrtball · ‎01-03-2017

Hello Both, Thank you for your responses, we managed to also get answers from our TAM & an architect who advised that this content is infact items such as VA Reports / CI Studio Campaign diagrams / Stored Processes / BI objects / Digital Content etc and the database content was the WIP Database Server (however as you mentioned Jag, this is currently on our SAS APP Server) . Many Thanks, Tom

mrtball · ‎01-03-2017

Hello, Since moving to 9.4 and the SAS Web Application Server architecture we have an issue where if we restart services/servers via BAT scripts (in order as per http://support.sas.com/documentation/cdl/en/bisag/68240/HTML/default/viewer.htm#p0d9d5nzmd8i4yn1usv2l22vpa7t.htm) And SAS web app servers in the order SAS [Config-Lev5] SASServer1_1 - WebAppServer SAS [Config-Lev5] SASServer2_1 - WebAppServer SAS [Config-Lev5] SASServer3_1 - WebAppServer SAS [Config-Lev5] SASServer4_1 - WebAppServer SAS [Config-Lev5] SASServer12_1 - WebAppServer We run into an issue where CI studio does not start - this is only fixed by then manually restarting SAS [Config-Lev5] SASServer3_1 - WebAppServer. Just wondering if anybody know of what a potential cause of this might be? And also as these are Web App Server services could it be that we don't have the correct dependencies in place? And whether during our restart's could i be a case that the SAS [Config-Lev5] SASServer1_1 - WebAppServer is not started correctly in TomCat? This seemingly only affects SAS [Config-Lev5] SASServer3_1 - WebAppServer (CI Studio Web App Server). And doesn't affect the VA server SAS [Config-Lev5] SASServer12_1 - WebAppServer. This is on Windows Server 2008. Thanks,

mrtball · ‎12-12-2016

Hello, We are currently looking into what would be required if we were to rebuild out mid-tier SAS server as part of a change to our environment. And are trying to get an understanding of how this might impact content stored. So just wondering does anybody know generally what type of physical content & databases would be affected should we have to rebuild our mid-tier server? (Are we talking WebDav / WIP / VA Reports / CI Studio Campaign etc...) I've been taking a look at http://support.sas.com/documentation/cdl/en/biwaag/69837/PDF/default/biwaag.pdf and so far not got through much of the detail in there, so thought i would also put my query on here. Many Thanks in advance. Tom

mrtball · ‎10-26-2016

Hello Madelyn, Apologies i didn't detail that, we identified that the ACM data is linked to a formats catalog in the location E:\SAS94\Config\Lev4\Web\SASEnvironmentManager\emi-framework\Datamart\evdmfmts on our SASAPP server so are moving that via CPORT / CIMPORT into the Lev1 > AppData > SASVisualAnalytics > VisualAnalyticsAdministrator > AutoLoad > Formats. location. Thanks, Tom

mrtball · ‎10-26-2016

Hello, I'm currently investigating and have a track open looking into why some but not all ACM tables do not load into memory as part of our VA autoload. We are getting the error: 'Format .... not found or couldn't be load for variable ....' We have stepped through multiple investigation steps which led ultimately to the direction of moving the ACM files from their datamart locationto the autoload location using Proc Cport / Proc Cimport splitting the format move into it's set of code (as per attached code). I've looked at various notes and performed various tests that have included: http://support.sas.com/kb/47/100.html#localized Copy formats into E:\SAS94\Config\Lev4\SASApp\SASEnvironment\SASFormats on SASAPP > restarted objectspawner re-run code. > followed by Autoload scheduled run – This did not affect the auto load of the data (and did not load all tables into memory). Restart LASR / VA server’s objectspawner > autoload scheduled run – this did not affect the autoload of the data (and did not load all tables into memory) Copy Formats catalog file into the location : /opt/sas/config/Lev1/SASApp_VAAR/SASEnvironment/SASFormats/ on the linux server > scheduled autoload – This did not affect the autoload of the data. (and did not load all tables into memory) Just wondering whether anybody here has seen this kind of behavioud before or has anything i could try to fix this? Thanks in advance,

mrtball · ‎09-05-2016

Hello Linlin, This solves my issue in terms of calculating differences across my dataset, however I dont want to run this for each record in the table everytime I insert a new row in the table - do you know if there is a function / piece of code which will basically calculate the difference between the last row and the new row being inserted and then insert the value? Also is this kind of difference calc only possible in Datastep? Thanks, Tom

mrtball · ‎07-06-2016

Hello Both, It looks like UPDATEBUFF= is limited to Oracle data sources. So the SQL Server passthrough is the most performant way forward for us. Thank you both for your repsonses. Many Thanks, Tom

mrtball · ‎07-05-2016

Hello Linus, I tried DELETE_MULT_ROWS=YES before and have just re-tried with it and it didn't offer any substational improvements. I think I maybe thought similarily to you that this LIB settings would offer improvements. I wonder if it's another LIB setting is cancelling this out or maybe a system option is specified which is meaning that this isn't working? Would you expect the Proc SQL delete to work as well as a SQL pass through? Thanks, Tom

mrtball · ‎07-05-2016

Also i've just had a quick look at how DI studio would handle a delete within a table loader transformation, and this uses a SQL pass through. I've amended my test code to a SQL server pass through and this deleted the 1.2 million records in 35 seconds. Many Thanks, Tom

mrtball · ‎07-05-2016

Hello SAS Kiwi, Thanks for your reply, please see code below... /*APPEND TO AD_HOC DATA TO EXCLUDE FROM CI JOBS*/ LIBNAME Table1 OLEDB BULKLOAD=YES PROPERTIES=('Persist Security Info'=True 'Integrated Security'=SSPI 'Initial Catalog'=DBMart) OLEDB_SERVICES=NO PROMPT=NO DATASOURCE='DB1' PROVIDER=SQLOLEDB.1 SCHEMA=dbo ; /*REMOVE DATA FROM THE AD-HOC FILE TO CORRECT MISTAKES*/ proc sql; delete from Table1.Ad_Hoc_Info where Field5 in ("L YEAR 1","L YEAR 2","L MISSING"); Quit; Yes you are right the user is looking at just deleting rows, We deleted approx 3million records for this user via SQL Server Management Studio in the end, this took a few minutes to complete. Through my testing I've not yet run the SAS delete to completion however through testing i've identified about 1,200,000 records for deletion and via monitoring this is deleting roughly 20,000 every 60 seconds so would take 1 hour to complete. Many Thanks, Tom

mrtball · ‎07-04-2016

Hello All, Following a user query linked to the user trying to run a delete on a SQL server source table/dataset and performing DBA analysis into how SAS is interacting with SQL Server - it appears that SAS is running the less performant CursorDelete against the table rather than a Delete and appears to be deleting data on a row by row basis. I'm just wondering if anybody knows how OLEDB delete performance can be improved when running the delete from SAS? (I've been looking at lib settings but haven't yet found anything that has dramatically improved performance) Many Thanks,

mrtball · ‎03-03-2016

Hello Both, Thank you for your responses, whilst preparing the 9.3 & 9.4 code comparisons to attach to this discussion it led me to running the full 9.3 code in our 9.4 environment - the output is the same (as the 9.4 output = ,,), which leads me to think this is a environment level difference (config / hot fix / maintenance release etc.) between 9.3 and 9.4 and not linked to the code in anyway. I will update with any findings. Many Thanks,

mrtball · ‎03-02-2016

Hello, We are currently in the progress of exporting SAS 9.3 DI jobs to SAS 9.4 post installation of SAS 9.4. Our basic validation to confirm that SAS 9.4 is processing data in the same way is to compare the output produced so that it matches exactly. However I have run into one DI job which in SAS 9.3 produces a .CSV export files which exports data for a variable with blank or missing values as ," ", where as in SAS 9.4 this same variable is exported as a 2 consecutive comma's i.e. ,, The column in question is char format. Just wondering does anybody know how we can correct this difference in SAS 9.4? (maybe a system option or something?) Thanks In Advance,

mrtball · ‎02-08-2016

Hello, Are you running the install from a Software depot? What are the windows/steps before you get this message? Install SAS Software > Select SAS Order > Select Products etc....? Thanks,

mrtball · ‎12-03-2015

Hello Linus, Thank you for the response, I think your points have highlighted a few things I'd not considered in particular the fact the table loader is updating the majority of the records in this instance and not inserting. Having caught up with our SQL Server DBA team they have also highlighted that as the volumes we are processed are only 700k they don't believe BulkLoad is required anyway, so we will consider potentially creating a separate library with Bulkload turned off for this 1 table for the moment. I just wonder if there is some efficiency issue that is caused when combining BulkLoad=Yes and Modify By Index (or Columns) on a table loader which when communicated to SQL Server via the SAS/ACCESS OLDEB engine it doesn't quite convert to an efficient method of processing data. Thanks,

Online Status	Offline
Date Last Visited	‎09-07-2020 10:16 AM

LSF Platform Process Manager - Global Variables - Amend on Linux Termi...

LASR Server - How to view Temp Data In memory?

Re: AUDIT_VISUALANALYTICS Table not updating

Re: AUDIT_VISUALANALYTICS Table not updating

Re: AUDIT_VISUALANALYTICS Table not updating

Re: What controls the locale of Enterprise Guide's Summary dialogue?

Re: Replacing a DDE process with the SAS Add-in?

Replacing a DDE process with the SAS Add-in?

Re: VA - SAS Report (2G) - Typename: Report.BI - Metadata Permissions?

SoftwareComponent Source? from metadata_getnobj"omsobj:SoftwareCompone...

Re: AUDIT_VISUALANALYTICS Table not updating

Re: What controls the locale of Enterprise Guide's Summary dialogue?

Re: What controls the locale of Enterprise Guide's Summary dialogue?

Re: SAS Enterprise Guide 7.1 -file navigation from a specific location

Re: Change the default location for the Files folder under SASApp serv...

Is there a way to view the physical size of SAS Data set within Enterp...

LASR Server - How to view Temp Data In memory?

Re: SAS 9.4 Mid-Tier Rebuild - Web Application Server - Physical Cont...

SAS Mid-Tier WebApplication Server Dependencies - Restarts and Web App...

SAS 9.4 Mid-Tier Rebuild - Web Application Server - Physical Content ...

Re: SAS Visual Analytics VA Autoload - EVM ACM data - Format not found...

SAS Visual Analytics VA Autoload - EVM ACM data - Format not found or ...

Re: Difference between values in two rows

Re: SQL Server OLEDB Library - SAS Passing CursorDelete to SQL Server

Re: SQL Server OLEDB Library - SAS Passing CursorDelete to SQL Server

Re: SQL Server OLEDB Library - SAS Passing CursorDelete to SQL Server

Re: SQL Server OLEDB Library - SAS Passing CursorDelete to SQL Server

SQL Server OLEDB Library - SAS Passing CursorDelete to SQL Server

Re: SAS 9.3 vs SAS 9.4 - .CSV export - 9.3 = ," ", vs ,,

SAS 9.3 vs SAS 9.4 - .CSV export - 9.3 = ," ", vs ,,

Re: SAS Client Installation

Re: SAS DI Jobs - OLEDB / SQL Server - Bulk Load=Yes Negative Impact -...