My Oracle Support Banner

NSAW - SQL Server DB Column Named "Transaction" Couldn't Be Added To Dataset (Doc ID 3023297.1)

Last updated on MAY 23, 2024

Applies to:

Netsuite Analytics Warehouse - Version 24.R2.x and later
Information in this document applies to any platform.

Symptoms

SQL Server DB connection created successfully inside of OAC, But when try to create a dataset using one table dbo.balances, it's failed with following error message:

If Transaction column is removed from dataset query, and then the query runs fine. Transaction Column is defined as datatype Money, Value is normal decimal value. There is another similar column with similar datatype and value in this table works fine. Issue only happen to specific Transaction  name Column

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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