Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Do I really need to call BeginActivity?
- This topic has 1 reply, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
April 6, 2010 at 12:35 AM #24512
–Posting again as a signed user–
The following query lists the values in the bam_<activity>_Active table, where activity = ConveyorOrder:
SELECT *
FROM bam_ConveyorOrder_Active
ORDER BY ActivityID
— SQL data extract at the end of the post
The following code is the only code that begins ConveyorOrder activity and is called only once:
bes.BeginActivity(BAM_ACTIVITY_ConveyorOrder, orderNbr );
bes.UpdateActivity(BAM_ACTIVITY_ConveyorOrder, orderNbr,
BAM_DATA_OrderNumber, conveyorOrder.OrderNumber,
BAM_DATA_DCLocation, conveyorOrder.DCLocation,
BAM_DATA_NumberOfLineItems, conveyorOrder.NumberOfLineItems,
BAM_DATA_NumberOfPickTickets, conveyorOrder.NumberOfPickTickets,
BAM_DATA_NumberofItemsPicked, conveyorOrder.NumberofItemsPicked,
BAM_DATA_ShortPickFlag, conveyorOrder.ShortPickFlag
);
As you can see from query output, the Active table has values in DownloadDateTime and SortedDateTime columns but not in the OrderNumber, DCLocation, NumberOfLineItems, etc. listed in the above code.
The BAM logic collects data for Downloaded when the client system confirms the order has been downloaded and for Sorted when the client system confirms the order has been processed and sorted. These code segments execute while processing a different message and can never be used for BeginActivity.
The problem with the above data is that it was collected bypassing the BeginActivity API call. I am expecting an exception in such cases. Therefore I have the following questions:
1. Why do I really need to call the BeginActivity API if BAM inserts the Activity record anyhow?
2. Am I right in expecting an Exception when that activity doesn’t exist while calling UpdateActivty API for subsequent data updates?
3. This behaviour also confirms that if the messages are received out of sequence, all data will be updated to the columns as processed by the API. Is this by design?
— SQL DATA EXTRACT (screen shot didn’t get pasted)
ActivityID IsVisible IsComplete OrderNumber NumberOfLineItems NumberofItemsPicked NumberOfPickTickets DownloadDateTime InductionDateTime ShortPickFlag SortedDateTime DCLocation LastModified
N306936 NULL 1 NULL NULL NULL NULL NULL 2010-03-30 10:20:33.000 NULL 2010-03-30 10:28:34.000 NULL 2010-04-01 00:06:06.477
N306981 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:20:42.000 NULL 2010-04-01 00:05:46.343
N307042 NULL 0 NULL NULL NULL NULL NULL 2010-03-30 10:14:39.000 NULL NULL NULL 2010-04-01 00:06:07.490
N307055 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:46:23.000 NULL 2010-04-05 23:05:31.373
N307079 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:24:45.000 NULL 2010-04-01 00:05:47.350
N307096 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:29:29.000 NULL 2010-04-01 00:06:07.490
N307097 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:29:33.000 NULL 2010-04-01 00:06:07.493
N307109 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:21:56.000 NULL 2010-04-01 00:05:50.373
N307119 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:28:31.000 NULL 2010-04-01 00:06:06.477
N307357 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:14:33.000 NULL 2010-04-01 00:05:43.300
N307361 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:14:30.000 NULL 2010-04-01 00:05:43.300
N307380 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:19:33.000 NULL 2010-04-01 00:05:51.387
N307381 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:12:33.000 NULL 2010-04-01 00:06:07.493
N307387 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:14:44.000 NULL 2010-04-01 00:06:07.493
N307389 NULL 1 NULL NULL NULL NULL NULL NULL NULL 2010-03-30 10:15:00.000 NULL 2010-04-01 00:06:07.493
N307401 NULL 0 NULL NULL NULL NULL 2010-03-30 10:30:24.000 NULL NULL NULL NULL 2010-04-05 23:05:31.373
N307448 NULL 0 NULL NULL NULL NULL 2010-03-30 10:45:51.000 NULL NULL NULL NULL 2010-04-05 23:05:31.377—
-
April 6, 2010 at 6:59 PM #24523
please see my answer to the anonymous post with same title at http://www.biztalkgurus.com/forums/t/14252.aspx
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.