Versions Compared

Old Version 13

changes.mady.by.user user-3dc70

Saved on

compared with

New Version 14

changes.mady.by.user user-3dc70

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


HTML
<style>
.release-box {
	height: 30px; 
	width: 100px; 
	padding-top: 8px;
	text-align: center; 
	border-radius: 5px; 
	font-weight: bold; 
	background-color: #d4af37;  
	border-color: #FCE28A;
}

.release-box:hover {
  	cursor: hand;
    cursor: pointer;
    opacity: .9; 
}
</style>
<meta name="robots" content="noindex">

<div class="release-box">
<a href="https://docs.perspectium.com/display/gold" style="text-decoration: none; color: #FFFFFF; display: block;">
Gold
</a>
</div>



Below are some common issues you may come across while using DataSync for Snowflake.  Contact support@perspectium.com if your issue is not listed below or you have any other questions.


Connection Issues

When starting the meshlet, you may encounter connection issues showing the following error messages. See below for some areas to check to troubleshoot these issues.

Divbox


Expand
titleIncorrect username or password was specified

Verify if the ACCOUNT connection parameter was specified. Depending on your version of Snowflake, this parameter can be either ACCOUNT or ACCOUNT_NAME and should be specified in the connectionUrl configuration.

Code Block
languageyml
connectionUrl: jdbc:snowflake://<account>.<region>.snowflakecomputing.com/?ACCOUNT=<account>


Code Block
languageyml
connectionUrl: jdbc:snowflake://<account>.<region>.snowflakecomputing.com/?ACCOUNT_NAME=<account>




Divbox


Expand
titleJavaScript execution error: Uncaught Execution of multiple statements failed on statement "USE DATABASE <database"

Verify the database is valid and one the user has access to.



Divbox


Expand
titleNo active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.

Verify the warehouse is valid and one the user has access to.



Divbox


Expand
titleUncaught Execution of multiple statements failed on statement "USE SCHEMA <schema>"

Verify the schema is valid and one the user has access to.



Divbox


Expand
titleRole '<role>' specified in the connect string does not exist or not authorized. Contact your local system administrator, or attempt to login with another role, e.g. PUBLIC

Verify the role is valid and one that has access to the database, warehouse and schema specified.




General Issues

When the meshlet is running, you may encounter issues showing the following error messages. See below for some areas to check to troubleshoot these issues.

Divbox


Expand
titleJavaScript execution error: Error loading database config file, Error: No content to map due to end-of-input.

Verify databaseConfig.json file exist in ./static/config/databaseConfig.json and has required fields.



Divbox


Expand
titleJavaScript execution error: HTTP Response Send Status: 401... Bad response when retrieving ServiceNow Schema

Verify the ServiceNow credentials are correct and user has the proper role.



Divbox


Expand
titleJavaScript execution error: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.

Verify the encryption key in the YML configurations matches the key from the sharing source.




Can't find what you're looking for?  

See the FAQ or browse the Perspectium Community Forum.



Similar topics

Content by Label
showLabelsfalse
max5
showSpacefalse
sortmodified
cqllabel = "datasync-for-snowflake" and space = currentSpace()

Contact Perspectium Support

US: 1 888 620 8880

UK: 44 208 068 5953

support@perspectium.com