| Tom Spitzer 2004-03-26, 7:38 pm |
| This appears to be a problem in Biztalk. I am receiving flat files through a
file receive function.
Document tracking shows this interchange at 9:13:19 a.m.
{2ABA16BC-6FFB-4021-ADE7-E2088D64854C} :
302ý63052ý000000ýHý2004-03- 26ý11:36:22ýSALEýýýCOMPLETEý1ý32313ýS003
020000042
24ýýýýebpfcý0ý0.00ý0.00ý0.00
302ý63052ý001000ýDý2004-03- 26ý11:36:22ýITEMýSALEýýNý1ý32313,N,NýSDý
Ný601ýý1
Person Sittingý1ý9.95ý9.95ý9.95
302ý63052ý001001ýDý2004-03- 26ý11:36:22ýIDISCýýýý1ýýýý601ýebpfcýý1ý0
.00ý-9.95
ý-9.95
302ý63052ý002001ýDý2004-03- 26ý11:36:22ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00ý
0.00
302ý63052ý003000ýDý2004-03-26ý11:36:22ýTOTALýýýý1ýýýýýýý0ý0.00ý0.00ý0.00
302ý63052ý004000ýTý2004-03-26ý11:36:22ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý3ý0.00ý0.00ý0.00
302ý63053ý000000ýHý2004-03- 26ý12:05:03ýSALEýýýCOMPLETEý1ý32313ýS003
020000078
58ýýý63048ýebcdbý0ý0.00ý0.00ý0.00
302ý63053ý001000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýNý1ý32313,12767,N
ýASDýNý96
78ýýSitting Creditý1ý-0.00ý0.00ý0.00
302ý63053ý002000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýNý1ý32313,12767,N
ýASFýTý96
79ýýSitting Feeý1ý0.00ý0.00ý0.00
302ý63053ý003000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýYý1ý32313,12767,N
ýCPýTý269
1ýýPose Full Lengthý1ý40.00ý40.00ý40.00
302ý63053ý004000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýYý1ý32313,12767,N
ýCPýTý270
3ýýPose Signatureý1ý40.00ý40.00ý40.00
302ý63053ý004001ýDý2004-03-26ý12:05:03ýIDISCýýýý1ýýý01ý2703ýýý1ý0.00ý-5.00ý-
5.00
302ý63053ý005000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýYý1ý32313,12767,N
ýCPýTý271
2ýýPose Close-upý1ý40.00ý40.00ý40.00
302ý63053ý005001ýDý2004-03-26ý12:05:03ýIDISCýýýý1ýýý01ý2712ýýý1ý0.00ý-5.00ý-
5.00
302ý63053ý006000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýNý1ý32313,12767,N
ýCPýTý272
3ýýWall Print Propý1ý18.00ý18.00ý18.00
302ý63053ý006001ýDý2004-03- 26ý12:05:03ýIDISCýýýý1ýýýý2723ýebcdbýý1ý
0.00ý-18.
00ý-18.00
302ý63053ý007000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýNý1ý32313,12767,N
ýCPýTý272
6ýý8x10 Personalityý1ý15.00ý0.00ý0.00
302ý63053ý007001ýDý2004-03- 26ý12:05:03ýOVERRIDEý1ýýý1ýýýý2726ýý8x10
Personalityý1ý15.00ý0.00ý0.00
302ý63053ý008001ýDý2004-03-26ý12:05:03ýTRANSTAXýNC01ýýý1ýýýýýýý0ý4.96ý0.00ý0
..00
302ý63053ý008002ýDý2004-03- 26ý12:05:03ýTRANSTAXýNCBUNCOMBE01ýýý1ýýý
ýýýý0ý2.7
6ý0.00ý0.00
302ý63053ý008003ýDý2004-03- 26ý12:05:03ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00ý
0.00
302ý63053ý009000ýDý2004-03-26ý12:05:03ýTOTALýýýý1ýýýýýýý0ý0.00ý110.00ý117.72
302ý63053ý010000ýDý2004-03- 26ý12:05:03ýTENDERýýý0105ý1ý546641026148
7315=0501
1010000009330000ýý5466410261487315ýMAý28
8762ýUSDollarý0ý0.00ý0.00ý117.72
302ý63053ý011000ýTý2004-03-26ý12:05:03ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý10ý0.00ý0.00ý0.00
302ý63054ý000000ýHý2004-03- 26ý12:08:41ýSALEýýýCOMPLETEý1ý32313ýS003
020000099
16ýýýýnoneý0ý0.00ý0.00ý0.00
302ý63054ý001000ýDý2004-03- 26ý12:08:41ýITEMýSALEýýNý1ý32313,N,NýSDý
Ný601ýý1
Person Sittingý1ý9.95ý9.95ý9.95
302ý63054ý002001ýDý2004-03- 26ý12:08:41ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00ý
0.00
302ý63054ý003000ýDý2004-03-26ý12:08:41ýTOTALýýýý1ýýýýýýý0ý0.00ý9.95ý9.95
302ý63054ý004000ýDý2004-03- 26ý12:08:41ýTENDERýýý0505ý1ý544579412905
6651=0505
10113101103ýý5445794129056651ýMAý062720ý
USDollarý0ý0.00ý0.00ý9.95
302ý63054ý005000ýTý2004-03-26ý12:08:41ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý4ý0.00ý0.00ý0.00
Immediately after, it shows this incoming interchange (same time stamp).
{3D905546-2E76-4A31-BABE-934B001DC773}
142ý106140ý000000ýHý2004-03- 26ý11:26:50ýSALEýýýCOMPLETEý1ý51569ýS001
42000013
119ýýýýnoneý0ý0.00ý0.00ý0.00
142ý106140ý001000ýDý2004-03- 26ý11:26:50ýITEMýSALEýýNý1ý51569,N,NýSDý
Ný4414ýý
Family Sittingý1ý19.95ý19.95ý19.95
142ý106140ý001001ýDý2004-03-26ý11:26:50ýIDISCýPCMýýý1ýýýý4414ýýý1ý0.00ý-19.9
5ý-19.95
142ý106140ý002001ýDý2004-03- 26ý11:26:50ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00
ý0.00
142ý106140ý003000ýDý2004-03-26ý11:26:50ýTOTALýýýý1ýýýýýýý0ý0.00ý0.00ý0.00
142ý106140ý004000ýTý2004-03-26ý11:26:50ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý3ý0.00ý0.00ý0.00
142ý106141ý000000ýHý2004-03- 26ý11:33:12ýSALEýýýCOMPLETEý1ý51569ýS001
42000003
424ýýýýnoneý0ý0.00ý0.00ý0.00
142ý106141ý001000ýDý2004-03- 26ý11:33:12ýITEMýSALEýýNý1ý51569,N,NýSDý
Ný4414ýý
Family Sittingý1ý19.95ý19.95ý19.95
142ý106141ý001001ýDý2004-03-26ý11:33:12ýIDISCýPCMýýý1ýýýý4414ýýý1ý0.00ý-19.9
5ý-19.95
142ý106141ý002001ýDý2004-03- 26ý11:33:12ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00
ý0.00
142ý106141ý003000ýDý2004-03-26ý11:33:12ýTOTALýýýý1ýýýýýýý0ý0.00ý0.00ý0.00
142ý106141ý004000ýTý2004-03-26ý11:33:12ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý3ý0.00ý0.00ý0.00
142ý106142ý000000ýHý2004-03- 26ý11:35:38ýSALEýýýCOMPLETEý1ý51569ýS001
42000005
200ýýý106131ýibpmaý0ý0.00ý0.00ý0.00
142ý106142ý001000ýDý2004-03- 26ý11:35:38ýITEMýSALEýýNý1ý51569,N,NýASD
ýNý9678ý
ýSitting Creditý1ý-0.00ý0.00ý0.00
142ý106142ý002000ýDý2004-03- 26ý11:35:38ýITEMýSALEýýNý1ý51569,N,NýASF
ýTý9679ý
ýSitting Feeý1ý0.00ý0.00ý0.00
142ý106142ý003000ýDý2004-03- 26ý11:35:38ýITEMýSALEýýNý1ý51569,N,NýCPý
Tý2687ýý
8x10 Full Lengthý1ý15.00ý15.00ý15.00
142ý106142ý003001ýDý2004-03- 26ý11:35:38ýIDISCýýýý1ýýýý2687ýibpmaýý1ý
0.00ý-15
..00ý-15.00
142ý106142ý004000ýDý2004-03- 26ý11:35:38ýITEMýSALEýýYý1ý51569,N,NýCPý
Tý2689ýý
Wallets Full Lengthý1ý15.00ý15.00ý15.00
142ý106142ý005001ýDý2004-03- 26ý11:35:38ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00
ý0.00
142ý106142ý005002ýDý2004-03-26ý11:35:38ýTRANSTAXýVA01ýýý1ýýýýýýý0ý0.68ý0.00ý
0.00
142ý106142ý006000ýDý2004-03-26ý11:35:38ýTOTALýýýý1ýýýýýýý0ý0.00ý15.00ý15.68
142ý106142ý007000ýDý2004-03- 26ý11:35:38ýTENDERýýý0906ý1ý402070000001
4509=060
91010000004100000ýý4020700000014509ýVIý2
67672ýUSDollarý0ý0.00ý0.00ý15.68
142ý106142ý008000ýTý2004-03-26ý11:35:38ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý7ý0.00ý0.00ý0.00
142ý106143ý000000ýHý2004-03- 26ý11:54:33ýSALEýýýCOMPLETEý1ý16383ýS001
42000013
197ýýýýnoneý0ý0.00ý0.00ý0.00
142ý106143ý001000ýDý2004-03- 26ý11:54:33ýITEMýSALEýýNý1ý16383,N,NýSDý
Ný602ýý2
Person Sittingý1ý19.90ý19.90ý19.90
142ý106143ý001001ýDý2004-03-26ý11:54:33ýIDISCýPCMýýý1ýýýý602ýýý1ý0.00ý-19.90
ý-19.90
142ý106143ý002001ýDý2004-03- 26ý11:54:33ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00
ý0.00
142ý106143ý003000ýDý2004-03-26ý11:54:33ýTOTALýýýý1ýýýýýýý0ý0.00ý0.00ý0.00
142ý106143ý004000ýTý2004-03-26ý11:54:33ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý3ý0.00ý0.00ý0.00
142ý106144ý000000ýHý2004-03- 26ý12:00:52ýSALEýýýCOMPLETEý1ý16383ýS001
42000011
857ýýýýibpdcý0ý0.00ý0.00ý0.00
142ý106144ý001000ýDý2004-03- 26ý12:00:52ýITEMýSALEýýNý1ý16383,N,NýSDý
Ný601ýý1
Person Sittingý1ý9.95ý9.95ý9.95
142ý106144ý001001ýDý2004-03- 26ý12:00:52ýIDISCýýýý1ýýýý601ýibpdcýý1ý0
.00ý-9.9
5ý-9.95
142ý106144ý002001ýDý2004-03- 26ý12:00:52ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00
ý0.00
142ý106144ý003000ýDý2004-03-26ý12:00:52ýTOTALýýýý1ýýýýýýý0ý0.00ý0.00ý0.00
142ý106144ý004000ýTý2004-03-26ý12:00:52ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý3ý0.00ý0.00ý0.00
142ý106145ý000000ýHý2004-03- 26ý12:06:06ýSALEýýýCOMPLETEý1ý16383ýS001
42000010
698ýýýýnoneý0ý0.00ý0.00ý0.00
142ý106145ý001000ýDý2004-03- 26ý12:06:06ýITEMýSALEýýNý1ý16383,N,NýýNý
4030ýýRe
shoot (San Marco)ý1ý0.00ý0.00ý0.00
142ý106145ý002001ýDý2004-03- 26ý12:06:06ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00
ý0.00
142ý106145ý003000ýDý2004-03-26ý12:06:06ýTOTALýýýý1ýýýýýýý0ý0.00ý0.00ý0.00
142ý106145ý004000ýTý2004-03-26ý12:06:06ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý3ý0.00ý0.00ý0.00
302ý63052ý000000ýHý2004-03- 26ý11:36:22ýSALEýýýCOMPLETEý1ý32313ýS003
020000042
24ýýýýebpfcý0ý0.00ý0.00ý0.00
302ý63052ý001000ýDý2004-03- 26ý11:36:22ýITEMýSALEýýNý1ý32313,N,NýSDý
Ný601ýý1
Person Sittingý1ý9.95ý9.95ý9.95
302ý63052ý001001ýDý2004-03- 26ý11:36:22ýIDISCýýýý1ýýýý601ýebpfcýý1ý0
.00ý-9.95
ý-9.95
302ý63052ý002001ýDý2004-03- 26ý11:36:22ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00ý
0.00
302ý63052ý003000ýDý2004-03-26ý11:36:22ýTOTALýýýý1ýýýýýýý0ý0.00ý0.00ý0.00
302ý63052ý004000ýTý2004-03-26ý11:36:22ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý3ý0.00ý0.00ý0.00
302ý63053ý000000ýHý2004-03- 26ý12:05:03ýSALEýýýCOMPLETEý1ý32313ýS003
020000078
58ýýý63048ýebcdbý0ý0.00ý0.00ý0.00
302ý63053ý001000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýNý1ý32313,12767,N
ýASDýNý96
78ýýSitting Creditý1ý-0.00ý0.00ý0.00
302ý63053ý002000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýNý1ý32313,12767,N
ýASFýTý96
79ýýSitting Feeý1ý0.00ý0.00ý0.00
302ý63053ý003000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýYý1ý32313,12767,N
ýCPýTý269
1ýýPose Full Lengthý1ý40.00ý40.00ý40.00
302ý63053ý004000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýYý1ý32313,12767,N
ýCPýTý270
3ýýPose Signatureý1ý40.00ý40.00ý40.00
302ý63053ý004001ýDý2004-03-26ý12:05:03ýIDISCýýýý1ýýý01ý2703ýýý1ý0.00ý-5.00ý-
5.00
302ý63053ý005000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýYý1ý32313,12767,N
ýCPýTý271
2ýýPose Close-upý1ý40.00ý40.00ý40.00
302ý63053ý005001ýDý2004-03-26ý12:05:03ýIDISCýýýý1ýýý01ý2712ýýý1ý0.00ý-5.00ý-
5.00
302ý63053ý006000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýNý1ý32313,12767,N
ýCPýTý272
3ýýWall Print Propý1ý18.00ý18.00ý18.00
302ý63053ý006001ýDý2004-03- 26ý12:05:03ýIDISCýýýý1ýýýý2723ýebcdbýý1ý
0.00ý-18.
00ý-18.00
302ý63053ý007000ýDý2004-03- 26ý12:05:03ýITEMýSALEýýNý1ý32313,12767,N
ýCPýTý272
6ýý8x10 Personalityý1ý15.00ý0.00ý0.00
302ý63053ý007001ýDý2004-03- 26ý12:05:03ýOVERRIDEý1ýýý1ýýýý2726ýý8x10
Personalityý1ý15.00ý0.00ý0.00
302ý63053ý008001ýDý2004-03-26ý12:05:03ýTRANSTAXýNC01ýýý1ýýýýýýý0ý4.96ý0.00ý0
..00
302ý63053ý008002ýDý2004-03- 26ý12:05:03ýTRANSTAXýNCBUNCOMBE01ýýý1ýýý
ýýýý0ý2.7
6ý0.00ý0.00
302ý63053ý008003ýDý2004-03- 26ý12:05:03ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00ý
0.00
302ý63053ý009000ýDý2004-03-26ý12:05:03ýTOTALýýýý1ýýýýýýý0ý0.00ý110.00ý117.72
302ý63053ý010000ýDý2004-03- 26ý12:05:03ýTENDERýýý0105ý1ý546641026148
7315=0501
1010000009330000ýý5466410261487315ýMAý28
8762ýUSDollarý0ý0.00ý0.00ý117.72
302ý63053ý011000ýTý2004-03-26ý12:05:03ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT:ý10ý0.00ý0.00ý0.00
302ý63054ý000000ýHý2004-03- 26ý12:08:41ýSALEýýýCOMPLETEý1ý32313ýS003
020000099
16ýýýýnoneý0ý0.00ý0.00ý0.00
302ý63054ý001000ýDý2004-03- 26ý12:08:41ýITEMýSALEýýNý1ý32313,N,NýSDý
Ný601ýý1
Person Sittingý1ý9.95ý9.95ý9.95
302ý63054ý002001ýDý2004-03- 26ý12:08:41ýTRANSTAXýNOTAXýýý1ýýýýýýý0ý0
.00ý0.00ý
0.00
302ý63054ý003000ýDý2004-03-26ý12:08:41ýTOTALýýýý1ýýýýýýý0ý0.00ý9.95ý9.95
302ý63054ý004000ýDý2004-03- 26ý12:08:41ýTENDERýýý0505ý1ý544579412905
6651=0505
10113101103ýý5445794129056651ýMAý062720ý
USDollarý0ý0.00ý0.00ý9.95
302ý63054ý005000ýTý2004-03-26ý12:08:41ýTRAILERýýýý1ýýýýýýMAJOR DETAIL
LINECOUNT
Notice that BTS has taken the contents of the earlier interchange and
included them at the back end of the second interchange. The first piece of
data ('142', '302') is a site identifier. Each site submits its own files,
so the files did not arrive this way.
I'm putting the data into SQL server, and the timestamps make it appear that
we are receiving these files within a few milliseconds of one another. It
looks like Biztalk is merging data on different receive function threads
when this occurs.
I have Maximum number of receive function threads allowed = 4. Do you think
that if I reduced this to 1, the problem would go away?
thanks,
Tom Spitzer
|