topic how do i resolve visual data builder fatalconnectionfactoryexception in SAS Visual Analytics

how do i resolve visual data builder fatalconnectionfactoryexception

rieley — Wed, 16 Aug 2017 17:11:41 GMT

i am a user in a new - and new to me - SAS Visual Analytics

i want to use visual data builder to query a table

and make the results available to reporting in visual analytics

i had success once or twice, and i have failed many times

I include a microsoft word document with (a) window capture of my query builder showing table and selected column, and (b) fatalconnectionfactoryexception error.

thank you

the error message:

The request could not be completed successfully due to a server error. Please contact your system administrator.

Server error: com.sas.svcs.jobexecution.client.JobException: com.sas.svcs.jobexecution.client.TaskExecutionException: com.sas.services.connection.FatalConnectionFactoryException: The native implementation module for the security package could not be found in the path. cause: com.sas.services.connection.FatalConnectionFactoryException: The native implementation module for the security package could not be found in the path.

i use SAS Visual Data Builder version 7.4 build date Wednesday April 5, 2017 7pm

Re: how do i resolve visual data builder fatalconnectionfactoryexception

Madelyn_SAS — Thu, 24 Aug 2017 00:00:18 GMT

This error can occur intermittently when there is a problem with IWA authentication. If you have implemented IWA, you might want your admin to review the steps to make sure none were missed.

Re: how do i resolve visual data builder fatalconnectionfactoryexception

alexal — Thu, 24 Aug 2017 00:35:14 GMT

@rieley,

Make sure the web browser is passing delegated credentials to the SAS Web Server. You should see a message in the SAS Logon log like this:

... INFO com.sas.svcs.security.authentication.gss.GSSCredentialCachingFilter - Received credentials for <USER_NAME>

If not, check the web browser settings.

Re: how do i resolve visual data builder fatalconnectionfactoryexception

Rahul_SAS — Thu, 24 Aug 2017 05:20:09 GMT

what do you mean by IWA??

Re: how do i resolve visual data builder fatalconnectionfactoryexception

alexal — Thu, 24 Aug 2017 10:58:29 GMT

@Rahul_SAS,

Integrated Windows Authentication (IWA) is a Microsoft technology that is used in an environment where users have Windows domain accounts. With IWA, the credentials (user name and password) are hashed before being sent across the network. The client browser proves its knowledge of the password through a cryptographic exchange with the web application server.

http://support.sas.com/documentation/cdl/en/bimtag/69826/HTML/default/viewer.htm#p1871e69gmwdr0n1o182krslc10p.htm

Re: how do i resolve visual data builder fatalconnectionfactoryexception

rieley — Thu, 24 Aug 2017 17:30:59 GMT

thank you

i don't find "com.sas.svcs.security.authentication.gss" in the log files my guy has given me

i suppose i haven't told my guy explicitly which log file to share with me

is there a naming convention and i could tell my guy to look for a log file with that name?

thank you

i have seen

- a SASVisualAnalyticsTransport7.4 with entries from com.sas.bidata.error.DataErrorHandler

- a SASVisualAnalyticsTransport7.4 with entries from com.sas.onebi.transportservices.utils.DataUtils

- an object spawner thatstarts Host: 'FDC1S-SASAPPP4', OS: 'WIN', Release: '6.3', Command: '"E:\Program Files\SASHome\SASFoundation\9.4\objspawn" -name "SAS [SASConfig-Lev1] Object Spawner"'

- a SASVAPooledWorkspacerServer that starts with Host: 'FDC1S-SASAPPP4', OS: 'WIN', Release: '6.3', SAS Version: '9.04.01M4P11092016', Command: '"E:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -config "E:\SAS\SASConfig\Lev1\SASAppVA\PooledWorkspaceServer\sasv9.cfg" /nologo /noterminal /netencryptalgorithm AES /metaserver fdc1s-sasappp5.ferc.gov /metaport 8561 /metarepository Foundation /objectserver /objectserverparms "protocol=bridge spawned spp=53590 cid=203 dnsmatch=fdc1s-sasappp4.ferc.gov pb classfactory=620963ee-32bf-4128-bf5f-4b0df8ff90eb server=OMSOBJ:SERVERCOMPONENT/A5NTYCP4.AY000006 cel=everything lb sspool saslangrunas=client"'

Re: how do i resolve visual data builder fatalconnectionfactoryexception

rieley — Thu, 24 Aug 2017 17:39:05 GMT

other pieces of information that don't mean much to me but may mean something to the community

- my chrome browser does not recognize my SAS Visual Analytics server as a secure site and shows a line-through the https portion of the url and advises not secure with the red triangle icon to the left of the addreess entry

- i am using chrome Version 60.0.3112.78 (Official Build) (32-bit)

- the fatalconnectionfactoryexception is intermittent

Re: how do i resolve visual data builder fatalconnectionfactoryexception

SASKiwi — Thu, 24 Aug 2017 20:22:26 GMT

Have you tried another supported browser like Internet Explorer and do you get the same problems?

Re: how do i resolve visual data builder fatalconnectionfactoryexception

rieley — Thu, 24 Aug 2017 20:31:19 GMT

i do not get the error in microsoft internet explorer

the error is intermittent in chrome

here is additional logging from a server file (i don't know which)

NFO | jvm 1 | 2017/08/24 12:36:17 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
INFO | jvm 1 | 2017/08/24 12:36:17 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
INFO | jvm 1 | 2017/08/24 12:36:17 | at com.sun.proxy.$Proxy4211.preview(Unknown Source)
INFO | jvm 1 | 2017/08/24 12:36:17 | at sun.reflect.GeneratedMethodAccessor11797.invoke(Unknown Source)
INFO | jvm 1 | 2017/08/24 12:36:17 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO | jvm 1 | 2017/08/24 12:36:17 | at java.lang.reflect.Method.invoke(Method.java:606)
INFO | jvm 1 | 2017/08/24 12:36:17 | at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:418)
INFO | jvm 1 | 2017/08/24 12:36:17 | ... 128 more
INFO | jvm 1 | 2017/08/24 12:36:17 | Caused by: com.sas.svcs.jobexecution.client.JobException: com.sas.svcs.jobexecution.client.TaskExecutionException: com.sas.services.connection.FatalConnectionFactoryException: The native implementation module for the security package could not be found in the path. cause: com.sas.services.connection.FatalConnectionFactoryException: The native implementation module for the security package could not be found in the path.