Error message “transaction counts in group don’t match reality” when running file through Liaison EDI Notepad

Error received is "At envelope 01/080211920->01/018978783, Ctrl+000000700
At group 080211920->018978783, Ctrl=900021426
The transaction counts in group don't match reality. 6 vs. 1
Larry DroletAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
Larry,

<<  The GE segment references 6.  Is this what is throwing the data off?  >>

 Yes, you spotted it!.   Your GE indicates six documents in the group, but there is only one ST/SE pair.

This:
GE~6~900021426

Should be:
GE~1~900021426

Jim.
1
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Not sure your going to get an answer....may have to call Liaison directly.  I use EDI notepad, but not for translation.

Was that the exact error message?  And it may not be EDI notepad; can you look at the raw EDI data and verify that indeed the document is invalid (assuming you got this while loading the document)?

I'll look around to for a better topic area.   SQL Server is certainly not it.

Jim.
0
 
Larry DroletAuthor Commented:
Hi Jim,

"At envelope 01/080211920->01/018978783, Ctrl+000000700
At group 080211920->018978783, Ctrl=900021426
The transaction counts in group don't match reality. 6 vs. 1"

is the exact error message received.  The ASN raw data below is what I am working with.  I just have never encountered this error before and do not know what it means.  There are 5 POs in the ASN – PRF segments.  The GE segment references 6.  Is this what is throwing the data off?  Thanks for responding.

