Do I really need to call BeginActivity?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Do I really need to call BeginActivity?

Viewing 1 reply thread
  • Author
    Posts
    • #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

      —

    • #24523

      please see my answer to the anonymous post with same title at http://www.biztalkgurus.com/forums/t/14252.aspx

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.