SAS Support Communities

milts · ‎04-12-2018

I'm getting an error when I import my folder that contains VA Reports Error shows this: 501:Not Implemented' error while accessing 'http://<server>:80/SASContentServer/repository/default/sasfolders/<foldername>' Any leads on how to troubleshoot this? Is this some permissions related? I'm using sasadm@saspw to import the spk files.

milts · ‎04-05-2018

Hi @alexal, Sorry for the late response as I just managed to check today. Version for sas.lasr.mgmt in the picklist is 703000.0.1.201504031272710.d4bicomr9 I was trying to monitor the behavior as well the past few days of the servers. Yesterday's run completed without any problems. Today's run failed. I tried to rerun it and the first one failed, and another run was successful. So it seems that it's some network issue that suddenly connection gets tripped between our Metadata and VA Server. Sorry for the silly question, but what is an ICF? Is this something that will ensure that connection across SAS Servers are always up? Thanks again for the assistance!

milts · ‎04-03-2018

This is quite generic and perhaps you could post additional info/screenshots/logs regarding the error you got. People in the community will be able to help you out more if you provide some of this stuff. Some questions: Have you checked if the services for your WebApp Servers are up and running? Did you restart all the services in the correct sequence?

milts · ‎04-03-2018

Hi @alexal, I'm unable to post the entire log here as it's on the client's server. But yes, there are some errors in the log file which starts with this line com.sas.lasr.LASRException: java.net.SocketTimeoutException: Read Timed Out Could this be some network problem? But strange thing is that my other task which that is also doing some loading to LASR library and even has bigger tables was loaded successfully. An observation from today's batch is that it still failed. Then triggered a rerun of the batch and it was loaded successfully. Is there such thing that the LASR library gets too busy loading multiple tables to VA that the connection for incoming ones our dropped? Apologies if my thoughts on the error are a bit odd as I am not fully knowledgeable on how VA works in the back end.

milts · ‎04-02-2018

Both jobs are identical except for the task name. Batch script being called is also the same that's why it's strange. Service account is not defined in SAS Metadata. I'll be checking the logs based from the link you have shared and update you again. Anyway, I was trying to check other factors. I have another task which also loads a different set of sas datasets to VA. When the faulty task above triggers, the other task is actually running. Is there some limitation on the concurrency of tables that can be loaded to VA?

milts · ‎04-02-2018

I would like to check on what's the behavior of SAS VA when let's say I unload a table then delete it through VA Administrator page. Afterwards, I load the table again, same name and no changes. With the tasks done above, do I need to re-map the VA table to the reports in which they were used? Or would SAS VA be able to load the report with no issues? This is with an assumption that the VA table was loaded into the SAS LASR Library and respective folders in SAS Metadata. Thank you!

milts · ‎04-01-2018

I keep getting this error on one of my VA tables. Others are working fine and I've checked the permissions that it's the same for all the tables. Other infor: This is executed through Windows Task Scheduler by a service account (with logon as batch job permissions) Service account has full control on physical paths related to VA(Monitoring, PID, Logs, etc) Service account triggers the task but internal account sasadm@saspw is used to initialized the LASR library The task runs 2 times daily. One at 7:45am then another at 1:45pm. The morning one always fails and the afternoon completes w/o errors. Does the SAS Auto-load do something with it? Our Auto-Load task runs every hour (6am, 7am, ...). Any idea how to resolve such error? MPRINT(RELOADINTOLASR): data LASRLIB.vatable; MPRINT(RELOADINTOLASR): set saslib.source; MPRINT(RELOADINTOLASR): run; ERROR: Metadata Server denied access to operation. ERROR: Member or library LASRLIB.VATABLE.DATA unavailable for use. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1062 observations read from the data set SASLIB.SOURCE. WARNING: The data set LASRLIB.vatable may be incomplete. When this step was stopped there were 1062 observations and 18 variables. ERROR: Metadata Server denied access to operation. ERROR: Member or library LASRLIB.VATABLE.DATA unavailable for use.

milts · ‎03-22-2018

Sorry there's a mismatch between on my initial example and the script I copied over from the server. Anyway, many thanks for your example as I finally got the missing portion that is required on my script which is this portion. compute after region; subsidiary = 'TOTAL'; endcomp;

milts · ‎03-21-2018

Hi, Sorry for the ambiguity of my post. Here's the script that I currently have. If I remove the suppress on the break statement, I'll have the Group Total still on column 1. What I would like to do is to have the TOTAL label placed on column 2. I know that this can also be done in proc tabulate but the client wants it to be on proc report. I'm not sure how it can be done and greatly appreciate inputs. proc report data=mydata; column group user monthend; define group / group 'Group'; define user / group 'User'; define monthend / across ''; break after group / summarize suppress; run; Current (if suppress is removed): Group User Jan Feb Mar Apr May Jun Total Group 1 A 12 43 8 23 76 9 171 B 32 65 86 12 12 43 250 C 12 34 23 12 6 12 99 Group 1 56 142 117 47 94 64 520 Group 2 A 0 0 0 0 0 0 0 B 1 1 0 0 0 1 1 Group 2 1 1 0 0 0 1 1 Desired: Group User Jan Feb Mar Apr May Jun Total Group 1 A 12 43 8 23 76 9 171 B 32 65 86 12 12 43 250 C 12 34 23 12 6 12 99 TOTAL 56 142 117 47 94 64 520 Group 2 A 0 0 0 0 0 0 0 B 1 1 0 0 0 1 1 TOTAL 1 1 0 0 0 1 1

