ODI Error - ORA-01017: invalid username/password; logon denied

ORA-01017: invalid username/password; logon denied

While Connecting Physical Data Server we will get this error due to invalid user name and password.

Goto=>Topology=>Physical Architecture=>Physical Technologies=>Dataservers=>  Test your Data Server 

Credentials.

ODI Error - ORA-01790 expression must have same datatype as corresponding expression

ORA-01790 expression must have same datatype as corresponding expression

If you are trying to connect two different values that can not be implicitly converted (in a mapping, a join...). Use the explicit conversion functions on these values.

ODI Errors - ORA-00972 Identifier is too Long

ORA-00972 Identifier is too Long

Oracle Database Object Names Max it will accept 30 Characters Only.  So We need consider this while

Creating  $ temporary tables at staging level.   If you are hard-coding any value at Physical Schema level

like  I$_STG or  I$_SESSION_NO it should not exceed more than 30 characters.

ODI Errors - ORA-00903 invalid table name

ORA-00903 invalid table name

The table used (source or target) does not exist in the Oracle schema. Check the mapping logical/physical schema for the context, and check that the table physically exists on the schema accessed for this context.

ODI errors ORA-00904 invalid column name

ORA-00904 invalid column name

1) Keying error in a mapping/join/filter. A string which is not a column name is interpreted as a column name, or a column name is misspelled.

 2) This error may also appear when accessing an error table associated to a datastore with a recently modified structure. It is necessary to impact in the error table the modification, or drop the error tables and let Oracle Data Integrator recreate it in the next execution.

Solution:

1) Check the Column names in Filter or Join Condition Editor, It should not contain column name with "".

2) Update E$table using CKM Options like Drop temporary table is True or Update Error Table is True.

ODI 12.1.3 New For Creating Directly Combined Model and Topology Objects in Wizard option

ODI 12.1.3 New For Creating Directly Combined  Model and Topology Objects in Wizard option.

ORA-00001: UNIQUE-key violation (ODI_ODI_REPO.PK_SNP_MISSING_REF)

While Importing objects from One Work Repository to Another Work Repository in ODI 12c 12.1.2
Version  We can get these below common error.

ORA-00001: UNIQUE-key violation (ODI_ODI_REPO.PK_SNP_MISSING_REF).

or 

com.sunopsis.core.SnpsDuplicateAKException: ODI-10035: SNP_SCEN : 'IMPORT_TEST Version 001'


Solution:

  Apply patch 17836908   for resolving above issues OR

12.1.3 version this issue fixed.

Note:  While exporting select with it child components and While importing
select INSERT_UPDATE mode for if objects are already exist it will update and if does not exists it will insert.

Missing References Error  while import Work Repository Objects or Default its creating Yellow interfaces due to not able to map target tables.

In order to avoid missing references, use either the Smart Export and Import feature or solutions to manage dependencies.