Hi Guys,
I am working with my framework manager package. I am just having a problem while setting the relationships.Ã, It give me the following error. Any kind of help will be highly appreciated. Thanks in advance.
QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0446 Oracle returned an error message.
ORA-00942: table or view does not exist
UDA-SQL-0450 An unexpected error encountered during the "prepare" operation.
Regards,
Geinel
Miles To Walk Before I Sleep.
Well.. the error sys a table or view does not exists. So, at one point you imported a table and have it included in a relationship some where. Now, the table does not exist..
I have received this error often and it was one of three things (all in Oracle):
1. They changed the password on the user account that accesses data for CRN.
2. The DBAs changed the access persmission to the view where the data is that is used by CRN.
3. The view has been renamed.
Some of this can be resolved by working with the connection in CRN (esp. #1) but I always worked with the DBAs and had them solve the problem. This solved the problem and made them more aware of what CRN needed from Oracle.
Best of Luck,
Don
Hey Guys,
Thanks Alot for ur help. I just wanna say that this place is amazing, and I love to be here. It is a great learning plat form.
Thank you Guys Again.
Miles To walk B4 i Sleep.
Regards,
Gienel
What's the solution?
Hey,
Actually the DBA had changed the location of the data without letting me know thats weired I know. So the Datasource I was using was not the right one. As I didnt closed the Framework manager since one day and I guess he did that somewhere in the middle of that one day. Thats why framework manager DB VIEW and Business View still have those tables, at the time when I was defining the relationships it was not letting me do that as datasource did not have the same tables.
Thanking You
Regards,
Geinel
Miles To Walk B4 I Sleep.