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

After 12c migration problem

Received Response
12
Views
6
Comments
TANI_TOL
TANI_TOL Rank 2 - Community Beginner
edited Aug 13, 2024 5:30PM in Oracle Analytics Cloud and Server

Hi  everyone ,

I have a problem . I used data model in 11g but I don't use this model after migration OBIEE 12c.

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

State: HY000. Code: 14077. [nQSError: 14077] None of the dimension tables are compatible with the query request Dim_TaniAlisverisIsyeri.Isyeri Adi. (HY000)

how can I fix it ?
Thanks ;

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    You marked the thread as "assumed answered" but you didn't post the answer.

    The idea of a community forum is that you take and you give, so when you find your own solution you still post it back in the thread as it will maybe help other users with the same kind of question.

  • TANI_TOL
    TANI_TOL Rank 2 - Community Beginner

    Hi ,

    I'm sorry . I accidentally marked it.

    Thank you so much .

  • Gianni Ceresa
    Gianni Ceresa Mod

    You did an upgrade and things change between 11g and 12c. There are chances your RPD had something which worked in 11g but already wasn't 100% clean, so now 12c is a bit more strict on things and tell you that there is an issue. Open your model, look inside, run a consistency check, fix all the errors or warnings and than start debugging if the error is still there.

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

    +1 to Gianni. This is always because of improper / dirty models in the old version. These things should never have existed in the first place as the configuration was as wrong then as it is now. The Admin Tool didn't fully enforce those rules because the BI Server was "kind of ok" and let it through. But again the config wasn't clean to begin with.

  • TANI_TOL
    TANI_TOL Rank 2 - Community Beginner

    Hi Gianni and Christian ,

    I fixed it . Thank you so much for your help .

  • Gianni Ceresa
    Gianni Ceresa Mod

    So going back to what I first posted on this being a community forum: post some hints of what you did and how you fixed it (you can use generic names if you have a privacy concern). Because it isn't the first time this question is asked and will not be the last one, so will be helpful for others to have your first-hand experience.