Loading

Unable to Connect live to Snowflake from Tableau Server

Udgivelsesdato: Mar 21, 2025
Beskrivelse

There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs.
User-added image
Log snippet

2023-03-13 23:25:10.185 -0700 (Default,xyz@tableau.com,,ZBATQ9AKDIkYTgs6LXjiUQAAAIk) catalina-exec-1 : WARN com.tableausoftware.controller.dataserver.SessionController - Failure {"datasession":"-","datasource":"-","dserror":"-","dsexception":"class ConnectivityException","errorsrc":"DataSource","errorstatuscode":"14","failmsg":["An error occurred while communicating with the Snowflake data source 'federated.145dk3712quc0f1c2wzpt0nyxc3u' Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database. There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs. å�›æ½®æ™·æ…¬æ•«å­�ç•“ç�°ç‰¯åµ´â ã€µã€´â¤´ä¤ ç™®æ±¡æ‘©æŒ æ¹¯æ•®ç‘£æ½©â�®ç‘³æ¥²æ�®.á¿�è¶ ç¾¸ "],"failtype":"UnableToConnect","request":"ZBATQ9AKDIkYTgs6LXjiUQAAAIk","site":"Default","status":"400","taberrorcode":"0xFAB9A2C5","trace":[["com.tableausoftware.controller.dataserver.DataServerException.parseException(DataServerException.java:360)","com.tableausoftware.controller.dataserver.DataServerException.fromDOM(DataServerException.java:375)","com.tableausoftwarntroller.dataserve.coer.CreateResponseParser.parseResponse(CreateResponseParser.java:89)","com.tableausoftware.controller.dataserver.SessionCreator.lambda$createSession$0(SessionCreator.java:444)"]],"user":"xyz@tableau.com"}

Cause

Unicode Transformation Format (UTF) parameter is not specified for the DriverManagerEncoding.
Løsning
Check and edit the file simba.snowflake.ini under /opt/drivers/snowflake_odbc/lib/ directory on ALL the nodes (especially Node1) and make sure encoding is set to UTF-16 -- DriverManagerEncoding=UTF-16.
  
[Driver]
DriverManagerEncoding=UTF-16
DriverLocale=en-US
ErrorMessagesPath=/usr/lib64/snowflake/odbc/ErrorMessages
LogNamespace=
LogPath=/tmp
ODBCInstLib=/usr/lib64/libodbcinst.so
CURLVerboseMode=false
#LogLevel=6
CABundleFile=/usr/lib64/snowflake/odbc/lib/cacert.pem

Note:

As of version 2.22.5 of the ODBC Driver, you can also specify this parameter as a configuration parameter (for example, in the simba.snowflake.ini on macOS and Linux). If this is set as both a connection parameter and a configuration parameter, the connection parameter in the DSN (or connection string) takes precedence.


 
Vidensartikelnummer

001498048

 
Indlæser
Salesforce Help | Article