topic Re: Auto Loading data for auditing reports in SAS VA in SAS Visual Analytics

Auto Loading data for auditing reports in SAS VA

Karthikk — Mon, 13 Mar 2017 08:14:22 GMT

Hi,

I am trying to auto load the data to enable the Audit_Analytics in LASR server. I am using SAS 7.3. The steps I followed are

Open the SAS Management Console and connect to your SAS Metadata server as an administrator

i.Select the Plug-ins tab

ii.Select Application Management ➤SAS Application Infrastructure ➤ Visual Analytics 7.3

iii.Right-Click on “Visual Analytics 7.3″ and choose Properties

iv.On the “Visual Analytics Properties” panel, Select the Advanced tab

v.On the Advanced tab, edit the “va.AuditingEnabled” property and change its value to “true”

vi.Then Click the “OK” button to save your change

Restart the SAS Web application services.
Start the LASR services
Run the runsas.bat from below similar location with the same user through which you start the LASR server

<SASCONF>\Lev1\Applications\SASVisualAnalytics\VisualAnalyticsAdministrator\EVDMLA

Post that you should login to VA Hub and go to LASR tab to see if the AUDIT_VISUALANALYTICS table is loaded or not.

But still i am unable to enable the data in SAS VA which means it is still showing the status as RED colored. The log details are

AUTOEXEC processing beginning; file is C:\SAS\Config\Lev1\SASApp\appserver_autoexec.sas.

NOTE: AUTOEXEC processing completed.

1 /*
2 * AutoLoad
3 *
4 * Purpose: Synchronizes SAS data sets placed in a single disk location with
5 * a single LASR Analytic Server library defined in metadata.
6 *
7 */
8
9 /* Set the name of the LASR library to which to Auto Load */
10 %LET AL_META_LASRLIB=Environment Manager Data Mart LASR;
11
12 /* Include and execute main AutoLoad functionality */
13 %LET INCLUDELOC=D:\Program
13 ! Files\SASHome\SASVisualAnalyticsHighPerformanceConfiguration\7.3\config\Deployment\Code\AutoLoad/include;
14
15 /* ------- No edits necessary below this line -------- */
16 filename inclib "&INCLUDELOC.";
17 %include inclib ( AutoLoadMain.sas );
3832 %AutoLoadMain;
No matching SASLibrary objects found. (RC=-4 )
ERROR: LASR Auto Load directory MISSING does not exist.
ERROR: LASR Auto Load directory MISSING\Logs does not exist.
ERROR: LASR Auto Load directory MISSING\Append does not exist.
ERROR: LASR Auto Load directory MISSING\Unload does not exist.
ERROR: LASR Auto Load directory validation failed.
ERROR: Ensure that connection to metadata server is configured properly
ERROR: and that the proper autoload folder structure exists.

Kindly help me in solving this issue. Its urgent.

Regards,

Karthik

Re: Auto Loading data for auditing reports in SAS VA

JuanS_OCS — Mon, 13 Mar 2017 08:22:23 GMT

Hello @Karthikk,

you need to apply a very similar configuration as what you have on the normal autoload folder (if you have it enabled).

To make an Autoload folder to work (this one counts as Autoload), you will need to schedule the autoload script, with the appropiate user, with metadata access, and the correct metadata rights to access the appropiate metadata objects (LASR server, library, folders, tables, etc). This user will need the access also to the filesystem where the scritps are present and where the data is present.

Re: Auto Loading data for auditing reports in SAS VA

Karthikk — Mon, 13 Mar 2017 08:56:23 GMT

Hello JuanS,

Thanks for the immediate reply. I am sorry to say this but I am actually new to this admin responsibilities so i did not understand it properly.

Kind request is that if you could share a doc which has detail steps or if you could explain me in a step by step with example that will be of great help.

Also Did not understand about the permissions and schedule script in what you have mentioned.

All I did was follwed the above steps to enable the data but it did not work.

Regards,

Karthik

Re: Auto Loading data for auditing reports in SAS VA

JuanS_OCS — Mon, 13 Mar 2017 09:14:30 GMT

Hello @Karthikk,

I would strongly recommend you to read the Administration guide for Visual Analytics ( http://support.sas.com/documentation/onlinedoc/va/7.3/en/vaag.pdf ), specially the following chapters:

Autoload, page 22
Key Actions Auditing, page 48

What user do you use to start the LASR services and load the data? That is the user you would probably need to sechedule your Autoload process (the lasradm user?) . THis user should be part of the Data Administratros and the Visual Analytics Administrators metadata groups, and have sufficient OS permissions.

Re: Auto Loading data for auditing reports in SAS VA

Karthikk — Mon, 13 Mar 2017 09:26:57 GMT

Hello JuanS,

I used SASAdmin to make changes and to restart SAS web app services also which has all permisions given to the user.

Using this user only I ran runsas.bat file which will be located in Lev1\Applications\SASVisualAnalytics\VisualAnalyticsAdministrator\EVDMLA.

Regards,

Karthik

Re: Auto Loading data for auditing reports in SAS VA

JuanS_OCS — Mon, 13 Mar 2017 09:34:53 GMT

Hello @Karthikk,

I understand SASAdmin is a Windows user, with local administration permissions. Is this correct?

Is this user registered in the SAS Metadata?What groups is this user part of, in the SAS Metadata?

Maybe I am wrong, but probably it would be good for you to attend a couple of SAS courses, SAS Intelligence Platform Administration and SAS Visual Anlytics Administration. The secod one will specially help you on this process, and give you some hints about metadata permissions. The first one will give you a good overview on how the SAS metadata works.

Re: Auto Loading data for auditing reports in SAS VA

Karthikk — Mon, 13 Mar 2017 09:40:31 GMT

Ok JuanS. Thank you for your time.

Regards,

Karthik