Bad value for type int : 2149310316

[aorashi]

Is this a bug report?

yes

Environment

java -version openjdk version "1.8.0_222" OpenJDK Runtime Environment (build 1.8.0_222-8u222-b10-1ubuntu1~16.04.1-b10) OpenJDK 64-Bit Server VM (build 25.222-b10, mixed mode)

Then, specify:

1. Operating system: Ubuntu 16/18
2. Browser and version (if relevant): not relevant
3. Saiku plugin to Pentaho or Saiku Standalone: Saiku Standalone
4. Saiku CE or Saiku EE: Saiku CE
5. Saiku version: 3.15 same on saiku-latest

Steps to Reproduce

generate over 2 149 310 316 row counts in facts table

Expected Behavior

initial select count(*) from a fact table return the result for cardinality

Actual Behavior

cubes are not initialized

and in logs 2019-10-21 04:30:20,914 ERROR [org.saiku.web.core.SecurityAwareConnectionManager] Error connecting: prod mondrian.olap.MondrianException: Mondrian Error:Internal error: Reading row count from table [null, olap, facts]; sql=[select count(*) from "olap"."facts"] .... Caused by: org.postgresql.util.PSQLException: Bad value for type int : 2149310316

fact tables are partition by int field if it's mater

[aorashi]

hi is there any updates?

for now, as i understand it's a limitation of Mondrian engine and it also presents in EE edition upgrade to EE will not resolve my issue the only way to fix is cut my data as I did it earlier