Hi Team, We are having an issue with the SAS Deployment Backup which is failing every week in the SAS Studio windows environment. The details are as follows: Error Entry: Status Code: 325 Name: COMMAND_ARCV_CHECKSUM_GENRATION_WARNING Category: GENERAL Classification: WARN Date and Time Of Error: 2022-07-17T01_06_02 Log Name: backupserver.log Log File Location: D:\SAS\Config\Lev1/Backup Operation Type: archive Originating Tier: Host: asasstu-mid1.xxx.com Configuration Directory: D:\SAS\Config\Lev1 Message: An error occurred while generating checksum. Stack Trace: Status returned by backup server is other than SUCCESS. Can anyone help me on this to proceed further.   Thanks & Regards, Siddhu1 ... View more

Hi Team, We are having an issue with the SAS Deployment Backup which is failing every week in the SAS Studio windows environment. The details are as follows: A problem occurred in executing a backup operation. Please check log files for more details. Operation name : Backup [2022-07-17T01_00_08] Operation Status : FAIL Date Time : 7/17/22 1:00 AM Environment Details Tier 1 : Host: asasstu-met1.xxx.com(Metadata Server) Configuration Directory: D:\SAS\Config\Lev1 Environment Details Tier 2 : Host: asasstu-srv1.xxx.com(Compute Server) Configuration Directory: D:\SAS\Config\Lev1 Environment Details Tier 3 : Host: asasbat-srv1.xxx.com(Batch Server) Configuration Directory: D:\SAS\Config\Lev1 Environment Details Tier 4 : Host: asasstu-mid1.xxx.com(MidTier) Configuration Directory: D:\SAS\Config\Lev1 This was a scheduled backup. It is recommended to take another clean backup by running sas-backup after recovering from the error situation. Run by: sasadm Got Exception as follows: Backup Errors Error Entry: Status Code: 314 Name: COMMAND_INTERNAL_ERROR_SCS Category: CONTENTSERVER Classification: ERROR Date and Time Of Error: 2022-07-17T01_01_05 Log Name: ContentServer.log Log File Location: D:\SAS\Config\Lev1\Backup\Logs\2022-07-17T01_00_08\backup\ContentServer Operation Type: backup Originating Tier: Host: asasstu-mid1.xxx.com Configuration Directory: D:\SAS\Config\Lev1 Message: An error occurred while running the content server backup or recovery handler. Stack Trace: The backup was ended unsuccessfully with some errors. Please check the logs!!!, com.sas.svcs.backup.server.handler.SCSBackupHandler.execute(SCSBackupHandler.java:124) com.sas.svcs.backup.server.handler.SCSBackupHandler.execute(SCSBackupHandler.java:43)... Error Entry: Status Code: 325 Name: COMMAND_ARCV_CHECKSUM_GENRATION_WARNING Category: GENERAL Classification: WARN Date and Time Of Error: 2022-07-17T01_06_02 Log Name: backupserver.log Log File Location: D:\SAS\Config\Lev1/Backup Operation Type: archive Originating Tier: Host: asasstu-mid1.xxx.com Configuration Directory: D:\SAS\Config\Lev1 Message: An error occurred while generating checksum. Stack Trace: Status returned by backup server is other than SUCCESS. Can anyone help me on this to proceed further.   Thanks & Regards, Siddhu ... View more

Hi   I want to find the list of active users and the connection time-in and out using SAS Environment manager. But in our environmment the Report center is currently unavailable, as the Service Architecture has not been initialized. So unable to see the reports related to APM and ACM. Is there any other way we can get the list of active users, using the SAS Environment manager.   Thanks & Regards, Siddhu1 ... View more

Hi, I need some help, While executing the below code in the SAS Studio environment, %let outpath=G:\Data\CXV\PGMSs\Test; %put &outpath is ; data shorts1; set sashelp.cars; run; proc export data=shorts1 outfile="&outpath/shorts.csv" dbms=csv replace; run; I was getting the below error: ERROR: Physical file does not exist, D:\SAS\Config\Lev1\SASApp1-u8/&outpath/shorts.csv. The files has been created in the config folder. So can you help us in knowing the reason how it has been created. Thanks & Regards, Siddhartha ... View more

Need to create a automated script in (Windows 2019 Servers) to clear the Log/temp files in the Midtier. We have 1meat, 1mid and 2 compute Servers. Right now we are doing it on manually, Need to automate to clear the files.   \Config\Lev1\Web\WebAppServer\SASServer1_1\logs \Config\Lev1\Web\WebAppServer\SASServer1_1\temp \Config\Lev1\Web\WebServer\logs    ... View more

Hi ,   We have an issue with SAS Studio environment , where there are some files(html, SGPanel.png, temporary excel files And .file) created in the config folder location. Which is not allowed & while investigating we came to know that no one is creating intentionally any of these files in the config location. So this is effecting on both the App Servers (SASApp1-u8 & SASApp2-en).   And when we try to change the security permissions – it’s impacting user access. Config Path: D:\SAS\Config\Lev1\SASApp1-u8                      D:\SAS\Config\Lev1\SASApp2-en   So we request  if anyone help us on identifying  which process is creating these files and how to prevent this. Any resolution on this.   Current version: 9.04.01M7 Operating System:   WX64     Thanks & Regards, Siddhartha     ... View more

Hi Team,   When I was trying to execute the program, the values in the columns m_date and c_date , they are coming in dutch language as: 21 februari 2022 and  02 maart 2022 Can anyone suggest me on this.   Thanks & Regards, Siddhartha ... View more

Hi Team, I am unable to see the files and folders in the  "server files and folders" in the SAS Studio but able to execute the sample code. Tried with Preferences -> Views Option, but unable to see the files and folders.   Could anyone help\suggest me on this.   Thanks & Regards, Siddhu1 ... View more

Hi Team, I am trying to run the sample code in both SAS PC and SAS Studio. I have noticed the variable is increased almost 3 times in SAS Studio comparatively SAS PC. Due to which the output file size has been increased almost 3 times that of SAS PC.   Note: The number of observations and variables are same , but the variable length and disk space has been varied. Can anyone help us on this. Thanks, Siddhu1   ... View more

Hi, I am just working on the large datasets(>10 TB) , want to extract the data from Oracle and DB2 and need to do data manipulation. For this should I use the implicit or explict pass through facility in extracting the data and which one is efficient in performance wise. Please let me know if there any efficiency techniques in handling the large datasets.   Thanks & Regards, Siddhu1 ... View more

Hi Team, While appending the datasets using proc append with the Force option, one variable is of different length in the source and target. I am getting the warning message that of varying lengths and the values has been truncated for this variable. WARNING: Variable Cur_City has different lengths on BASE and DATA files (BASE 22 DATA 50). NOTE: FORCE is specified, so dropping/truncating will occur. Also checked using the Proc Print, the values of curr_city has been truncated. I can't use the options varlenchk=nowarn as it is unacceptable for the warnings to suppress in the Live environment. Can anyone suggest the ideas on how to proceed further without the truncated values and warnings. Thanking You, Siddhu1 ... View more