Search

Analysis Services Tabular Model Errors on Largest and Smallest Big Int by Scott Cameron

Closed

1
0
Sign in
 to vote
Type: Bug
ID: 772289
Opened: 11/26/2012 4:16:29 PM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
If a data source column with data type big int contains -9,223,372,036,854,775,808 or 9,223,372,036,854,775,807 then Analysis Services will throw an error when processing a table in a tabular model. It will not fail over the data range of -9,223,372,036,854,775,807 to 9,223,372,036,854,775,806.
Details (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Edition

Category

Analysis Services

Operating System

Windows Server 2008 (all editions)

Operating System Language

US English

Steps to Reproduce

Process a SSAS tabular model table with a big int column containing -9,223,372,036,854,775,808 or 9,223,372,036,854,775,807

Actual Results

Fails with error

Expected Results

Should load value into table

Platform

X64

Virtualization

 
File Attachments
File Name Submitted By Submitted On File Size  
LetsGetSmall.png Scott Cameron 11/26/2012 83 KB
Sign in to post a comment.
Posted by Microsoft on 11/29/2012 at 3:11 PM
Thanks for reporting this. Our in-memory database engine reserves these two values for special use, so they are not available to be used as data values.

Thanks,
Analysis Services Product Team
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement