Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Duplicate definition error in importing mete-data objects in Oracle BI administrator tools

Received Response
2
Views
4
Comments
Soheil Star
Soheil Star Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

Hi Guys

In importing metadata object phase in create new repository task, I have faced error "duplicate definition".

I wanna simply import "Country" Table from SH (Oracle sample) database

1.jpg

I created new Data source with "DataDirect 7.1.4 Oracle Wire Protocol" driver in odbc application to use it in "Select DataSource" phase.

2.png

When I brows that table in "Oracle Sql Developer" all thing are fine and there is no duplicate columns, but when I brows it in Oracle administrator tools, I could see duplicate columns for each one !
And so I can't import that table into my repository.

3.bmp


I use Oracle administrator tools 12.2.1.0.0

Thanks in Advance

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Soheil Star wrote:I wanna simply import "Country" Table from SH (Oracle sample) databasI created new Data source with "DataDirect 7.1.4 Oracle Wire Protocol" driver in odbc application to use it in "Select DataSource" phase.

    Why? Why ODBC?

    There isn't anything worse than a ODBC connection for an Oracle database, and it's actually useless.

    Connect by OCI, 3 clicks and done !

  • Soheil Star
    Soheil Star Rank 3 - Community Apprentice

    Thanks Gianni, that tip was helpful and I solved my problem

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    If this solved your issue can you please close the thread by marking the appropriate answer as "Correct"? Other users can benefit a lot more this way.

  • Soheil Star
    Soheil Star Rank 3 - Community Apprentice

    I solved the problem, hope this post help every body else face this issue.

    Duplicate definition error in importing mete-data objects in Oracle BI administrator tools

    The problem was Data Source connection type. I changed connection type from ODBC 3.5 to OCI 10g/11g .

    But may you want to know how to fill "Data Source Name", and mostly our Oracle DB is in remote machine from where you installed Oracle administrator tools.

    1- You should find "tnsname.ora" file in your Oracle DB installed location (It's located in $ORACLE_HOME/network/admin directory)
    2- Open it and find your oracle instance - for my issue it was ORCL

    3-  copy all text after = sign and reformat them in one line like this
      (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.102)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )
    4- Fill this line on "Data Source Name" filed

    5- Use proper username and password of that database

    2017-06-12_15-15-08.jpg

    6- Click on Next and all is set

    When you reach on "Select MetaData Object" there is not duplicate columns .

    That's it