解决OMB：Trying to access invalid Object

本人遇到情况的解决方式：退出omb*plus再重新进去即可。

另一种会Trying to access invalid Object的情况是：ETL对象属性有误。

疑问：

1、

element

An object or process. For example, a dimension is an object, a mapping is a process, and both are elements.

entity

Entity is used in database modeling. In relational databases, it typically maps to a table.

参考：http://docs.oracle.com/cd/E11882_01/server.112/e25554/glossary.htm#DWHSG8843

2、如何通过 element id  查到element对象 ，命令是？

oracle官文里，关于Trying to access invalid Object问题的解决：

10.10 Repository Upgrades and Migrations from Oracle Warehouse Builder 11.1 or Earlier

9835013: ARRAYINDEXOUTOFBOUNDSEXCEPTION DURING MDL IMPORT

When importing MDL files, you may encounter the following errors:

• Trying to access invalid Object

• MDL1261: Error importing OWBAssoc_CopyOfMDW

Workaround（解决办法）: You can use the following workarounds:

• Increase the heap size when running the Repository Assistant

  On Windows, edit the OWB_HOME\owb\bin\win32\reposinst.bat file. On UNIX, edit OWB_HOME/owb/bin/unix/reposinst.sh. Increase the value set for the -Xmx flag.

• Increase the heap size when running the Design Center client

  Edit the OWB_HOME/bin/owb.conf file and increase the value set for the -Xmx flag in the AddVMOption.

Oracle Warehouse Builder 11.2 Repository Must Contain a Workspace Before Upgrade of Oracle Warehouse Builder 10.2 or 11.1 Repository MDL Export

If you are upgrading Oracle Warehouse Builder 10.2 or 11.1 repository to Oracle Warehouse Builder 11.2 by exporting the entire repository to MDL with the Repository Assistant, then importing it into Oracle Warehouse Builder 11.2, then your destination Oracle Warehouse Builder 11.2 repository must have at least one Oracle Warehouse Builder 11.2 workspace in it before you can import the MDL.

If your Oracle Warehouse Builder 11.2 repository does not contain a workspace before import, then you must create a dummy workspace, with a name that does not conflict with the names of any workspaces to be imported.

Follow the instructions in Oracle Warehouse Builder Installation and Administration Guide to create a workspace. At step 6 in the Repository Assistant, assign a workspace name and workspace owner that do not conflict with workspaces and workspace owners you actually plan to use. If importing an Oracle Warehouse Builder 10.2 repository, the workspace name should be the name of the source schema in which the repository was stored in Oracle Warehouse Builder 10.2.

You can then run Repository Assistant again to import your Oracle Warehouse Builder 10.2 or 11.1 repository export MDL file to your Oracle Warehouse Builder 11.2 repository.

Patch Addressing Multiple Repository Upgrade Issues

Before upgrading or migrating repository contents from a previous release, review Note 1074813.1 on My Oracle Support, and also the white paper "Master Note for Oracle Warehouse Builder Upgrade To 11.2" for details of migration options and processes, and known issues that may affect the migration process.

Customers using Oracle Warehouse Builder 11.2.0.1 should consider applying patch 9802120, which resolves all known upgrade and migration-related issues as of the date of its release. See My Oracle Support for more details.

https://support.oracle.com

参考：

http://docs.oracle.com/cd/E11882_01/relnotes.112/e24470/toc.htm#CIHEIDBA

Trying to access invalid Object  谷歌

本人遇到情况的解决方式：退出omb*plus再重新进去即可：

Sometimes it helps to rollback, leave owb, restart and the mapping is still there and accessable.

I have logged a bug on this issue (4015014). Another possibility is that your repository is corrupted - I might have to contact you for a copy of your mapping/repository.

参考：https://community.oracle.com/thread/276982?start=0&tstart=0

另一种会Trying to access invalid Object的情况是：ETL对象属性有误：

http://oracle-software.mscer.com/q_oracle-technologies_50840.html

https://community.oracle.com/thread/829843?start=0&tstart=0