My Oracle Support Banner

Error when using Timestamp in Snowflake Database (Doc ID 3014677.1)

Last updated on APRIL 11, 2024

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Goal

When running a report with a Snowflake the data source - the underlying column is defined as a timestamp you may get an error similar to: 

Error: [nQSError: 77031] Error occurs while calling remote service DatasourceService. Details: [JDSError : 77] 1,813 : SQL compilation error: error line 1 at position 6,476 Invalid timestamp scale: 35. Must be between 0 and 9. - Cause: SQLException is thrown from the datasource


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.