Friday
gwootton
SAS Super FREQ
Member since
03-28-2016
- 1,481 Posts
- 226 Likes Given
- 283 Solutions
- 570 Likes Received
-
Latest posts by gwootton
Subject Views Posted 73 Friday 57 Friday 57 Wednesday 71 Wednesday 445 Tuesday 493 2 weeks ago 557 2 weeks ago 580 2 weeks ago 253 2 weeks ago 300 3 weeks ago -
Activity Feed for gwootton
- Posted Re: SASInformationRetrievalStudioforSAS is not up on Administration and Deployment. Friday
- Posted Re: Help running sas-viya batch job submissions on Administration and Deployment. Friday
- Posted Re: Viya FLOW job with warnings return code on SAS Viya. Wednesday
- Posted Re: Request for Assistance with Enabling BigQuery Connector in SAS 9.4 on Administration and Deployment. Wednesday
- Posted Re: Where to find the .nmon log file on Administration and Deployment. Tuesday
- Posted Re: SAS Logs from LSF Scheduled jobs on Administration and Deployment. 2 weeks ago
- Posted Re: SAS Logs from LSF Scheduled jobs on Administration and Deployment. 2 weeks ago
- Posted Re: SAS Logs from LSF Scheduled jobs on Administration and Deployment. 2 weeks ago
- Posted Re: "sas-files" pod fail with OOM in Viya 4 on Administration and Deployment. 2 weeks ago
- Got a Like for Re: MS Sql connection in SAS Viya4. 2 weeks ago
- Posted Re: sas-airflow-provider TCP keep alive on Administration and Deployment. 3 weeks ago
- Posted Re: sas-airflow-provider TCP keep alive on Administration and Deployment. 3 weeks ago
- Posted Re: PostGres tables on SASWebInfrastructurePlatformDataServer on Administration and Deployment. 3 weeks ago
- Posted Re: Oauth setup for SAS VIYA on Administration and Deployment. 3 weeks ago
- Liked Re: sas-airflow-provider OAuth for misul. 3 weeks ago
- Got a Like for Re: SCHEDULED JOB TIMEOUT. 3 weeks ago
- Got a Like for Re: SCHEDULED JOB TIMEOUT. 3 weeks ago
- Got a Like for Re: sas-airflow-provider OAuth. 3 weeks ago
- Got a Like for Re: How do I find the code associated with a scheduled job?. 3 weeks ago
- Posted Re: Oauth setup for SAS VIYA on Administration and Deployment. 3 weeks ago
-
-
My Liked Posts
Subject Likes Posted 1 08-28-2024 09:38 AM 1 04-03-2024 09:04 AM 1 04-23-2024 06:29 PM 1 09-19-2023 02:12 PM 1 3 weeks ago -
My Library Contributions
Subject Likes Author Latest Post 2
Friday
See D) from the response above: If IRStudio was installed with 2.x and you have updated to 3.x, it will not work This is because when you deploy and configure, it will stage different python programs depending on whether you have python 3 or python 2 available, and populate them differently. You should engage SAS Technical Support for the supported steps on getting the python 3 compatible scripts deployed.
... View more
Friday
When using the CLI with --pgm-path, the CLI creates a "file set" with the batch service, then uploads the --pgm-path file into that file set. The file set is effectively a new folder in the path /Users/<userid>/Application Data/sas-batch/fileSets, for the userid running the batch server. This error appears to be from the folders service, saying when we tried to create that new folder we didn't specify that path. This is probably the result of the batch service call to the folders service requesting the URI for that path not returning a result, possibly due to a permissions issue on the user's folder (/Users/userid). Are you using reusable batch servers? Have you modified the default permissions to the SAS Content folders for users? The batch service log may have additional detail on the failure.
... View more
Wednesday
Code 5710 is an error code in the response from the compute service, rather than an exit code. A SAS job that encounters a warning would typically have an exit code of 1. An error results in an exit code of 2.
... View more
Wednesday
Here's the documentation on updating a SAS license: https://go.documentation.sas.com/doc/en/bicdc/9.4/whatsdiff/n0u73a9lirnetjn1l9y0iy1jd5cz.htm Here's the documentation on Establishing Connectivity to a SAS/ACCESS BigQuery Server: https://go.documentation.sas.com/doc/en/bicdc/9.4/bidsag/n0eubitpbqde80n1l6fmcskp930t.htm
... View more
Tuesday
I believe nmon writes its output to the current working directory in recording mode.
... View more
2 weeks ago
The sasbatch.sh script that is run would allow the addition of the sysparm option, but the code line built by the deploy job process does not add one. However if we just wanted the log path we could extract it from the LOG option. The issue is that we would not know the generated suffix (e.g. 2025.03.18_08.51.10.log).
... View more
2 weeks ago
I don't see anything referencing the actual file name of the log in the environment variables, macro variables or options, you could try doing something like pulling the value of the LOG option and the macro variables for the date and time (SYSTIME, SYSDATE) to try to find the file.
... View more
2 weeks ago
This isn't related to LSF, the log name is a function of the Batch Server configuration. The SAS Batch Server's logconfig.xml file defines the file name as: <param name="FileNamePattern" value="%S{App.Log}%d{yyyy.MM.dd_hh.mm.ss}.log"/> The %S{App.Log} translates to the value of the -log option. The default configuration of the Batch Server specifies the log location (<SASConfig>/Levn/SASApp/BatchServer/Logs), and it's "Advanced Properties" has a Rolling Log Options field set to "_" and Output file extension set to .lst. The Rolling Log Option could also be set to "_#Y.#m.#d_#H.#M.#s.log" if no logconfig.xml is being used. So, when you deploy a batch job, the command line built by this is: <Configured command path for batch server> -log <Configured Log Directory>/<flow_name>_<job_name><rolling log option> -print <configured output directory>/<flow_name>_<job_name><output file extension> -batch -noterminal -logparm "rollover=session" -sysin <path to job code in deployment directory> It is possible to modify the command string built by the deploy job process so this could have been changed. If the logconfig.xml file is being used, the FileNamePattern in the logconfig then uses the value of the -log option, appending the date and time to the end. If the logconfig.xml is not being used (no LOGCONFIGLOC set) then the Rolling Log Option of "_#Y.#m.#d_#H.#M.#s.log" would similarly append the date and time to the end of the log name.
... View more
2 weeks ago
I think increasing the memory limit for your files service would be an appropriate step, you could add reference in the transformers: section of your kustomization.yaml to do this, with the file having the following contents (the default is 1Gi): --- apiVersion: builtin kind: PatchTransformer metadata: name: sas-files-limits-patch patch: |- - op: replace path: /spec/template/spec/containers/0/resources/limits/memory value: 2Gi target: name: sas-files kind: Deployment The files service stores file content in the SAS Infrastructure Data Server as large objects, as well as file metadata like the file ID, content ID, file name, etc in it's database tables. The error message "ERROR: large object ####### does not exist" suggests the files service created the metadata for a file object in the database, but the actual file contents are not present in the database. This could be an artifact of the pod being killed during the file storage process. If a process requests the file content (/files/files/{file_id}/content endpoint), the files service will attempt to retrieve those contents and if the large object is not present, the error above will occur. In this case, the requests for the contents appear to be coming from sas.catalog and sas.searchIndex. Usually these errors don't cause any problems, except that the file content is not available and the request for that content would be returned an HTTP 500 response.
... View more
3 weeks ago
Consider creating an issue in Github (and a pull request if you successfully incorporate this new feature) as well.
... View more
3 weeks ago
It looks like requests.Session supports HTTP keep-alive (meaning reuse of HTTP connections). You're looking to send keepalive packets over the TCP session to prevent the 10 minute idle timeout. Other than modifying the hook to make use of the socket keepalive options in python you could try setting the sysctl ipv4.net.tcp_keepalive_time on the host running the python from the default of 7200 to something below 10 minutes (e.g. 540 -- 9 minutes)
... View more
3 weeks ago
The SAS Web Infrastructure Platform Data Server is a postgres database, so you can use any postgres client to connect to it. From your description, it is not clear what issue you are encountering when trying to use the psql client. However to be able to use the psql CLI in that path, you'd need to set some environment variables as well as some options to that command line. You could run this to set the environment variables necessary to run psql: # Set a variable to store the base path for the psql client. PGHOME=$SASHOME/SASWebInfrastructurePlatformDataServer/9.4 # Put the bin subdir into PATH PATH=$PATH:$PGHOME/bin # Put the lib subdir into LD_LIBRARY_PATH export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PGHOME/lib This will allow you to run "psql" without specifying the full path. Then run psql with the options: -p 9432 (the default postgres port is 5432, WIP Data Server runs on 9432 by default) -U dbmsowner (the database user) -d SharedServices (the database name) This will prompt you for the password for the dbmsowner user, so you will need to know that.
... View more
3 weeks ago
This means your authenticated identity is not in the identities service, so SASLogon cannot build your authentication token. This usually means either you have not configured identity provisioning, or your identity provider is using a different field for account ID than what is being sent by your OIDC provider.
... View more
3 weeks ago
You must have either discoveryUrl, tokenKey, or tokenKeyUrl populated, but no one of them is mandatory.
... View more
3 weeks ago
1 Like
This error suggests the tokenKey or tokenKeyUrl field is empty in your sas.logon.oauth.providers definition.
... View more