EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

The number -2147483648 appears in a WHERE clause in reports run on MicroStrategy Web 2021


Leopoldo Bebchuk

Associate Product Manager • MicroStrategy


This Knowledge Base article describes a behavior observed in JSP Web when running a filtered report. A WHERE clause that should contain a numeric attribute’s value, contains the number -2147483648 instead.

Symptom 

A filtered report works fine when executed in Developer but fails in Web. In the SQL View, a WHERE clause containing the number -2147483648 instead of the expected value is found. 
 

Cause 

The number -2147483648 is the lowest possible value for 32-bit signed integer. The values used by the attribute may be incompatible with the data type. 
 

Action 

Review the column aliases used by the attribute. If something as INT(4) is used, change it to BIGINT instead. 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 29, 2023

Last Updated:

June 29, 2023