OBIEE LOG

User_15J6I

Hello, can someone guide me in reading the obiee log? I have the following error [nQSError: 59001] Join operation is not permitted on <<390283944>> Binary Join operand (s). When looking for more detail I find this line  InnerJoin <<390283944>> On D901.c2 = D917.c74 and D901.c3 = D917.c75; current join vectors: [0 1 2] = [71 71 72] however, I cannot locate the fields On D901.c2 = D917.c74 and D901.c3 = D917.c75; I don't know what table and fields is referred, if i search d901.c2 I only get this " D901.c2 as c2 [for database 3023:3510985:CONSULTORES BD_DWH,57]", so that doesn´t give me information about the field and table name, can you give me some clue how could I locate them please? Thank you

Joel

You'll need to paste the entire SQL statement which you can get from the obis1-query.log file. As the excerpt you provided doesn't contain all information needed to work out  what the D901 or c2 aliases are.

Also look at this and see if this is of any help - https://support.oracle.com/knowledge/Oracle%20Cloud/2324936_1.html