topic Re: Problem with audit report in SAS VA 7.3 in SAS Visual Analytics

Problem with audit report in SAS VA 7.3

efd-hkg — Wed, 06 Sep 2017 15:45:12 GMT

Hello everyone

I have a problem with accessing the audit report. I have tried following guides/videos like this https://communities.sas.com/t5/SAS-Communities-Library/Getting-started-with-SAS-Visual-Analytics-7-1-Audit-Reports-for/ta-p/223514, but with no luck.

I think the problem occurs because the "AUDIT_VISUALANALYTICS"-table cannot be loaded/generated:

As I interpret the guide, then by setting "va.AuditingEnabled" to "true" will generate a table in the folder "[SAS-Configuration-Directory]\Levn\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\EVDMLA", but this does not seem to happen... and this could be the reason that I cannot load the table in SAS VA, I guess?

Another problem that I also have is, that when I try to open the "Administator Overview" then I will get the error "The report could not be opened":

Does this problem also occur because there has not been generated an audit-table?

I have both restarted the server and started the AutoLoad for the library EVDMLA multiple times but still with no luck....

I hope you have any ideas to what the problem could be.

Thanks in advance!

Re: Problem with audit report in SAS VA 7.3

alexal — Wed, 06 Sep 2017 17:38:00 GMT

@efd-hkg,

Enabling auditing starts a process which extracts the data from the Postgres database and copies it to the Append directory of the EVDMLA library. This process uses the Visual Data Builder web application and the SAS Pooled Workspace to perform the extraction.

To debug any problems in the process, you can configure additional logging on the Visual Data Builder web application and the Pooled Workspace server. For SAS Visual Data Builder, add the following XML to the /<SASConfig>/Lev<X>/Web/Common/LogConfig/SASVisualDataBuilder-log4j.xml and restart the Web Application Server.

<category additivity="false" name="com.sas.svcs.content.vdq.batch.audit">
<priority value="INFO"/>
<appender-ref ref="SAS_CONSOLE"/>
<appender-ref ref="SAS_FILE"/>
</category>

The result will be that the extraction process writes a note to the log on the middle tier machine at /<SASConfig>/Lev<X>/Web/Logs/SASServer12_1/SASVisualDataBuilder7.3.log. You can see that it runs the extract every 15 minutes.

in the Pooled Workspace Server set the level of the App.Program logger to INFO in /<SASConfig>/Lev<X>/SASApp/PooledWorkspaceServer/logconfig.apm.xml (or logconfig.xml) and restart the Object Spawner.

<logger name="App.Program" immutability="false">
<level value="INFO"/>
</logger>

The result will be that the extraction process writes a note to the log on the compute machine at /<SASConfig>/Lev<X>/SASApp/PooledWorkspaceServer/Logs/ showing the audit records being coped to the audit_visualanalytics table in the Append directory of the EVDMLA autoload location at /<SASConfig>/Lev<X>/AppData/SASVisualAnalytics/ VisualAnalyticsAdministrator /AutoLoad/EVDMLA/Append.

Do you see anything like that in your environment?

Re: Problem with audit report in SAS VA 7.3

efd-hkg — Thu, 07 Sep 2017 08:55:05 GMT

Hi @alexal, thanks for your reply!

It does not seem to have an effect, when I do the things as you suggest.

Just to make things clear, I did the following:

I copy-pasted the following code into the XML file "SASVisualDataBuilder-log4j.xml, and then I restarted the SASServer1_1.

<category additivity="false" name="com.sas.svcs.content.vdq.batch.audit">
<priority value="INFO"/>
<appender-ref ref="SAS_CONSOLE"/>
<appender-ref ref="SAS_FILE"/>
</category>

When I open "SASVisualDataBuilder7.3.log", it is empty... It seems like the changes have never been made...

For the Pooled Workspace Server I copy-pasted the following code in to "logconfig.apm.xml" and restarted the Object spawner:

<logger name="App.Program" immutability="false">
<level value="INFO"/>
</logger>

Yet again, nothing really seems to happen... However, yesterday I got the following log:

Does this log-file say anything important?

Thanks!

PS. should I restart all the three Web App Servers?

Re: Problem with audit report in SAS VA 7.3

Madelyn_SAS — Thu, 07 Sep 2017 13:28:17 GMT

This troubleshooting note might be helpful. It contains more details about the logging at the bottom. It also has a checklist that you should review.

http://support.sas.com/kb/60/182.html

Re: Problem with audit report in SAS VA 7.3

alexal — Thu, 07 Sep 2017 13:35:45 GMT

@efd-hkg,

It does not seem to have an effect, when I do the things as you suggest.

Your compute tier and your middle tier (where SAS Visual Analytics is deployed) are on the same physical machine? If they are on different machines and they are using the same operating system, then extra steps are required to enable auditing. For details, see the topic "Deployment Topology Considerations" in the SAS Visual Analytics Administration Guide. If your compute tier and your middle tier are on different physical machines, and they are using different operating systems, then auditing is not supported.