Hi all,
I have upgraded the OWB repos from 10.2.0.3 to 11.2. After that I deployed the mappings. Some of the mappings which is pointing to a remote database is missing there db links.
This is the warning:
MAP_FORETAG_TO_SRC
Create
Warning
ORA-06550: PACKAGE BODY, line 53, column 4:
PL/SQL: ORA-00942: table or view does not exist
This error is due to that the pl//sql script generated by the mapping dont include a dblink in the SELECT statement:
SELECT ...
"FORETAG"."VER_NR" "VER_NR"
FROM
"FORETAG" "FORETAG";
It should read:
SELECT ...
"FORETAG"."VER_NR" "VER_NR"
FROM
"BOOTS"."FORETAG"@"LOC_NGSRC_LOC_NGBOOT" "FORETAG";
It does not help to drop the mapping and redeploy it. It seems that in the mapping, the table have lost its reference to the repository object:OWB_OWNER/NGDALA/NGBOOT/FORETAG
One workaround is to manually use "syncronize" on every table, then genereate and deploy. But this will take for ever! Its many hundreds of mappings.
Any ideas?
Regards
H
] 
Blog
Search
Help
Members
Register
Login
Home
