Forum Stats

  • 3,782,324 Users
  • 2,254,637 Discussions
  • 7,880,045 Comments

Discussions

ODI 10g to 12c Migration Issue

sinan_gg
sinan_gg Member Posts: 78
edited Jul 7, 2014 6:51AM in Data Integrator

Hi All,

We have just migrated ODI version from 10g to 12c. I imported some of the project folder to ODI 12c. But at this point i have an important issue about this subject.

In 10g, i can use variables like this format "#variable_1", but in 12c i cannot use this format, variables must have project_code as a prefix, like this "#project_code.variable_1". In this case could you please tell me how to have fixed this issue.

Please let me know anybody can help on this,

Sinan,

Tagged:
2715153

Answers

  • phanikanth
    phanikanth Member Posts: 991

    Hi Sinan,

    Oracle support team suggested below process to migrate code from ODI 10g to ODI 12c .

    ODI 10g to ODI 11g (any version of 11.1.1.6.0 (or) 11.1.1.7.0) and from ODI 11g to ODI 12c they release 3 patches an we have to apply complete patch and migrate our code from ODI 11g to ODI 12c.

    How did you migrate your ODI 10g to ODI 12c ?

    ifyou successfully migrated then when you did a sanity test what is the error or issue faced.

    can you please provide complete error message ifyou ran any mapping from ODI 12c ?

    Regards,

    Phanikanth

  • sinan_gg
    sinan_gg Member Posts: 78

    Hi Phanikanth,

    In 10g, variables was used like this format "#variable_1". But using variable method is a bit different from this in 12c.  Variables must have project_code as a prefix, like this "#project_code.variable_1" in 12c.


    E.g :  A variable, called "status_code", was used in one of my interfaces in ODI10g as a filter expression. After migration, i moved this interface from 10g to 12c by using export/import method. But, this variable did not get a value in 12c. After changed variable name like this "#project_code.status_code" in mapping/filer condition tab, it was be ok.


    So, i have lots of interface and packages, that is using most of variables. How can i fixed this issue ? manually, i can change every interface what have variables in it, like above. But this is very difficult solution for me.


    Hope i could tell about issue.


    Thanks,

    Sinan,




  • phanikanth
    phanikanth Member Posts: 991

    Hi Sinan,

    I tried below select query in ODI 11g but not in ODI 12c.

    can you check below select query to check number of joins and filter condition used in project folder

    SELECT

    F.FOLDER_NAME,

    P.POP_NAME INTERFACE_NAME,

    P.TABLE_NAME,

    T.FULL_TEXT JOIN_OR_FILTER_TEXT,

    DECODE (PC.JOIN_TYPE ,'J', 'JOIN','FILTER') EXPRESSION_TYPE

    FROM SNP_FOLDER F

    INNER JOIN SNP_POP P

    ON F.I_FOLDER = P.I_FOLDER

    INNER JOIN SNP_DATA_SET DS

    ON DS.I_POP = P.I_POP

    INNER JOIN SNP_POP_CLAUSE PC

    ON PC.I_DATA_SET = DS.I_DATA_SET

    INNER JOIN SNP_TXT_HEADER T

    ON PC.I_TXT_SQL = T.I_TXT

    where F.folder_name='Load_data_circuit_Inventory_system';

    hope this may work.

    Regards,

    Phanikanth

This discussion has been closed.