Versions Compared

Old Version 1

changes.mady.by.user user-1bc08

Saved on

compared with

New Version 2

changes.mady.by.user user-b885f

Saved on

Key

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

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 the user specified 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 yaml configuration file (.yml) matches the key from the sharing source.



Divbox


Expand
titleHow do I know what schema the meshlet created?

In the data folder where the meshlet is installed there is a schemaColumns.dat file that holds the schemas of the tables it has created.




Can't find what you're looking for?  

See the FAQ or browse the Perspectium Community Forum.