This content has been marked as final. Show 13 replies
Did you try runing the mapping procedure in database ?
Sorry but i can't follow you, what do you mean by running the mapping procedure in database?
I tried to run the mapping from my Workspaceuser with the owbsys.wb_rt_script_util.run_task utility.
Do you get this when you run just your mapping or you get this when you run process flow?
Do you have any custom procedures in your process/mapping?
Its just a mapping not a process flow.
I don't have any custom procedures in the mapping, just one function that i call but i testet this one and that runs without problem.
I detected also that i have this problem on every mapping on this specific user schema but not on other user schemas.
This is known to happen on 11.2 due to a bug and it occurs when you copy/paste objects in OWB.
I didn't copy/paste objects in OWB, i just importet these packages after upgrading from 10g.
After that i was deploing them to the database and now i have the error.
If it is the bug then how can i solve this error?
You can analyze your deployed package and try to find referenced component that's missing. That should give you some starting point. Is your package valid in DB?
Yes my package is valid in the DB.
The error message says that the component that is missing is the package itself, it displays the name of the package.
Thats why i can't find the error.
I alredy checked if all tables and functions ar available and they are, so this can't be the error.
We have the same problem on OWB 18.104.22.168 and have solved renaming a schema name, because it was the same than another object on database. If this is your case, you can change the schema name on database and the location on OWB.
We hope this help you.
To view possible duplicate objects (schema-object):
WHERE OBJECT_NAME = '<SCHEMA_NAME>';
On this Oracle document is much better explained:
Oracle® Warehouse Builder Release Notes
*11g Release 2 (11.2) Part Number E24470-05*
7.14 Existence of an Object in the Schema With the Same Name as the Target Schema in the Database
12776878: If an object exists in the schema with the same name as the target schema in the database, then an error is displayed.
Schema named A has an object called Q. Schema named Q exists and has an object called Z.
When you call SchemaQ.ObjectZ from Schema A, it looks within Schema A for Q.Z. Z is not found and displays the following error:
ORA-06550: ..: PLS-00302: component 'XYZ' must be declared
Workaround: Rename one of the Q objects to R or some letter other than Q.
I have seen this article, the situation described in there does not exist on our system, but a similar:
We have Schema B and an table called B on this Schema, on Schema B i also have the mapping Z, that i try to call.
Im now calling SchemaB.ObjectZ from Schema A.
I will now try to rename Schema B an then run the mapping Z.
awesome! We were looking for this solution for a long time. We couldnt figure why it says it cant find the package.
We thought the locations were messed up, or the flow calls it in the wrong schema (started to track owf activities).
We had a SR open for over a month and the guys didnt even had the slightest clue what is happening :(
cheers! you made our day!
to check if you have this bug just use:
FROM dba_users y
FROM dba_objects a
Edited by: BRZ-DWH Steuer on Oct 5, 2012 1:14 AM
I now have found the error, when you create an object with the same name as the owner schema, then you can't execute any mapping on this schema.
I can also replicate dis error on other schemas.
Thanks for any help of you guys
We glad to help you about this issue. All are OWB sufferers... :)
We were several days to find the problem.