Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OdiStartScen in async mode: variables lost in execution queue

673655Dec 3 2008 — edited Feb 23 2009
I have the following case:
- a scenario must be called for each row in a database table
- this scenario has a variable, declared in the scenario parent package: variable values are read from the table
- rows are more than the "maximum number of sessions" for the agent
- execution of the scenarios should run in parallel

So I made a procedure, with only one step. The source command is something like "SELECT col1 alias1 FROM MyTable". The target command, on Sunopsis API, is OdiStartScen -SCEN_NAME=MyScenario "-GLOBAL.VAR1=#alias1"

When the procedure is executed by the agent, I have the following outcomes:
- if OdiStartScen is run synchronously (-SYNC_MODE=1): OK, no problem
- if OdiStartScen is run asynchronously (-SYNC_MODE=2) AND the number of rows in MyTable is less than the "Maximum number of sessions" set in Topology Manager for the executing agent: OK, no problem
- if OdiStartScen is run in async mode, and the number of rows in MyTable is greater then the maximum number of sessions, then the execution is OK only for the first rows of the table. Successive executions get enqueued, but when it's time for the agent to run them, Operator reports the followin error: "Variable has no value".

So it seems to me that variable values don't get enqueued, is it correct?

Comments

SURFThru
You could make all the columns as parameters in the update stored procedure.

Then on your table adapter add the call to the update stored proc. Name the update prc_your_update_name. Then in your code you can just run ta.prc_your_update_name(field1,field2,....). Not sure if this is what you are looking for and maybe you want to avoid typing all the colunms as paramters.

Edited by: SURFThru on Jun 22, 2011 1:45 PM
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 23 2009
Added on Dec 3 2008
#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration, #variable
18 comments
4,092 views