ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Regenerate ODI Objects using OdiGenerateAllScen

Hi,

One more little trick!

ODI objects such as Packages, Interface, Variable and Procedure scenarios can be regenerated without manually regenerating individual scenarios using OdiGenerateAllScen.

Drag in the OdiGenerateAllScen and select the Project and select Yes to Generate Package Scenarios and name it as Regenerate Package, similarly do so for other Object types and join them as shown below. The only advantage if you wish to regenerate just one object type you execute that particular step.

Else call it Regenerate and select yes to all the option so that regeneration of all the objects can be done at once.

Fast and simple!

8 Comments

  1. OdiGenerateAllScen is not the same as “regenerate”. When I generate a scenario manually and choose particular variables to be a Startup Parameter and after that apply OdiGenerateAllScen, then information on Startup Parameters and their order becomes lost. After OdiGenerateAllScen all the variables become Startup Parameters.
    This does not happen when I choose “Regenerate” from menu.
    Is it possible using OdiTols or Groovy regenerate a scenario and keep Startup Parameters configuration unchanged?

    Thianks,
    Naeel

  2. Hi ODI generate the following code:
    OdiGenerateAllScen “-PROJECT=PROJECT1” “-FOLDER=45110” “-MODE=REPLACE” “-GENERATE_PACK=YES” “-GENERATE_POP=NO” “-GENERATE_TRT=NO” “-GENERATE_VAR=NO”

  3. Hi,
    Do you know something about problems when using OdiGenerateAllScen.
    I have one global package which calls another package scenarios. Some scenarios in my package regenerate with errors but I can see this only when I execute my package. When I execute global package I receive error for example:
    “Exception getColList(“”, “[COL_NAME]”, “,nt”, “”, “((INS AND (NOT TRG)) AND REW)”) : BeanShell script error: Sourced file: inline evaluation of: “out.print(((true && (! true)) && true)) ; ;” : Attempt to resolve method: print() on undefined variable or class name: out : at Line: 1 : in file: inline evaluation of: “out.print(((true && (! true)) && true)) ; ;” : out .print ( ( ( true && ( ! true ) ) && true ) )
    BSF info: boolean evaluation at line: 0 column: columnNo
    Exception getColList(“,”, “[COL_NAME]”, “,nt”, “”, “((INS AND TRG) AND REW)”) : BeanShell script error: Sourced file: inline evaluation of: “out.print(((true && true) && true)) ; ;” : Attempt to resolve method: print() on undefined variable or class name: out : at Line: 1 : in file: inline evaluation of: “out.print(((true && true) && true)) ; ;” : out .print ( ( ( true && true ) && true ) )
    BSF info: boolean evaluation at line: 0 column: columnNo”

  4. Hello,
    Im also using the ODI tool – OdiGenerateAllScen.
    I want to regenerate the scenarios in a particular folder.
    However, in the tool OdiGenerateAllScen, the Folder parameter requires folder id.

    Is it possible to retrieve the internal id of the folder and store this in a (refreshing) variable.
    Thanks in advance.

    Regards,
    Nishna

    • Thanks for visiting us. Please use this query in refreshing tab of the variable and provide the project_name and folder name. since there can similar folder name for two different projects , so i have included project_name

      SELECT I_FOLDER
      FROM
      SF,
      SP
      WHERE
      SF.I_PROJECT=SP.I_PROJECT
      AND SP.PROJECT_NAME=’PROJECT_NAME’
      AND SF.FOLDER_NAME=’FOLDER_NAME’

      also you can know the internal id of the folder , right click Folder – > View – > Version Tab . Please let me know if you need any more help on this.

      Thanks
      Dev

  5. Hi,
    Here in 11g the Supervisor password is allowed to be chosen as something else. So the super visor password is not still SUNOPSIS but it is what you set and confirmed on Supervisor Password selection step. and There is a new utility ‘RCU’ for Repository creation but right now it creates the Master and Work schema on the same DB schema, which is not actually suggested by ODI architects (and me as well 🙂 )

Leave a Reply

Required fields are marked *.