milts · ‎03-20-2018

How will I be able to generate this layout using proc report where the "TOTAL" label is on the User column and not on the Group column? Group User Jan Feb Mar Apr May Jun Total Group 1 A 12 43 8 23 76 9 171 B 32 65 86 12 12 43 250 C 12 34 23 12 6 12 99 TOTAL 56 142 117 47 94 64 520 Group 2 A 0 0 0 0 0 0 0 B 1 1 0 0 0 1 1 TOTAL 1 1 0 0 0 1 1

milts · ‎02-21-2018

Thanks for the lead. I've managed to check the contents of the log. Unfortunately I didn't see any info regarding the email. Is the logging configuration for SASServer12_1 be set to a certain level (INFO/DEBUG/ERROR) to get reflected in the log? I've also gone through the other logs in SASServer12_1 (Transport, Viewer, Designer, etc.) but didn't see any info on the email as well.

milts · ‎02-20-2018

Does anyone know how the email functionality in SAS VA works? Does it launch a workspace and sends the email through SAS code or is it a different method? Reason is that we want to track down an issue where the sending of email through SAS VA sometimes takes a while before recipient gets the mail. We want to capture in the log the portion that indicates the email has been sent versus the time recipient actually gets it. It can also be that the bottleneck is somewhere in there mail servers so we're trying to check out all possibilities. I already checked the following locations below and couldn't find logs referring to the email process. <SASConfig>/Lev1/Web/Logs/SASServer12_1 <SASConfig>/Lev1/Web/WebAppServer/SASServer12_1/logs <SASConfig>/Lev1/SASApp/WorkspaceServer/Logs Greatly appreciate any leads to this.

milts · ‎12-05-2017

We are calling the user import macro %mduchglb to insert groups and users to the SAS metadata. We see some inconsistencies with the resultsas when we process the loading for all users, it fails with an error "object reference to Person was requested without an identifier". But let's say we only process one user at a time, it will be assigned to all groups mapped to it. We tried to sort the canonical tables before calling the macro and it resolves some, but still has some failures. While processing each user one at a time can be a workaround, it will not be scalable as processing time will definitely increase if we will be managing 1000+ users. Is there some limit to the number of records the import macro can process? Or some order on the tables being used for the processing? Greatly appreciate any thoughts or inputs on this. Example: User 1 assigned to 5 groups User 2 assigned to 4 groups User 3 assigned to 4 groups User 4 assigned to 2 groups User 5 assigned to 5 groups Result: User 1 assigned to 5 groups User 2 assigned to 4 groups User 3 assigned to 3 groups User 4 assigned to 2 groups User 5 assigned to 3 groups

milts · ‎10-05-2017

Sorry I'm unable to extract the whole log as it's residing on a client machine. But error I get is this one: ERROR: Unable to transcode data to/from UCS-2 encoding.

milts · ‎09-28-2017

As a workaround I had to split the column to 16k each on my sql query then concatenate them when creating the sas dataset and assigning a length of 32000. My next problem now is to resolve the same transcoding error when writing the processed data back to sql. I'm using a proc append to a sql table. In my libname I have defined dbmax_text=32000 in my libname statement. proc append base=sqllib.myoutput data=extract_processed force; run; Are there other workarounds for this or I really won't be able to writeback a 32k length field into a nvarchar(max) datatype in sql?

Online Status	Offline
Date Last Visited	‎05-12-2018 02:19 AM

SAS Support Communities

Error when importing SPK Files with VA Reports

Re: Metadata Server Denied Access to Operation when loading SAS datase...

Re: 500 Internal Server Error An error occurred. Please contact your s...

Re: Metadata Server Denied Access to Operation when loading SAS datase...

Re: Metadata Server Denied Access to Operation when loading SAS datase...

Impact of Deleting and Reloading Tables in SAS VA Reports

Metadata Server Denied Access to Operation when loading SAS dataset to...

Re: SAS PROC Report Totals on Second Column

Re: SAS PROC Report Totals on Second Column

SAS PROC Report Totals on Second Column

Re: Metadata Server Denied Access to Operation when loading SAS datase...

Re: Metadata Server Denied Access to Operation when loading SAS datase...

Re: Metadata Server Denied Access to Operation when loading SAS datase...

Re: SAS Visual Analytics Email Log

Re: Macro %mduchglb behaves incosistently

Re: A problem with integrity constraint

Impact of Deleting and Reloading Tables in SAS VA Reports

SASUSER Library ?FOLDERID_Documents\My SAS Files\9.4 Fails on Task Sch...

Re: Adding Authentication Domain for SQL Server

Re: SAS Config Files Sequence

Error when importing SPK Files with VA Reports

Re: Metadata Server Denied Access to Operation when loading SAS datase...

Re: 500 Internal Server Error An error occurred. Please contact your s...

Re: Metadata Server Denied Access to Operation when loading SAS datase...

Re: Metadata Server Denied Access to Operation when loading SAS datase...

Impact of Deleting and Reloading Tables in SAS VA Reports

Metadata Server Denied Access to Operation when loading SAS dataset to...

Re: SAS PROC Report Totals on Second Column

Re: SAS PROC Report Totals on Second Column

SAS PROC Report Totals on Second Column

Re: SAS Visual Analytics Email Log

SAS Visual Analytics Email Log

Macro %mduchglb behaves incosistently

Re: Extract SQL Server data with NVARCHAR(max) data type

Re: Extract SQL Server data with NVARCHAR(max) data type

Follow Us

What is...