Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

#OBIEE

Received Response
12
Views
6
Comments
User_15J6I
User_15J6I Rank 5 - Community Champion

Hi!

Somebody can help with this error?

Estado: HY000. Código: 59161. [nQSError: 59161] Los valores generados durante la ejecución de la función SumUInt32 han excedido el tamaño máximo permitido, cambie la función para asegurarse de que los valores son mayores que 4294967295 no se han generado. (HY000)

Thanks

ESM

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Check the data types you are using. Seems to be an issue with a 32bit integer going over its allowed limits.

  • Way too much context provided

    Click the button there on top and it's fixed ...

    More seriously:

    Context, version, environment etc.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Yes but a real geek has all his batsignals goin off over 4,294,967,295

  • Of course 2,147,483,647 and 4'294'967'295 are pretty famous numbers.

    But no thread is too simple or obvious to point out that a minimum of effort is required in asking a question, or why would somebody invest his time in providing an answer?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    look at the timestamp of my response and deduce my state of mnd ;-P

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    So is this question answered or are there still open issues?