Hey all,   I'm having troubles with management console (9.4M3) when exporting data queries. When I do an export of a data query it completes with an error (see error below).   If I import the exported query to another server I end up with a query that I cannot delete. I did found more info about this on the support page where they say its caused by missing data in the SAS Web Infrastructure Platform Database. http://support.sas.com/kb/57/237.html From this I concluded that the problem is a failed export from the SAS Web Infrastructure Platform yet I don't know how to fix this.   Some more info: - Using an unrestricted metadata user + windows admin user. - Windows 10 server   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 "INDIV_DETAIL_NL" ERROR - Could not retrieve the database information for visual data query "INDIV_DETAIL_NL". Reason org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.convertHttpInvokerAccessException(HttpInvokerClientInterceptor.java:213) org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:145) com.sas.svcs.remoting.client.SASClientTicketingProxy.invokeInternal(SASClientTicketingProxy.java:176) com.sas.svcs.remoting.client.SASClientTicketingProxy.invokeInternal(SASClientTicketingProxy.java:198) com.sas.svcs.remoting.client.SASClientTicketingProxy.invokeInternal(SASClientTicketingProxy.java:198) com.sas.svcs.remoting.client.SASClientTicketingProxy.invokeInternal(SASClientTicketingProxy.java:198) com.sas.svcs.remoting.client.SASClientTicketingProxy.invoke(SASClientTicketingProxy.java:212) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) com.sun.proxy.$Proxy9.getServiceByInterface(Unknown Source) com.sas.svcs.remoting.client.SASClientHttpServiceProxy.initialize(SASClientHttpServiceProxy.java:66) com.sas.svcs.remoting.client.SASClientTicketingProxy.invokeInternal(SASClientTicketingProxy.java:197) com.sas.svcs.remoting.client.SASClientTicketingProxy.invoke(SASClientTicketingProxy.java:212) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) com.sun.proxy.$Proxy10.generateUrl(Unknown Source) com.sas.databuilder.metadata.QueryDbUtil.getCasUrlViaUrlGenerator(QueryDbUtil.java:137) com.sas.databuilder.metadata.QueryDbUtil.setConfiguration(QueryDbUtil.java:244) 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) INFO - ******** Analyzing Connections ******** INFO - The following connections will need to be mapped to target values when this package is imported: 2 Table mappings: - INDIV_DETAIL_NL - INDIV_DETAIL_NL ... View more

Hello,   The users of my VA server are having problems when using a VPN connection. Everything works up until they try to open a report. There they get the normal loading screen but it never stops (these users use the modern view). The users who use the classic view dont have a problem when using VPN.    - On the local network no one has any problems using VA - I have found no records in the logs about the problem) - Switching between VPN and the local network alot of times fixed the problem for the used account. However I dont plan to fix this by logging in on every single account.   Did anyone experience the same problem with VPN or is this a common problem with the modern version (HTML5)? ... View more

I’m trying to automate the reload of all data into memory after a restart. The autoloader takes care of its own data but I can’t find a way to auto load the queries. Many websites suggested scheduling the query on daily base but this seems a bit overkill when I only need to reload after a restart. (using SAS VA 7.2)   Is there a way to auto run queries after a startup? (Without scheduling it for a daily run) ... View more