Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Erro na Consulta na visualização

Received Response
21
Views
1
Comments
Raphael Gonçalves Silva
Raphael Gonçalves Silva Rank 3 - Community Apprentice
edited Jan 31, 2025 6:50PM in Oracle Analytics Cloud and Server

Boa tarde! Criei uma regra (coluna de fórmula case) em função de um tempo "char" no dataset para utilizá-lo conforme print:

image.png

dataset aparece normalmente.

image.png

Mas na visualização o campo "Tempo Médio Espera Consulta" dá o seguinte erro e o dado não é apresentado:

image.png

Alguém possui uma solução para que o dado seja apresentado na visualização?

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    The error you get comes from your database and does tell you that something you expect to be a number isn't one ( https://docs.oracle.com/en/error-help/db/ora-01722/?r=23ai ). If you look in your logs you find the physical SQL that has been sent to your database and will easily be able to fix it.

    It generally comes from poor data quality, with "unexpected" values (or missing values) and no handling of those cases in the query.

    PS: the common language in the forum is English, nobody will look at grammar or syntax, you will have more answers if you post in English (because nobody will take the time to translate your post to then give you an answer).