Greg , there are many ERRORS in the transfer log..... Here is an example. {"version":1,"timeStamp":"2025-04-23T19:28:56.65+02:00","level":"error","source":"sas-transfer","message":"[TRANSFER_PROMOTION_EXCEPTION] Exception occurred while importing a package.\norg .springframework.orm.jpa.JpaSystemException: Unable to access lob stream; nested exception is org.hibernate.HibernateException: Unable to access lob stream\nCaused by: org.hibernate.Hibern ateException: Unable to access lob stream\nCaused by: org.postgresql.util.PSQLException: ERROR: large object 30416 does not exist","properties":{"logger":"com.sas.transfer.domain.Promotion Manager","thread":"transfer-service-request-pool-10-thread-1"},"messageKey":"com.sas.transfer.logging.LogMessages.TRANSFER_PROMOTION_EXCEPTION"} ... View more

Jack, thank you for this advice. We do use these transfer cli commands. I will take a closer look at the Python Tools for SAS Viya. Regards, Dik ... View more

Greg , we will schedule this. I will also take a look at the log. ... View more

Doug , we now have a case with support. If there is a solution I will inform you. Thank you .   Just to inform you, this is the code we used :  proc http url="https://www.bing.com" method="GET" proxyhost="http://<ourproxy" proxyport=<ourproxyport>; run; If we went to google it works, but for certain sites we got a handshake error. ... View more

Jack , we now have a case with support. If there is a solution I will inform you. Thank you . ... View more

Thank you, with this thread and the information you gave me , we are more in control. ... View more

Mr. Gwooton I still have some job related entries for example :  select count(*) from workloadorchestrator.job_std_output ;   count ---------  4495370 (1 row)   SharedServices=# select count(*) from workloadorchestrator.job_std_output where line_txt like '%App.ComputeServer.Communication.HTTP%';   count ---------  4266126 (1 row)   SharedServices=# SELECT pg_size_pretty(pg_total_relation_size('workloadorchestrator.job_std_output')) AS table_size;  table_size ------------  3118 MB (1 row)    Do you know how we can also get rid of these entries ? I cannot find a logger with the name App.ComputeServer.Communication.HTTP   sas-viya -p $ns workload-orchestrator logs levels get | grep Loggers |awk -F"name:" '{for (i = 1; i <= NF; i++) {print $i}}'| grep -v NULL Loggers [map[level:INFO App.NLS] map[level:ERROR App.tk.HTTPC.Conn] map[level:FATAL App.tk.HTTPC.State] map[level:FATAL App.tk.HTTPC.debug] map[level:FATAL App.tk.jwtkeystore] map[level:INFO App.tk.HTTPC.DNSCache] map[level:FATAL App.tk.eam.rsa.Buffer] map[level:FATAL App.tk.eam.ssl.openssl111] map[level:ERROR App.Grid.SGMG.Log.Config.JSON] map[level:FATAL App.SQLServices.RTE.Statement] map[level:FATAL App.SQLServices.RTE.Environment] map[level:FATAL App.SQLServices.RTE.Connection.DCM] map[level:FATAL App.SQLServices.RTE.Statement.POSTGRES.stats]] ... View more

Mr.Gwooton,  I had some problems with the quoting 😉 This works for the Update CAS Audit Data, we have a lot of records, I also could have used createdBy,sas.audit.    python3 deletejobhistory.py -e -f 'eq(jobRequest.name,"Update CAS Audit data")' -p 1000 -l 100 -w   Thank you, we will add 72 hours or so,  to our jobs that don't have an expiry set. I will also take a look at the orphan script. Regards Dik   ... View more

Jack, we look into this, I will update as soon as possible. ... View more

Greg, more information :  I made a sas studio job ;  cas; %put "ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ" ; run ; Logged into postgres pod : kn exec sas-crunchy-platform-postgres-00-b56g-0 -it -- sh psql  \c SharedServices SharedServices=# select loid from pg_catalog.pg_largeobject where data like '%ZZZZZ%' ; loid --------- 6612731 6612732 6613030 6613031 6613039 6613038 6765563 (7 rows) What is in the data column ? select loid,substr(encode(data, 'escape'),1100) as data from pg_catalog.pg_largeobject where data like '%ZZZZZ%' limit 1; loid | data ---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 6612731 | kers."},{"version":1,"type":"source","line":"593 %put \\"ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ\\" ;"},{"version":1,"type":"normal","line":"\\"ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ\\""},{"version":1,"type":"source","line":"594 "},{"version":1,"type":"source","line":"595 run ;"},{"version":1,"type":"source","line":"596 %JESEND"},{"version":1,"type":"note","line":""}],"count":674,"limit":674,"links":[]} (1 row)       Login the backup pod OR another pod which has the backup directory mounted  and goto the directory where the pgdump file is and zcat the file blob_<loid>.dat.gz /sasviyabackup/20250127-010206F/__default__/postgres/SharedServices_pg_dump.dmp $ zcat blob_6612731.dat.gz | tail -40 | fold -80 | tail -10 The user is <d.pater> and the active caslib is CASUSER(<d.pater>) ."},{"version":1,"type":"note","line":"NOTE: The SAS option SESSREF was updated with the value CASAUTO."},{"version":1,"type":"note","line":"NOTE: The SAS macro _SESSREF_ was updated with the value CASAUTO."},{"version":1,"type":"note","lin e":"NOTE: The session is using 2 workers."},{"version":1,"type":"source","line": "593 %put \"ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ\" ;"},{"version": 1,"type":"normal","line":"\"ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ\"" },{"version":1,"type":"source","line":"594 "},{"version":1,"type":"source","lin e":"595 run ;"},{"version":1,"type":"source","line":"596 %JESEND"},{"version": 1,"type":"note","line":""}],"count":674,"limit":674,"links":[]} Questions : 1.is this normal behavior ?   2. Must i register a case with SAS for this behavior ?   Regards  Dik   ... View more

We see entries in the table pg_catalog.pg_largeobject, for example job history and report transfer data. We export the reports with the sas-viya cli tool. These entries are exported as blob<loid>.dat.gz  - How can I delete the job history in viya ? - For the reports we are investigating. ... View more

Greg,   thank you. I was sleeping 😉 This works. Regards,   Dik ... View more