Odbc driver returned an error [message #459499] |
Sun, 06 June 2010 05:20 |
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 |
|
Littlefoot
Messages: 21809 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
|
|
|