Database Software

Hi,

until yesterday I had a fully operational OWB environment but ...this morning I encountered a problem.

We have a schema a which has the source data, schema b which should contain the mappings and a schema c which should have the target tables.

All mapping worked fine until today. Today I was trying to deploy a modified mapping and I received the following error message

TEST
Create
Warning
ORA-06550: line 11, column 2:
PL/SQL: SQL Statement ignored
TEST
Create
Warning
ORA-06550: line 126, column 7:
PL/SQL: SQL Statement ignored
TEST
Create
Warning
ORA-06550: line 135, column 12:
PL/SQL: ORA-00942: table or view does not exist
TEST
Create
Warning
ORA-06550: line 15, column 12:
PL/SQL: ORA-00942: table or view does not exist
TEST
Create
Warning
ORA-06550: line 23, column 2:
PL/SQL: SQL Statement ignored
TEST
Create
Warning
ORA-06550: line 27, column 12:
PL/SQL: ORA-00942: table or view does not exist

I made several experiments with the mapping and I finally stripped it down to just two tables, one source table from schema a and one target table of schema c. I recognized that the problems appears due to the one table from the source schema a.
I assumed a permission problem and I so proceeded by generating the intermediated code, started my SQL developer and tried to execute the code with the same user account as OWB would do. The result the code worked fine. As a next step I asked the DBA whether he changed anything on the DB configuration which might cause this problem. He disagreed.

Now I am at the end of my ideas ...what can cause this problem or how can I track it?

Thanks.

Regards,
S202