This discussion is archived
5 Replies Latest reply: Nov 29, 2013 1:45 AM by BMK RSS

ODI Workrep import is going to hung state

BMK Newbie
Currently Being Moderated

Hi Experts,


We are importing Work repository (provided by oracle) to our new environment. This process is getting hung immediately.

When we start import below sessions are getting created but going into inactive mode. ( we r using ODI, app is FTI).


FTIWORK         None       761,9461      FTIWORK.SNP_COL                     Row Exclusive
                                        FTIWORK.SNP_SUB_MODEL               Row Exclusive
                                        FTIWORK.SNP_KEY_COL                 Row Exclusive
                                        FTIWORK.SNP_KEY                     Row Exclusive
                                        FTIWORK.SNP_SOURCE_TAB              Row Exclusive
                                        FTIWORK.SNP_TXT_CROSSR              Row Exclusive
                                        FTIWORK.SNP_POP                     Row Exclusive
                                        FTIWORK.SNP_STEP                    Row Exclusive
                                        FTIWORK.SNP_JOIN                    Row Exclusive
                                        FTIWORK.SNP_COND                    Row Exclusive
                                        FTIWORK.SNP_JOIN_COL                Row Exclusive
                                        FTIWORK.SNP_TABLE                   Row Exclusive

Please help on how to resolve this asap

Thanks & Regards



  • Correct Answers - 10 points
  • Helpful Answers - 5 points