This content has been marked as final. Show 7 replies
If you want to keep log of session, you have to set the log level to 1.
If you also want the steps, set it to 2.
If you also want the tasks, set it to 3.
If in addition of all of that, you want the SQL statements set it to 4.
The complete trace is 5.
So 0 means that everything will be deleted after the execution.
Hope it helps.
But the flow is that i have 3 scenarios:
1. Scenario A
2. Scenario B
3. Scenario C
Scenario A calls B which calls C. Scenario C executes successfully, then Scenario B finalizes successfully, but then it should have Finalized Scenario A also successfully as making call to Scenario B is its last step, which some how how it doesnt. Scenario B and C are deleted from operator which is OK but it doesnt delete Scenario A and marks it as failed.
I just get "SnpSession does not exist" error on this, this error is generated if we don't have an entry for that scenario in SNP_Session table. However, ODI if is provided with log level 0 deletes corresponding entries from SNP_Session table on successful completion of a scenario. Which is also happening in my case and entries are being deleted from table for Scen B and Scen C, but since Scen fails it remains in the table. Again, Once I have gotten the log_level in a variable in Scen A i am just making use of that variable in the subsequent scenarios. Also, when executed with log level 1, 2, 3, 4, 5 it works jolly good.