Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Unable to import Excel file to SAS VA

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

Unable to import Excel file to SAS VA

When I upload excel file to VA, I found the following error

Due to a network issue, browser type, or large file size, the file "Test.xlsx" was not transferred to the SAS server. 

 

Please try again, try a different web browser, or contact your system administrator.

 

message explorer  log file..

com.sas.bicommon.selfserv.workspace.WorkspaceException: Could not get workspace connection

 

We can see data and report in VA.

 

 

 


Accepted Solutions
Solution
‎05-16-2018 03:28 AM
Occasional Contributor
Posts: 19

Re: Unable to import Excel file to SAS VA

Hi,

 

It is a permission issue on sas executable file and workspace log folder.

Given read and read& execute permission to users and write permission to users for workspace log folder.

Alos givne permission to the sasappva folders and access to data provider library. 

So user can invoke sasappva work space server and they can import excel file to sas va.

This note will help.

http://support.sas.com/kb/50/817.html

 

Best Regards,

Manas

View solution in original post


All Replies
Trusted Advisor
Posts: 1,852

Re: Unable to import Excel file to SAS VA

Hello @manial,

 

interesting question. I have a few questions back for you:

 

- is your SAS VA server a Linux or Windows server?

- are you loging to SAS VA with a Windows/AD/LDAP account or with a SAS internal account such as myaccount@saspw?

- It would be interesting to know if your SAS VA server's Workspace is set to have "Host Authentication" or "SAS Token Authentication"

 

The error you are receiving probably happens because the account might not be able create a proper Workspace Server. Please see this SAS Usage note http://support.sas.com/kb/52/121.html 

 

For your information, a Report Viewer (just report viewer) does not require a workspace server session, per-se, unless certain conditions are met. 

Occasional Contributor
Posts: 19

Re: Unable to import Excel file to SAS VA

Posted in reply to JuanS_OCS

Hi,

 

Thanks for the response below are the details asked:

--its a windows server

--using AD account

--Access is using server access security host authentication

 

Br,

m

SAS Super FREQ
Posts: 590

Re: Unable to import Excel file to SAS VA

On a Windows system, the most likely reason why a user cannot launch a workspace server is that user's individual, external account does not have the Log On As a Batch Job Windows privilege.

Occasional Contributor
Posts: 19

Re: Unable to import Excel file to SAS VA

Posted in reply to Madelyn_SAS

Looked at the permission found that

Users are part of SAS servers group that is already have groups in Log on As batch job.

 

We have set  the authentication option to Host from propmt. but still getting the same issue.

Object spawners is restarted. Tried connecting to SASAppVA through eg 

it given COuldnot establish a connection to SAS AppVa

 

And also the Object spawners log given below error:

The launch of the server (SASAppVA - Workspace Server) process failed with an unknown status code (9009)

 

SAS Super FREQ
Posts: 590

Re: Unable to import Excel file to SAS VA

I would suggest opening a SAS Technical Support track. It would be helpful to include the following:

 

  • Version of SAS
  • Your Site number (see Locating Your Site Number)
  • A copy of the object spawner log that contains the error messages
  • What authentication method you are using for the workspace server used by Visual Analytics (I believe you said "host")
  • The errors that you see when you attempt to access the workspace server from Enterprise Guide and Visual Analytics

 

Occasional Contributor
Posts: 19

Re: Unable to import Excel file to SAS VA

Posted in reply to Madelyn_SAS

Thanks!

Raised SAS Support Track. will update resolution once issue is resolved.

 

Br,

manas

Solution
‎05-16-2018 03:28 AM
Occasional Contributor
Posts: 19

Re: Unable to import Excel file to SAS VA

Hi,

 

It is a permission issue on sas executable file and workspace log folder.

Given read and read& execute permission to users and write permission to users for workspace log folder.

Alos givne permission to the sasappva folders and access to data provider library. 

So user can invoke sasappva work space server and they can import excel file to sas va.

This note will help.

http://support.sas.com/kb/50/817.html

 

Best Regards,

Manas

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 251 views
  • 2 likes
  • 3 in conversation