Loading

Unable to Connect live to Snowflake from Tableau Server

Дата публикации: Mar 21, 2025
Описание

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.
Решение
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.


 
Номер статьи базы знаний

001498048

 
Загрузка
Salesforce Help | Article