This content has been marked as final. Show 5 replies
sliderrules wrote:Table or view does not exist. Check whether the columns are exists or not.
ORA-00942: table or view does not exist at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
SQL Issued: SELECT Time."Month Name" saw_0, "Workflow Fact"."Total Case Handlers" saw_1 FROM "HCBF Applications" ORDER BY saw_0
Edited by: kart on Aug 4, 2010 3:44 PM
The table and column does exist in the database and the physical layer. The columns have been renamed in the BMM but that should not affect the physical name. The time dimension appears to be the problem, the remaining dimensions seem to display in answers.
in your physical layer check whether you are able to view the data in time dim. and in bmm layer check whether the sources are mapped correctly or not. Check logical column to physical column mapping.
I am unable to view the data in time_dim in the physical layer. I get the same error message 'table or view does not exist'. I have checked the database and the table does exist containing data. The only change I made was renamed the table and the foreign keys from dimension -> fact sill exist in the physical diagram.
Some dimension are ok and I can view the data, how can this message be overcome?
Re import the physical table again.