topic Re: Missing data in the Service Architecture data mart in Administration and Deployment

Missing data in the Service Architecture data mart

Nigel_Pain — Fri, 19 Jan 2024 11:58:18 GMT

SAS 9.4M7 on four Windows Server 2019 platforms (metadata, compute, mid-tier, LASR)

We recently enabled the Service Architecture but are not getting the KITS.VALASR_INFO data set in the data mart populated. I have a feeling there is something else we need to do on the LASR server to enable this to happen but I can't find the relevant documentation.

Re: Missing data in the Service Architecture data mart

gwootton — Fri, 19 Jan 2024 14:54:27 GMT

The VALASR kit reads the Visual Analytics web application logs. I think by default these don't log the actions that are stored in that table.

In <SASConfig>/Web/Common/LogConfig you should see a few files that end with .xml_apm. The difference between these files and their .xml counterparts is they create a LASRActions log.

So, if you rename the .xml files to .xml_bak for example, and the .xml_apm files to .xml, and restart SASServer12, the new log configuration should be applied and those log files would be created, and then should be picked up by the next ETL run.

Re: Missing data in the Service Architecture data mart

Nigel_Pain — Fri, 19 Jan 2024 16:13:38 GMT

Thank you Greg. This must be in the documentation somewhere? I thought I'd seen something in the past, but searched around for it unsuccessfully in both the EV and VA documentation.

Re: Missing data in the Service Architecture data mart

gwootton — Fri, 19 Jan 2024 16:27:54 GMT

I was surprised to not find much in the way of documentation for this particular kit. All I found was the readme.txt in the VALASR kit path (<SASConfig>/Levn/Web/SASEnvironmentManager/emi-framework/Kits/VALASR), that said to replace the log4j XML files with those contained in that directory into Web/Commons/LogConfig. The XML files in that path had a different log path hard-coded in them so would need to have been modified, but when I started comparing them is when I found the APM ones already there in my M7 and M8 environments.

I've made the change in one of my environments to confirm and will get the documentation updated accordingly.

Re: Missing data in the Service Architecture data mart

Nigel_Pain — Fri, 19 Jan 2024 16:31:29 GMT

Excellent! Helpful as always. Thanks very much.

Re: Missing data in the Service Architecture data mart

gwootton — Fri, 19 Jan 2024 17:47:44 GMT

@Nigel_Pain I dug into this a bit more and found that the VALASR kit appears to have been deprecated, which would explain the lack of documentation. As I understand it, now the VA Administrative Data is more detailed.

How to Provide Administrative Data
https://go.documentation.sas.com/doc/en/vacdc/7.5/vaag/n0ztu074vadeuvn17a1hpspp4bd7.htm

Re: Missing data in the Service Architecture data mart

Nigel_Pain — Mon, 22 Jan 2024 16:29:59 GMT

I think I'll have to take a bit of time to investigate that further. There are some bits I'm not understanding, and there are metadata settings which I can't find in SASMC for turning on auditing. But thanks again.