Home » Fusion Middleware & Colab Suite » Business Intelligence » Odbc driver returned an error
Odbc driver returned an error [message #459499] Sun, 06 June 2010 05:20 Go to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Dear all,
When I use SH schema as given Oracle Tutorial..i didn't get any problem.

in real work when i try to show data individually(fact/dimension ) table in Oracle answer , the data showing without error.


But when i try to display data with the combination of fact and dimension table then it show an error.



Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 15018] Incorrectly defined logical table source (for fact table P05 Waived Loan Interest) does not contain mapping for [D02 FI Hierarchy.FI Name]. (HY000)

SQL Issued: SELECT "D02 FI Hierarchy"."FI Name" saw_0, "P05 Waived Loan Interest"."Charged via Income/Provision" saw_1 FROM "BEDW" ORDER BY saw_0, saw_1



My database version Oracle 10.2.
Oracle BI Version 10.1.3.2

[Updated on: Sun, 06 June 2010 05:31]

Report message to a moderator

Re: Odbc driver returned an error [message #459518 is a reply to message #459499] Sun, 06 June 2010 09:34 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I admit, I know nothing about what you do.

However: query that "works" looks like this:
select table1.column_that_belongs_to_table1,
       table2.column_that_belongs_to_table2
from table1,
     table2
where table1.some_column = table2.some_column
order by table1.column_that_belongs_to_table1,
         table2.column_that_belongs_to_table2

What you did is this:
select table1.column_that_i_hope_belongs_to_table1,
       table2.column_that_i_hope_belongs_to_table2
from table3
order by table1.column_that_i_hope_belongs_to_table1,
         table2.column_that_i_hope_belongs_to_table2



See the difference?

I guess that you should check tables and their columns and write a select statement that is valid.

[Updated on: Sun, 06 June 2010 09:35]

Report message to a moderator

Previous Topic: How to enable horizontal SCROLLBAR in JPC simplegraph bean
Next Topic: report to excel ,problem number
Goto Forum:
  


Current Time: Thu Mar 28 13:10:37 CDT 2024