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