Bulk fetch failed in obiee 11g — Oracle Analytics

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

Bulk fetch failed in obiee 11g

Received Response
11
Views
2
Comments
3167974
3167974 Rank 4 - Community Specialist
edited Aug 13, 2024 6:09PM in Oracle Analytics Cloud and Server

hi,

i am getting following error in my obiee instance as :-

pastedImage_0.png

if i try to filter the data from prompt then the reports are working fine and if i try to take all values from single column of prompts its throughing me above error. please let me know about this issue.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    ORA-01722 is an Oracle error, not OBIEE, but your database.

    So without looking into details the message is about "invalid number" I would say you maybe have a mismatch between the Oracle database column type and the OBIEE definition in the RPD. A different type has been set by OBIEE or something around that.

    Take the physical SQL and check it by hand (you are supposed to get the same error). Can also be because of data quality problems.

    So first analyze what values are generating the error and then evaluate the possible solutions: fixing the source by changing the values in the db, changing the definition in OBIEE etc.

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Mostly it could be because of the presentation variable. For a number column in DB your report may be passing character values or comma seperated numbers.