Workflow Instance cause CPU over 50%

Workflow Instance cause CPU over 50%

Postby EmilyFong » Mon 04 Feb 2013 04:36

Hi,

I am using devart.data.oracle.workflowfunction (version 6.80.350.0) in my workflow service (host in IIS) to connect to Oracle (11g R1).
I found that once I start a new workflow instance with my client application, the CPU in database server will up to 50 (for oracle.exe only). After 5 minutes or more, the CPU will be down again.
In Orcale session, I found the following statement run again and again.
BEGIN
:result :=
InstanceStoreLogic.LoadInstance (:p_surrogateLockOwnerId,
:p_operationType,
:p_keyToLoadBy,
:p_instanceId,
:p_handleInstanceVersion,
:p_handleIsBoundToLock,
:p_keysToAssociateId,
:p_keysToAssociateData,
:p_singleKeyId,
:p_encodingOption,
:p_operationTimeout,
:p_instance,
:p_changes,
:p_keys);
END;


I tried to add a insert statement in LoadInstance function, and found that it only insert one record with the p_instanceid '00000000000000000000000000000000'.

I would like to know how can I trace this problem.

Thanks!


Best Regards,
Emily
EmilyFong
 
Posts: 12
Joined: Sun 20 May 2012 04:25

Re: Workflow Instance cause CPU over 50%

Postby Shalex » Wed 06 Feb 2013 16:07

We have sent a test project to the e-mail you have specified when registering at our forum. Please modify the code and send it back to us so that we can reproduce the problem in our environment.
Shalex
Devart Team
 
Posts: 7377
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle