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