ODI -12c
Version - 12.2.1.4
Issue - We do not want to regenerate the scenario in the target environment as we just move the scenario only
We just move the scenario only to the target environment (Not the whole folder), since we've been using the same procedure for a while, and it still works with some migration
When we try to migrate a scenario from development to the target environment, the following error is thrown when we run it in the target environment.
Error -
Session Failed :130647 : ODI-1217: Session EXEC_TABLE_MAINT_PROC-CLN-W_TN_AWARD_VENDOR_DS (130647) fails with return code 7000.
ODI-1226: Step TABLE_MAINT_PROC fails after 1 attempt(s).
ODI-1232: Procedure TABLE_MAINT_PROC execution fails.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 7
java.lang.Exception: Sourced file: inline evaluation of: ``out.print("/*\n") ; import java.lang.Exception; import java.sql.Connection; i . . . '' : TargetError : at Line: 261 : in file: inline evaluation of: ``out.print("/*\n") ; import java.lang.Exception; import java.sql.Connection; i . . . '' : throw vtmSqlErr ;
Target exception: TableException: Custom Exception:Query to get Table Model did not return any rows for Table=W_TN_AWARD_VENDOR_DS TableIdPassed=183092916
in inline evaluation of: ``out.print("/*\n") ; import java.lang.Exception; import java.sql.Connection; i . . . '' at line number 261
We searched for the code that runs during the step. When seeking to match that model ID in TST, where TST model ID is different, it was discovered that it was running on the same model ID where it was produced in DEV. (I've included a screenshot of the model version from DEV and TST below.)
The identical model is then exported from DEV and imported into TST, where model migration results in a new model ID.
Then we deleted the model in TST and rerun the scenario, which also failed**.**