Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

#OBIEE

Received Response
21
Views
6
Comments
User_15J6I
User_15J6I Rank 5 - Community Champion
edited Aug 13, 2024 5:27PM in Oracle Analytics Forum

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.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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?