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 laterInformation 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 |