odi-10182: Uncategorized exception during repository access
ora-00001: unique constraint ( pk_pop ) violated
There is another interface with the same name on the repository. Interface names are unique and independent of their folder location. In my case I had an interface with the same on a different folder.
Rename or delete your duplicate interface.
SYMPTOM:
odi-10182: Uncategorized exception during repository access
ora-00001: unique constraint ( pk_txt_header) violated
CAUSE:
The table definition was created by duplicating metadata for another table. Indexes are defined as constraints in ODI, when duplicating the original table object the index definitions are duplicated with the original names, for some reason this does not trigger an error at the time of duplicating the tables, the primary key validation for the index name is triggered –in my case- at the time of saving a mapping where the table duplicate is a target.
SOLUTION:
On Design > Models look up the duplicate table. Once located review and update the names of each of the constraints / indexes defined on metadata and save them. Once you have completed the review you should be able to save the mapping throwing the original issue message.
Plugins are small applications that enhance a specific set of functionality on the WordPress blog publishing platform. Today I will be presenting you with the top applications to help you improve the appearance of your blog:
You can search fo additional plugins online at: https://wordpress.org/plugins/browse/popular/
Plugins are small applications that enhance a specific set of functionality on the WordPress blog publishing platform. Today I will be presenting you with the top applications to help you improve the performance and security of your blog:
You can search for additional plugins online at: https://wordpress.org/plugins/browse/popular/
Oracle Corporation’ (ORCL) acquisition of Golden Gate Software on July of 2009 was a big step for Oracle in its quest to build a open and heterogeneous product line that will be more appealing to enterprise customers with complex OLTP and data warehouse environments. You can find a detailed presentation of the considerations that were taken into consideration regarding this acquisition here. In the data warehousing space this is a welcome addition to the earlier acquisition of Sunopsis (now Oracle Data Integrator) a Extract-Load-Transform alternative to traditional ETL tools such as Informatica and IBM Information Server (DataStage) that plays nice in heterogeneous database environments and is significantly easier to use, and more stable than the displaced Oracle Warehouse Builder (OWB). Key areas where Golden Gate can be of use in a heterogeneous database environment:
Under the last scenario events can be fed into real time alerts or dashboard Key Performance Indicator’s in real time in addition to triggering additional events when the event is orchestrated via an enterprise bus. Here’s a link to a step by step installation and configuration demo at Oracle Technology Network (OTN). Stay tunned for additional product reviews and OBIEE tips and tricks that are coming soon and check my review of Oracle Data Integrator here..
In a long anticipated move among both Fusion Intelligence and Oracle BI Apps customers, Oracle has released the first versions of its packaged business intelligence solution that replaces the third party tools of previous versions (IBM DataStage or Informatica Power Center) with Oracle Data Integrator as the back end ETL tool. You can find detailed install and configuration instructions in the Oracle Business Intelligence Applications 7.9.5.2 Documentation Library.
It is important to note that this is a controlled availability release that mainly means the only data source supported is Oracle E-Business Suite 11.5.10, marts available in this release are:
Limitations notwithstanding, this is a key move that signals a long term strategy for BI Apps that will require customers and partners to develop additional skills and an important upgrade consideration for EBS customers. I personally hope that we will see Oracle implement Golden Gate at some point down the road in order to provide real time operational intelligence for a limited set of KPIs that lend themselves to be used in BAM applications.
Plugins are small applications that enhance a specific set of functionality on the WordPress blog publishing platform. Today I will be presenting you with the top applications to help you improve the social media and search optimization features of your blog:
You can search fo additional plugins online at: https://wordpress.org/plugins/browse/popular/
 |
I am a technophile based in San Francisco, in my current endeavors take me into the realms of big data, data science and information discovery. I am documenting my findings and experiences on this wild new frontier in the history of computing in this blog and always looking for a conversation with those in the trenches that live and breathe the use case, send me an email to [email protected] and follow me on twitter at @binsights or LinkedIn at http://linkedin.com/in/idelatorre |
Plugins are small applications that enhance a specific set of functionality on the WordPress blog publishing platform. Today I will be presenting you with a few additional plug ins that I found interesting and that create provide very specfic functionality to your blog:
You can search fo additional plugins online at: https://wordpress.org/plugins/browse/popular/
On October of 2006 Oracle acquired Sunopsis a sofware company whose flagship product was one of the up-and-coming players in the datata warehousing arena. Sunopsis for easy integration in environments with multiple database systems and differentiated itself by adopting an Extract-Load-Transform architecture that decreased the learning curve for database developers that were immediately able to create transformation using familiar SQL syntax. By utilizing the computing power in the target database Sunopsis’ ELT architecture potentially decreased the need for additional computing power in a dedicated ETL server. Fast forward five years and Sunopsis is now Oracle Data Integrator, it is a key component of the Fusion Middleware Data Integration product line and it’s looking good, a few features that large enterprise customers will find interesting are:
It seems as if the merging of Oracle Warehouse Builder and Sunopsis’ functionalities has been beneficial to the end product and, in general, to the enterprise customer. Now it remains to be seen how aggressively Oracle”s sales force can take market share from ODI’s top competitors IBM Information Server and Informatica PowerCenter. Stay tunned for additional product reviews and, of course, OBIEE and Business Intelligence updates…
