Workflow Instance cause CPU over 50%

[EmilyFong]

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

[Shalex]

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.