topic Re: VA Data Query export error in SAS Visual Analytics

VA Data Query export error

sandeep_reddy — Wed, 17 May 2017 06:21:40 GMT

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

Re: VA Data Query export error

Damo — Wed, 17 May 2017 12:24:05 GMT

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

Re: VA Data Query export error

Madelyn_SAS — Thu, 18 May 2017 00:50:39 GMT

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?

Re: VA Data Query export error

sandeep_reddy — Thu, 18 May 2017 03:56:28 GMT

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

Re: VA Data Query export error

sandeep_reddy — Thu, 18 May 2017 03:57:28 GMT

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

Re: VA Data Query export error

Damo — Thu, 18 May 2017 07:19:51 GMT

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

Re: VA Data Query export error

JuanS_OCS — Thu, 18 May 2017 11:11:15 GMT

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.

Re: VA Data Query export error

sandeep_reddy — Thu, 18 May 2017 15:07:41 GMT

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

Re: VA Data Query export error

Damo — Fri, 19 May 2017 08:27:37 GMT

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

Re: VA Data Query export error

sandeep_reddy — Fri, 19 May 2017 08:33:47 GMT

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.

Re: VA Data Query export error

Damo — Fri, 19 May 2017 09:31:18 GMT

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 )

Cheers,

Damo

Re: VA Data Query export error

Creeback — Fri, 19 Jan 2018 17:00:44 GMT

Work for me. Thanks =D