How to transit from one step to another

[Shantanu Puranik]

Hi,
Would like to know how do we transit from one step to another step. I met the following problem when executing the action of step 2:

"Unable to move current step to history step for #0: root cause: ORA-00001: unique constraint (SYSTEM.SYS.C009597) violated"
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=365143&messageID=451313#451313


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Shantanu Puranik]

The above problem occurred when it wanted to store record into the OS_HISTORYSTEP table. I tried remove the primary key constraint of OS_HISTORYSTEP table, I don't encounter that problem. May I know how are the workflow records being stored in each table e.g. OS_CURRENTSTEP, OS_HISTORYSTEP, OS_HISTORYSTEP_PREV?

Please help, thanks.
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=365143&messageID=452656#452656


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Shantanu Puranik]

The exception indicates that the workflow entry ID on the step is 0. How are you generating primary keys for entries and steps? More specifically, what values did you provide for entry.sequence and step.sequence when you configured the workflow store?
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=365143&messageID=452908#452908


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Shantanu Puranik]

The values are as follow:

<property key="step.sequence" value="SELECT MAX(ID)+1 FROM OS_CURRENTSTEP" />
<property key="entry.sequence" value="SELECT MAX(ID)+1 FROM OS_WFENTRY" />
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=365143&messageID=453540#453540


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Shantanu Puranik]

Hi Samer,

I have solved the error by setting the two id as follow:
<property key="step.sequence" value="SELECT seq_os_currentsteps.nextval FROM dual" />
<property key="entry.sequence" value="SELECT seq_os_wfentry.nextval FROM dual" />

Thanks for your help. =)
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=365143&messageID=453714#453714


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Shantanu Puranik]

Good to hear!
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=365143&messageID=454198#454198


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...