ISA~00~          ~00~          ~01~080211920      ~01~018978783      ~161022~1504~U~00200~000000700~0~P~=
GS~SH~080211920~018978783~20161022~1504~900021426~X~004010
ST~856~214260004
BSN~00~386984400002~20161022~100140
HL~1~~S
TD1~CTN~1212~~~~~30760.03~LB
TD5~~2~HJBT~T
REF~BM~019166900002
REF~CN~5441025
DTM~011~20161021
N1~ST~~92~0101
N1~CA~J.B. HUNT TRANSPORTATION
N1~SF~DALLAS - TOPS DIST CNTR
N3~39324 LBJ FREEWAY
N4~DALLAS~TX~75232~USA
CUR~91~USD
HL~2~1~O
PRF~0107047
REF~AI~386984400002
HL~3~2~T
MAN~GM~00100875471016086426
PAL~6~~~2
HL~4~3~I
LIN~006~IN~UNV35262~UP~087547352625
SN1~~20~BX~~20~BX~~AC
SLN~006~~I~20~BX~6.95
HL~5~1~O
PRF~0107808
REF~AI~380908100001
HL~6~5~T
MAN~GM~00100000001016086283
PAL~6~~~23
HL~7~6~I
LIN~003~IN~UNV35210~UP~087547352106
SN1~~55~BX~~175~BX~~AC
SLN~003~~I~55~BX~7.93
HL~8~6~I
LIN~021~IN~UNV36102~UP~087547361023
SN1~~60~BX~~60~BX~~AC
SLN~021~~I~60~BX~21.59
HL~9~5~T
MAN~GM~00100000001016086481
PAL~6~~~32
HL~10~9~I
LIN~009~IN~UNV35267~UP~087547352670
SN1~~55~BX~~180~BX~~AC
SLN~009~~I~55~BX~7.72
HL~11~9~I
LIN~014~IN~UNV35292~UP~087547352922
SN1~~4~BX~~4~BX~~AC
SLN~014~~I~4~BX~28.25
HL~12~9~I
LIN~023~IN~UNV36301~UP~087547363010
SN1~~70~BX~~70~BX~~AC
SLN~023~~I~70~BX~14.04
HL~13~9~I
LIN~028~IN~UNV40102~UP~087547401026
SN1~~25~BX~~25~BX~~AC
SLN~028~~I~25~BX~7.96
HL~14~5~T
MAN~GM~00100000001016086689
PAL~6~~~29
HL~15~14~I
LIN~002~IN~UNV35209~UP~087547352090
SN1~~10~BX~~10~BX~~AC
SLN~002~~I~10~BX~16.25
HL~16~14~I
LIN~005~IN~UNV35261~UP~087547352618
SN1~~20~BX~~20~BX~~AC
SLN~005~~I~20~BX~7.19
HL~17~14~I
LIN~007~IN~UNV35264~UP~087547352649
SN1~~40~BX~~340~BX~~AC
SLN~007~~I~40~BX~6.25
HL~18~14~I
LIN~012~IN~UNV35290~UP~087547352908
SN1~~16~BX~~16~BX~~AC
SLN~012~~I~16~BX~23.47
HL~19~14~I
LIN~016~IN~UNV36002~UP~087547360026
SN1~~24~BX~~24~BX~~AC
SLN~016~~I~24~BX~4.3
HL~20~14~I
LIN~022~IN~UNV36300~UP~087547363003
SN1~~15~BX~~15~BX~~AC
SLN~022~~I~15~BX~14.57
HL~21~14~I
LIN~033~IN~UNV42101~UP~087547421017
SN1~~30~BX~~30~BX~~AC
SLN~033~~I~30~BX~7.54
HL~22~14~I
LIN~041~IN~UNV45165~UP~087547451656
SN1~~2~BX~~2~BX~~AC
SLN~041~~I~2~BX~37.52
HL~23~5~T
MAN~GM~00100000001016087068
PAL~6~~~12
HL~24~23~I
LIN~001~IN~UNV35202~UP~087547352021
SN1~~20~BX~~20~BX~~AC
SLN~001~~I~20~BX~11.9
HL~25~23~I
LIN~025~IN~UNV36321~UP~087547363218
SN1~~40~BX~~40~BX~~AC
SLN~025~~I~40~BX~12.57
HL~26~5~T
MAN~GM~00100875471016086006
PAL~6~~~30
HL~27~26~I
LIN~010~IN~UNV35268~UP~087547352687
SN1~~20~BX~~20~BX~~AC
SLN~010~~I~20~BX~11.71
HL~28~26~I
LIN~017~IN~UNV36003~UP~087547360033
SN1~~55~BX~~55~BX~~AC
SLN~017~~I~55~BX~15.12
HL~29~26~I
LIN~019~IN~UNV36100~UP~087547361009
SN1~~15~BX~~15~BX~~AC
SLN~019~~I~15~BX~18.8
HL~30~26~I
LIN~020~IN~UNV36101~UP~087547361016
SN1~~15~BX~~15~BX~~AC
SLN~020~~I~15~BX~19.6
HL~31~26~I
LIN~026~IN~UNV40099~UP~087547400999
SN1~~10~BX~~10~BX~~AC
SLN~026~~I~10~BX~8.81
HL~32~26~I
LIN~027~IN~UNV40100~UP~087547401002
SN1~~20~BX~~20~BX~~AC
SLN~027~~I~20~BX~7.89
HL~33~26~I
LIN~039~IN~UNV44165~UP~087547441657
SN1~~6~BX~~6~BX~~AC
SLN~039~~I~6~BX~23.07
HL~34~5~T
MAN~GM~00100875471016086297
PAL~6~~~20
HL~35~34~I
LIN~007~IN~UNV35264~UP~087547352649
SN1~~100~BX~~340~BX~~AC
SLN~007~~I~100~BX~6.25
HL~36~5~T
MAN~GM~00100875471016086303
PAL~6~~~20
HL~37~36~I
LIN~007~IN~UNV35264~UP~087547352649
SN1~~100~BX~~340~BX~~AC
SLN~007~~I~100~BX~6.25
HL~38~5~T
MAN~GM~00100875471016086310
PAL~6~~~30
HL~39~38~I
LIN~006~IN~UNV35262~UP~087547352625
SN1~~20~BX~~20~BX~~AC
SLN~006~~I~20~BX~9.44
HL~40~38~I
LIN~008~IN~UNV35265~UP~087547352656
SN1~~25~BX~~25~BX~~AC
SLN~008~~I~25~BX~9.96
HL~41~38~I
LIN~013~IN~UNV35291~UP~087547352915
SN1~~4~BX~~4~BX~~AC
SLN~013~~I~4~BX~21.9
HL~42~38~I
LIN~015~IN~UNV36000~UP~087547360002
SN1~~12~BX~~12~BX~~AC
SLN~015~~I~12~BX~3.81
HL~43~38~I
LIN~030~IN~UNV41165~UP~087547411650
SN1~~16~BX~~16~BX~~AC
SLN~030~~I~16~BX~18.75
HL~44~38~I
LIN~031~IN~UNV41907~UP~087547419076
SN1~~10~BX~~10~BX~~AC
SLN~031~~I~10~BX~10.57
HL~45~38~I
LIN~032~IN~UNV42100~UP~087547421000
SN1~~10~BX~~10~BX~~AC
SLN~032~~I~10~BX~6.6
HL~46~38~I
LIN~034~IN~UNV42102~UP~087547421024
SN1~~10~BX~~10~BX~~AC
SLN~034~~I~10~BX~8.88
HL~47~38~I
LIN~035~IN~UNV42165~UP~087547421659
SN1~~6~BX~~6~BX~~AC
SLN~035~~I~6~BX~23.27
HL~48~38~I
LIN~036~IN~UNV42907~UP~087547429075
SN1~~5~BX~~5~BX~~AC
SLN~036~~I~5~BX~12.38
HL~49~38~I
LIN~037~IN~UNV44104~UP~087547441046
SN1~~12~BX~~12~BX~~AC
SLN~037~~I~12~BX~17.89
HL~50~38~I
LIN~038~IN~UNV44105~UP~087547441053
SN1~~2~BX~~2~BX~~AC
SLN~038~~I~2~BX~17.53
HL~51~38~I
LIN~040~IN~UNV44907~UP~087547449073
SN1~~15~BX~~15~BX~~AC
SLN~040~~I~15~BX~12.7
HL~52~5~T
MAN~GM~00100875471016086341
PAL~6~~~20
HL~53~52~I
LIN~007~IN~UNV35264~UP~087547352649
SN1~~100~BX~~340~BX~~AC
SLN~007~~I~100~BX~6.25
HL~54~5~T
MAN~GM~00100875471016086365
PAL~6~~~20
HL~55~54~I
LIN~009~IN~UNV35267~UP~087547352670
SN1~~100~BX~~180~BX~~AC
SLN~009~~I~100~BX~7.72
HL~56~5~T
MAN~GM~00100875471016086600
PAL~6~~~11
HL~57~56~I
LIN~009~IN~UNV35267~UP~087547352670
SN1~~25~BX~~180~BX~~AC
SLN~009~~I~25~BX~7.72
HL~58~56~I
LIN~024~IN~UNV36319~UP~087547363195
SN1~~6~BX~~6~BX~~AC
SLN~024~~I~6~BX~3.61
HL~59~5~T
MAN~GM~00100875471016086761
PAL~6~~~24
HL~60~59~I
LIN~003~IN~UNV35210~UP~087547352106
SN1~~120~BX~~175~BX~~AC
SLN~003~~I~120~BX~7.93
HL~61~5~T
MAN~GM~00100875471016086785
PAL~6~~~17
HL~62~61~I
LIN~004~IN~UNV35260~UP~087547352601
SN1~~170~BX~~170~BX~~AC
SLN~004~~I~170~BX~6.17
HL~63~1~O
PRF~0107809
REF~AI~101565800001
HL~64~63~T
MAN~GM~00100421671016085945
PAL~6~~~11
HL~65~64~I
LIN~001~IN~OFF82292~UP~042167822927
SN1~~5~BX~~5~BX~~AC
SLN~001~~I~5~BX~11.92
HL~66~64~I
LIN~002~IN~OFF82301~UP~042167823016
SN1~~10~BX~~10~BX~~AC
SLN~002~~I~10~BX~7.42
HL~67~64~I
LIN~003~IN~OFF82302~UP~042167823023
SN1~~30~BX~~30~BX~~AC
SLN~003~~I~30~BX~8.44
HL~68~64~I
LIN~004~IN~OFF82303~UP~042167823030
SN1~~10~BX~~10~BX~~AC
SLN~004~~I~10~BX~10.25
HL~69~64~I
LIN~005~IN~OFF82304~UP~042167823047
SN1~~5~BX~~5~BX~~AC
SLN~005~~I~5~BX~14.82
HL~70~1~O
PRF~0108319
REF~AI~216853600001
HL~71~70~T
MAN~GM~00100421671016086577
PAL~6~~~27
HL~72~71~I
LIN~001~IN~UNV10201~UP~087547102015
SN1~~20~BX~~20~BX~~AC
SLN~001~~I~20~BX~13.46
HL~73~71~I
LIN~002~IN~UNV10202~UP~087547102022
SN1~~20~BX~~20~BX~~AC
SLN~002~~I~20~BX~13.46
HL~74~71~I
LIN~004~IN~UNV10251~UP~087547102510
SN1~~10~BX~~10~BX~~AC
SLN~004~~I~10~BX~13.46
HL~75~71~I
LIN~010~IN~UNV10503~UP~087547105030
SN1~~70~BX~~70~BX~~AC
SLN~010~~I~70~BX~9.3
HL~76~71~I
LIN~030~IN~UNV13930~UP~087547139301
SN1~~10~EA~~10~EA~~AC
SLN~030~~I~10~EA~5.67
HL~77~71~I
LIN~048~IN~UNV57119~UP~087547571194
SN1~~5~BX~~5~BX~~AC
SLN~048~~I~5~BX~10.18
HL~78~70~T
MAN~GM~00100875471016086426
PAL~6~~~22
HL~79~78~I
LIN~029~IN~UNV13910~UP~087547139103
SN1~~35~EA~~35~EA~~AC
SLN~029~~I~35~EA~5.61
HL~80~78~I
LIN~034~IN~UNV14215~UP~087547142158
SN1~~150~BX~~630~BX~~AC
SLN~034~~I~150~BX~6.68
HL~81~70~T
MAN~GM~00100875471016086457
PAL~6~~~48
HL~82~81~I
LIN~009~IN~UNV10502~UP~087547105023
SN1~~15~BX~~15~BX~~AC
SLN~009~~I~15~BX~9.3
HL~83~81~I
LIN~011~IN~UNV10504~UP~087547105047
SN1~~60~BX~~60~BX~~AC
SLN~011~~I~60~BX~9.3
HL~84~81~I
LIN~012~IN~UNV10505~UP~087547105054
SN1~~15~BX~~15~BX~~AC
SLN~012~~I~15~BX~9.3
HL~85~81~I
LIN~013~IN~UNV10506~UP~087547105061
SN1~~35~BX~~35~BX~~AC
SLN~013~~I~35~BX~9.3
HL~86~81~I
LIN~014~IN~UNV10507~UP~087547105078
SN1~~5~BX~~5~BX~~AC
SLN~014~~I~5~BX~9.3
HL~87~81~I
LIN~017~IN~UNV12122~UP~087547121221
SN1~~35~BX~~35~BX~~AC
SLN~017~~I~35~BX~6.73
HL~88~81~I
LIN~018~IN~UNV12301~UP~087547123010
SN1~~15~BX~~15~BX~~AC
SLN~018~~I~15~BX~8.59
HL~89~81~I
LIN~021~IN~UNV12305~UP~087547123058
SN1~~5~BX~~5~BX~~AC
SLN~021~~I~5~BX~8.59
HL~90~81~I
LIN~023~IN~UNV13410~UP~087547134108
SN1~~25~BX~~25~BX~~AC
SLN~023~~I~25~BX~8.01
HL~91~81~I
LIN~026~IN~UNV13522~UP~087547135228
SN1~~10~BX~~10~BX~~AC
SLN~026~~I~10~BX~13.41
HL~92~81~I
LIN~042~IN~UNV16166~UP~087547161661
SN1~~20~BX~~20~BX~~AC
SLN~042~~I~20~BX~10.01
HL~93~70~T
MAN~GM~00100875471016086617
PAL~6~~~35
HL~94~93~I
LIN~003~IN~UNV10212~UP~087547102121
SN1~~15~BX~~15~BX~~AC
SLN~003~~I~15~BX~14.89
HL~95~93~I
LIN~005~IN~UNV10272~UP~087547102725
SN1~~5~BX~~5~BX~~AC
SLN~005~~I~5~BX~14.48
HL~96~93~I
LIN~006~IN~UNV10303~UP~087547103036
SN1~~20~BX~~20~BX~~AC
SLN~006~~I~20~BX~14.99
HL~97~93~I
LIN~007~IN~UNV10318~UP~087547103180
SN1~~30~BX~~30~BX~~AC
SLN~007~~I~30~BX~17.14
HL~98~93~I
LIN~022~IN~UNV13110~UP~087547131107
SN1~~10~BX~~10~BX~~AC
SLN~022~~I~10~BX~8.31
HL~99~93~I
LIN~025~IN~UNV13510~UP~087547135105
SN1~~10~BX~~10~BX~~AC
SLN~025~~I~10~BX~9.18
HL~100~93~I
LIN~027~IN~UNV13526~UP~087547135266
SN1~~10~BX~~10~BX~~AC
SLN~027~~I~10~BX~14.94
HL~101~93~I
LIN~031~IN~UNV14116~UP~087547141168
SN1~~20~BX~~20~BX~~AC
SLN~031~~I~20~BX~6.22
HL~102~93~I
LIN~032~IN~UNV14118~UP~087547141182
SN1~~10~BX~~10~BX~~AC
SLN~032~~I~10~BX~6.22
HL~103~93~I
LIN~033~IN~UNV14142~UP~087547141427
SN1~~16~BX~~16~BX~~AC
SLN~033~~I~16~BX~9.33
HL~104~93~I
LIN~037~IN~UNV16122~UP~087547161227
SN1~~5~BX~~5~BX~~AC
SLN~037~~I~5~BX~11.71
HL~105~93~I
LIN~038~IN~UNV16140~UP~087547161401
SN1~~10~BX~~10~BX~~AC
SLN~038~~I~10~BX~12.91
HL~106~93~I
LIN~043~IN~UNV16466~UP~087547164662
SN1~~10~BX~~10~BX~~AC
SLN~043~~I~10~BX~5.68
HL~107~93~I
LIN~044~IN~UNV24113~UP~087547241134
SN1~~20~BX~~20~BX~~AC
SLN~044~~I~20~BX~6.53
HL~108~93~I
LIN~045~IN~UNV24213~UP~087547242131
SN1~~5~BX~~5~BX~~AC
SLN~045~~I~5~BX~8.16
HL~109~70~T
MAN~GM~00100875471016086815
PAL~6~~~44
HL~110~109~I
LIN~015~IN~UNV12110~UP~087547121108
SN1~~50~BX~~50~BX~~AC
SLN~015~~I~50~BX~6.22
HL~111~109~I
LIN~019~IN~UNV12302~UP~087547123027
SN1~~10~BX~~10~BX~~AC
SLN~019~~I~10~BX~8.59
HL~112~109~I
LIN~020~IN~UNV12303~UP~087547123034
SN1~~30~BX~~30~BX~~AC
SLN~020~~I~30~BX~8.59
HL~113~109~I
LIN~024~IN~UNV13420~UP~087547134207
SN1~~40~BX~~55~BX~~AC
SLN~024~~I~40~BX~11.48
HL~114~109~I
LIN~035~IN~UNV15121~UP~087547151211
SN1~~15~BX~~15~BX~~AC
SLN~035~~I~15~BX~8.12
HL~115~109~I
LIN~039~IN~UNV16150~UP~087547161500
SN1~~15~BX~~15~BX~~AC
SLN~039~~I~15~BX~14.48
HL~116~109~I
LIN~047~IN~UNV57115~UP~087547571156
SN1~~10~BX~~10~BX~~AC
SLN~047~~I~10~BX~7.18
HL~117~109~I
LIN~049~IN~UNV57122~UP~087547571224
SN1~~10~BX~~10~BX~~AC
SLN~049~~I~10~BX~10.18
HL~118~109~I
LIN~050~IN~UNV57123~UP~087547571231
SN1~~40~BX~~40~BX~~AC
SLN~050~~I~40~BX~10.18
HL~119~70~T
MAN~GM~00100875471016086822
PAL~6~~~7
HL~120~119~I
LIN~008~IN~UNV10325~UP~087547103258
SN1~~5~BX~~5~BX~~AC
SLN~008~~I~5~BX~24.28
HL~121~119~I
LIN~040~IN~UNV16162~UP~087547161623
SN1~~15~BX~~15~BX~~AC
SLN~040~~I~15~BX~12.8
HL~122~119~I
LIN~041~IN~UNV16164~UP~087547161647
SN1~~15~BX~~15~BX~~AC
SLN~041~~I~15~BX~12.8
HL~123~70~T
MAN~GM~00100875471016087904
PAL~6~~~20
HL~124~123~I
LIN~036~IN~UNV15363~UP~087547153635
SN1~~100~BX~~200~BX~~AC
SLN~036~~I~100~BX~8.52
HL~125~70~T
MAN~GM~00100875471016087942
PAL~6~~~20
HL~126~125~I
LIN~036~IN~UNV15363~UP~087547153635
SN1~~100~BX~~200~BX~~AC
SLN~036~~I~100~BX~8.52
HL~127~70~T
MAN~GM~00100875471016088017
PAL~6~~~48
HL~128~127~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~129~70~T
MAN~GM~00100875471016088031
PAL~6~~~48
HL~130~129~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~131~70~T
MAN~GM~00100875471016088123
PAL~6~~~48
HL~132~131~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~133~70~T
MAN~GM~00100875471016088154
PAL~6~~~48
HL~134~133~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~135~70~T
MAN~GM~00100875471016088260
PAL~6~~~48
HL~136~135~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~137~70~T
MAN~GM~00100875471016088284
PAL~6~~~48
HL~138~137~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~139~70~T
MAN~GM~00100875471016088314
PAL~6~~~48
HL~140~139~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~141~1~O
PRF~0108320
REF~AI~019166900001
HL~142~141~T
MAN~GM~00100421671016086577
PAL~6~~~6
HL~143~142~I
LIN~001~IN~OFF82007~UP~042167820077
SN1~~5~BX~~5~BX~~AC
SLN~001~~I~5~BX~20.8
HL~144~142~I
LIN~002~IN~OFF82020~UP~042167820206
SN1~~40~BX~~40~BX~~AC
SLN~002~~I~40~BX~5.15
HL~145~142~I
LIN~003~IN~OFF85343~UP~042167853433
SN1~~4~BX~~4~BX~~AC
SLN~003~~I~4~BX~16.9
CTT~145
SE~556~214260004
GE~6~900021426
IEA~1~000000700
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.