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

VA Data Query export error

Accepted Solution Solved
Reply
Contributor
Posts: 45
Accepted Solution

VA Data Query export error

Hello All,

 

I am getting an error as below while exporting a data query from sas SMC,Though i have unrestricted access.

INFO - Log file created: C:\Users\SOduru\AppData\Roaming\SAS\Logs\Export_170517161534.log
INFO - Current Time: 17 May 2017 4:15:34 PM
INFO - User Name: SOduru
INFO - ******** Analyzing Objects ********
INFO - ******** Starting Export Process ********
INFO - Exporting objects to package: C:\Users\SOduru\Documents\Package8.spk
INFO - Exporting the following objects:
1 Visual data query object:
/Shared Data/ETL_JOBS/Vault/DataQuery/CUSTOMER_ADDRESS_DQ

INFO - ******** Exporting Metadata ********
INFO - Metadata exported successfully.
INFO - ******** Exporting Content ********
INFO - Exporting content for Visual data query objects.
INFO - Reading content for visual data query "CUSTOMER_ADDRESS_DQ"
ERROR - Could not retrieve the database information for visual data query "CUSTOMER_ADDRESS_DQ". Reason java.util.Hashtable.put(Hashtable.java:514)
com.sas.databuilder.metadata.QueryDbUtil.updateContext(QueryDbUtil.java:200)
com.sas.databuilder.metadata.QueryDbUtil.setConfiguration(QueryDbUtil.java:231)
com.sas.databuilder.metadata.QueryDbUtil.getQuery(QueryDbUtil.java:420)
com.sas.databuilder.metadata.QueryDbUtil.getQueryReader(QueryDbUtil.java:505)
com.sas.databuilder.metadata.VisualDataQueryExportListener.exportContent(VisualDataQueryExportListener.java:111)
com.sas.metadata.promotion.ExportHandler.exportContent(ExportHandler.java:596)
com.sas.metadata.promotion.ExportHandler.runExport(ExportHandler.java:519)
com.sas.metadata.promotion.visuals.ExportExecutePanel$ExportThread.launchOperation(ExportExecutePanel.java:76)
com.sas.metadata.promotion.visuals.AbstractExecutePanel$ExecutionThread.run(AbstractExecutePanel.java:437)

 

Please kindly help me to resolve this issue.

 

Thanks & Regards,

Sandeep.o


Accepted Solutions
Solution
2 weeks ago
Super User
Posts: 993

Re: VA Data Query export error

[ Edited ]

Hello @sandeep_reddy,

 

is your VA server configured with certificates, meaning, do you access VA with https (with s, after http) on the URL?

 

If this the situation, you might require to import the certificates (CA, Intermediate, and server certificate) into the SASPrivateJRE java store on each client.

 

A good way to test if you require to do this, is to try to validate your SAS Content Server from each SAS Management Console. If you get a PKIX error, then you need to import the certificates.

View solution in original post


All Replies
SAS Employee
Posts: 57

Re: VA Data Query export error

Hi Sandeep,

 

It might be a better option for you to raise that issue with your Technical Support.

 

Regarding the SMC instance you're using, you'll have to check what is installed.

Usage Note 55607 (SAS® Management Console might not enable you to use the promotion tools to move SAS® Visual Analytics content objects) might be relevant to the behaviour you're experiencing.

 

(If logical types are missing and you won't get a chance in the short term to add them, you may want to perform the same action from your MidTier/WebTier server for instance, if the SMC is installed there).

 

Hope that helps.

 

Cheers,

Damo

Contributor
Posts: 45

Re: VA Data Query export error

Hi Damo,

 

I have checked in my both compute and mid tier servers all Logical types are installed properly. Issue is with one user is able to perform and another user is not able to. Both users have unrestricted access only and have both execute and viwe and admin rights as well.

 

Please kindly let me know if any thing i can check to resolve this issue.

 

Thanks & Regards,

Sandeep.o

SAS Super FREQ
Posts: 384

Re: VA Data Query export error

[ Edited ]

For immediate relief, I would suggest trying the export using a copy of SAS Management Console installed on the middle tier where Visual Analytics is deployed.

 

Possible causes of the issue are:

  • You are missing the Visual Analyics logical types on the computer where you are seeing the error per SAS Note http://support.sas.com/kb/55/607.html
  • The Visual Analytics web application server is not running when you attempt the export
  • The query itself is corrupt.  Do you get the same error with any query? 

 

 

 

 

Contributor
Posts: 45

Re: VA Data Query export error

Hi Madelyn,

I have checked in my both compute and mid tier servers all Logical types are installed properly. Issue is with one user is able to perform and another user is not able to. Both users have unrestricted access only and have both execute and view and admin rights as well.

Please kindly let me know if any thing i can check to resolve this issue.

Thanks & Regards,
Sandeep.o
SAS Employee
Posts: 57

Re: VA Data Query export error

Hi @sandeep_reddy

 

Is one of the user an internal account (@saspw) ? It could be the reason if that user does not have an external identities (and can't launch a Workspace Server).

 

If that does not help you, you should really be in touch with your SAS Technical Support, that way you can share the complete log, users' definitions, etc. This is the best avenue.

 

Cheers,
Damo

Solution
2 weeks ago
Super User
Posts: 993

Re: VA Data Query export error

[ Edited ]

Hello @sandeep_reddy,

 

is your VA server configured with certificates, meaning, do you access VA with https (with s, after http) on the URL?

 

If this the situation, you might require to import the certificates (CA, Intermediate, and server certificate) into the SASPrivateJRE java store on each client.

 

A good way to test if you require to do this, is to try to validate your SAS Content Server from each SAS Management Console. If you get a PKIX error, then you need to import the certificates.

Contributor
Posts: 45

Re: VA Data Query export error

Hi Juan,
Thanks for the solution..
Yes ,My content server has given me the same error when i try to validate ,but all certificates are in place . Please kindly let me know where i can check for this path
javax.net.ssl.trustStore=!SASHOME/jre1.5_SR5/jre/lib/security/jssecacerts.
Thanks & Regards,
Sandeep.o

SAS Employee
Posts: 57

Re: VA Data Query export error

Hi @sandeep_reddy

 

Are you wondering what the !SASHOME reference is?

It is where all your SAS binaries are installed (SAS Foundation, etc.)

 

Said that, you mentioned earlier that out of 2 users, 1 has the problem, not the other one.

Did you run the test on the same machine or did you use a separate machine per user?

What I'm saying is that if you used only one machine to conduct both tests, the issue might not be related to the certificate (has both users would use the same configuration in that case).

But if you use the same user on 2 separate machines, the certificate might be the cause of the problem.

 

Cheers, 

Damo

Contributor
Posts: 45

Re: VA Data Query export error

Hi Damo,

I am just confused with SASHOME directory which is in client and What we call SASHOME in servers.

 

From servers i have exported and imported the packages successfully . The issue is with client machines and i have validated all the certificates. All certificates are in place . Is there something i need to add in sasmc.ini file in client machine.

 

Much awaited for your responce,

 

Thanks in Advance,

Sandeep.

SAS Employee
Posts: 57

Re: VA Data Query export error

Hi @sandeep_reddy

 

SASHOME concept is the same on any machine (you just won't find the same components installed in both).

 

Now I will reiterate my previous advice about contacting Technical Support https://support.sas.com/techsup/contact/

They'll be able to compare your deploymentregistry reports, review logs, etc. and assist you in a better timely manner (and they'll be in your timezone too Smiley Very Happy)

 

Cheers,

Damo

Post a Question
Discussion Stats
  • 10 replies
  • 135 views
  • 2 likes
  • 4 in conversation