After 12c migration problem

Question

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 ;

Gianni Ceresa · Answer

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.

TANI_TOL · Answer

Hi Gianni and Christian ,

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

[Deleted User] · Answer

+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.