Problem with reading overflow entities

Author: anne_vw@telenet.be (anne_vw)

Hi,

We have a entity with 8 string fields interface: C*VI\^28 
This results in an entity-record and three segments in the overflow-entity. 
Sometimes when we read data only one segment is read.
 
We select our record.  Go to second screen with detail information.  Go to third screen to print data.  Return automaticly to selection screen.  Go back to detail screen.  Not all data is read.

Message frame when read is ok (length from datasegment 1:Length fetched: 270:
Message frame when read is ok (length from datasegment 1:Length fetched: 268:

Does anyone recognise this problem?
 

I added the message frame where you can see clearly the difference in length fetched.

Thanks
Anne

 

Message frame when read is ok (lenght from datasegment 1:Length fetched: 270:

 

Use Index is 1 is (120101120850001)
TNR_AANMELDING is (12010112085)
SEGM is (0001)
/*fast overflow fetch : request all overflow rows from Sybase */
execute opaspmed_OV_FET
@where1 = '12010112085', @where2 = '0001'

-> Length fetched: 270 .
Input operation; datalength = 270
    field  -> PASPMED          pos 0 len 0 0 type G0 G  pack 90 scalfmt 1 csfmt 0 dbfmt 0 index 0
    field  -> TNR_AANMELDING   pos 0 len 11 11 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 1
    field  -> SEGM             pos 11 len 4 4 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 1
    field  -> DATA             pos 15 len 255 255 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 0
0000: 31 32 30 31 30 31 31 32 30 38 35 30 30 30 31 72: 120101120850001r
0016: 69 6D E9 27 73 20 61 6E 61 66 72 61 6E 69 6C 20: im?'s anafranil
0032: 72 65 74 61 72 64 20 37 35 20 6D 67 20 67 65 6E: retard 75 mg gen
0048: 6F 6D 65 6E 20 6F 6E 67 65 76 65 65 72 20 32 20: omen ongeveer 2
0064: 75 75 72 20 76 6F 6F 72 20 5A 48 20 6F 70 6E 61: uur voor ZH opna
0080: 6D 65 2C 20 7A 6F 75 20 67 65 65 6E 20 61 6C 70: me, zou geen alp
0096: 72 61 7A 6F 6C 61 6D 20 68 65 62 62 65 6E 20 69: razolam hebben i
0112: 6E 67 65 6E 6F 6D 65 6E 2E 0D 0A 44 65 20 6C 61: ngenomen.??De la
0128: 61 74 73 74 65 20 32 20 64 61 67 65 6E 20 68 65: atste 2 dagen he
0144: 65 66 74 20 70 61 74 69 EB 6E 74 20 6E 69 65 74: eft pati?nt niet
0160: 20 6D 65 65 72 20 67 65 67 65 74 65 6E 2E 1C 6D:  meer gegeten.?m
0176: 69 63 72 6F 67 65 6E 6F 6E 20 0D 0A 61 6C 70 72: icrogenon ??alpr
0192: 61 7A 6F 6C 61 6D 20 31 6D 67 20 31 2F 64 0D 0A: azolam 1mg 1/d??
0208: 61 6E 61 66 72 61 6E 69 6C 20 72 65 74 61 72 64: anafranil retard
0224: 20 37 35 6D 67 20 32 2F 64 1C 41 61 6E 6B 6F 6D:  75mg 2/d?Aankom
0240: 73 74 20 7A 69 65 6B 65 6E 77 61 67 65 6E 3A 20: st ziekenwagen:
0256: 0D 0A 42 44 3A 20 31 31 33 2F 30 30 30 32 00 00: ??BD: 113/0002..
I/O function: F, mode: 0, on file/table: OPASPMED index: 1 =
 Where ((TNR_AANMELDING = '12010112085') And (SEGM = '0002'))
Use Index is 1 is (120101120850002)
TNR_AANMELDING is (12010112085)
SEGM is (0002) -> len 270 .
Input operation; datalength = 270
    field  -> PASPMED          pos 0 len 0 0 type G0 G  pack 90 scalfmt 1 csfmt 0 dbfmt 0 index 0
    field  -> TNR_AANMELDING   pos 0 len 11 11 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 1
    field  -> SEGM             pos 11 len 4 4 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 1
    field  -> DATA             pos 15 len 255 255 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 0
0000: 31 32 30 31 30 31 31 32 30 38 35 30 30 30 32 36: 1201011208500026
0016: 33 2C 20 70 6F 6C 73 3A 20 38 32 2C 20 73 61 74: 3, pols: 82, sat
0032: 3A 20 39 38 0D 0A 4F 70 20 73 70 6F 65 64 3A 20: : 98??Op spoed:
0048: 0D 0A 42 44 3A 20 31 33 30 2F 36 37 2C 20 70 6F: ??BD: 130/67, po
0064: 6C 73 3A 20 37 34 2C 20 73 61 74 3A 20 39 35 0D: ls: 74, sat: 95?
0080: 0A 6C 6F 6E 67 3A 20 62 69 6C 61 74 65 72 61 61: ?long: bilateraa
0096: 6C 20 56 41 47 0D 0A 63 6F 72 3A 20 53 31 53 32: l VAG??cor: S1S2
0112: 2C 20 67 65 65 6E 20 73 6F 75 66 66 6C 65 73 0D: , geen souffles?
0128: 0A 61 62 64 3A 20 6E 6F 72 6D 61 6C 65 20 70 65: ?abd: normale pe
0144: 72 69 73 74 61 6C 74 69 65 6B 2C 20 73 6F 65 70: ristaltiek, soep
0160: 65 6C 0D 0A 50 61 74 69 EB 6E 74 20 68 65 65 66: el??Pati?nt heef
0176: 74 20 68 65 74 20 6D 6F 65 69 6C 69 6A 6B 20 6F: t het moeilijk o
0192: 6D 20 64 75 69 64 65 6C 69 6A 6B 20 65 6E 20 76: m duidelijk en v
0208: 65 72 73 74 61 61 6E 62 61 61 72 20 74 65 20 73: erstaanbaar te s
0224: 70 72 65 6B 65 6E 2E 0D 0A 4E 65 75 72 6F 6C 6F: preken.??Neurolo
0240: 67 69 73 63 68 20 69 6E 74 61 6B 74 1C 41 75 74: gisch intakt?Aut
0256: 6F 2D 69 6E 74 6F 78 69 63 61 30 30 30 33 00 00: o-intoxica0003..
I/O function: F, mode: 0, on file/table: OPASPMED index: 1 =
 Where ((TNR_AANMELDING = '12010112085') And (SEGM = '0003'))
Use Index is 1 is (120101120850003)
TNR_AANMELDING is (12010112085)
SEGM is (0003) -> len 253 .
Input operation; datalength = 253
    field  -> PASPMED          pos 0 len 0 0 type G0 G  pack 90 scalfmt 1 csfmt 0 dbfmt 0 index 0
    field  -> TNR_AANMELDING   pos 0 len 11 11 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 1
    field  -> SEGM             pos 11 len 4 4 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 1
    field  -> DATA             pos 15 len 255 238 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 0
0000: 31 32 30 31 30 31 31 32 30 38 35 30 30 30 33 74: 120101120850003t
0016: 69 65 20 54 43 41 1C 4F 70 20 73 70 6F 65 64 3A: ie TCA?Op spoed:
0032: 0D 0A 2D 20 6D 61 61 67 73 70 6F 65 6C 69 6E 67: ??- maagspoeling
0048: 20 6D 65 74 20 61 63 74 69 65 76 65 20 6B 6F 6F:  met actieve koo
0064: 6C 0D 0A 2D 20 6E 61 74 72 69 75 6D 62 69 63 61: l??- natriumbica
0080: 72 62 6F 6E 61 61 74 20 38 2E 34 25 1C 1C 4F 70: rbonaat 8.4%??Op
0096: 6E 61 6D 65 20 69 6E 7A 6F 20 32 20 74 65 72 20: name inzo 2 ter
0112: 6D 6F 6E 69 74 6F 72 69 6E 67 1C 4C 61 62 6F 3A: monitoring?Labo:
0128: 0D 0A 54 6F 78 69 63 6F 73 63 72 65 65 6E 69 6E: ??Toxicoscreenin
0144: 67 3A 20 0D 0A 52 78 20 54 68 6F 72 61 78 3A 20: g: ??Rx Thorax:
0160: 67 65 65 6E 20 64 75 69 64 65 6C 69 6A 6B 65 20: geen duidelijke
0176: 69 6E 66 69 6C 74 72 61 74 65 6E 20 74 65 20 77: infiltraten te w
0192: 65 65 72 68 6F 75 64 65 6E 0D 0A 45 4B 47 3A 20: eerhouden??EKG:
0208: 73 69 6E 75 73 61 61 6C 2C 20 37 37 2F 6D 69 6E: sinusaal, 77/min
0224: 2C 20 67 65 65 6E 20 51 52 53 20 6E 6F 63 68 20: , geen QRS noch
0240: 51 54 20 76 65 72 6C 65 6E 67 69 6E 67 00 00 00: QT verlenging...
End <_read> ent PASPMED, occ 1, status 0
Select-cache Fetch from  PASPMED
ERROR=-1101·;MNEM=<UPROCERR_FIELD>·;DESCRIPTION=Field not valid·;COMPONENT=PASPE02G·;PROCNAME=154\READ·;TRIGGER=READ·;LINE=1
Object size=0000012 sig/paspe02g*.sig
Object Lookup: C:\Uniface\uf93\zis\workspace\objecten\ZIS_1078.uar
Object size=0000391 sig/paspe02g.sig
ERROR=-1101·;MNEM=<UPROCERR_FIELD>·;DESCRIPTION=Field not valid·;COMPONENT=PASPE02G·;PROCNAME=154\READ·;TRIGGER=READ·;LINE=2"

Message frame when read is not ok (length from datasegment 1:Length fetched: 268:

TNR_AANMELDING is (12010112085)
SEGM is (0001)
/*fast overflow fetch : request all overflow rows from Sybase */
execute opaspmed_OV_FET
@where1 = '12010112085', @where2 = '0001'

-> Length fetched: 268 .
Input operation; datalength = 268
    field  -> PASPMED          pos 0 len 0 0 type G0 G  pack 90 scalfmt 1 csfmt 0 dbfmt 0 index 0
    field  -> TNR_AANMELDING   pos 0 len 11 11 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 1
    field  -> SEGM             pos 11 len 4 4 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 1
    field  -> DATA             pos 15 len 255 253 type S1 S  pack 0 scalfmt 0 csfmt 0 dbfmt 0 index 0
0000: 31 32 30 31 30 31 31 32 30 38 35 30 30 30 31 72: 120101120850001r
0016: 69 6D E9 27 73 20 61 6E 61 66 72 61 6E 69 6C 20: im?'s anafranil
0032: 72 65 74 61 72 64 20 37 35 20 6D 67 20 67 65 6E: retard 75 mg gen
0048: 6F 6D 65 6E 20 6F 6E 67 65 76 65 65 72 20 32 20: omen ongeveer 2
0064: 75 75 72 20 76 6F 6F 72 20 5A 48 20 6F 70 6E 61: uur voor ZH opna
0080: 6D 65 2C 20 7A 6F 75 20 67 65 65 6E 20 61 6C 70: me, zou geen alp
0096: 72 61 7A 6F 6C 61 6D 20 68 65 62 62 65 6E 20 69: razolam hebben i
0112: 6E 67 65 6E 6F 6D 65 6E 2E 0D 0A 44 65 20 6C 61: ngenomen.??De la
0128: 61 74 73 74 65 20 32 20 64 61 67 65 6E 20 68 65: atste 2 dagen he
0144: 65 66 74 20 70 61 74 69 EB 6E 74 20 6E 69 65 74: eft pati?nt niet
0160: 20 6D 65 65 72 20 67 65 67 65 74 65 6E 2E 1C 6D:  meer gegeten.?m
0176: 69 63 72 6F 67 65 6E 6F 6E 20 0D 0A 61 6C 70 72: icrogenon ??alpr
0192: 61 7A 6F 6C 61 6D 20 31 6D 67 20 31 2F 64 0D 0A: azolam 1mg 1/d??
0208: 61 6E 61 66 72 61 6E 69 6C 20 72 65 74 61 72 64: anafranil retard
0224: 20 37 35 6D 67 20 32 2F 64 1C 41 61 6E 6B 6F 6D:  75mg 2/d?Aankom
0240: 73 74 20 7A 69 65 6B 65 6E 77 61 67 65 6E 3A 20: st ziekenwagen:
0256: 0D 0A 42 44 3A 20 31 31 33 2F 30 30 00 00 00 00: ??BD: 113/00....
End <_read> ent PASPMED, occ 1, status 0
Select-cache Fetch from  PASPMED
ERROR=-1101·;MNEM=<UPROCERR_FIELD>·;DESCRIPTION=Field not valid·;COMPONENT=PASPE02G·;PROCNAME=154\READ·;TRIGGER=READ·;LINE=1
Object size=0000012 sig/paspe02g*.sig
Object Lookup: C:\Uniface\uf93\zis\workspace\objecten\ZIS_1078.uar
Object size=0000391 sig/paspe02g.sig
ERROR=-1101·;MNEM=<UPROCERR_FIELD>·;DESCRIPTION=Field not valid·;COMPONENT=PASPE02G·;PROCNAME=154\READ·;TRIGGER=READ·;LINE=2"
 

This page has no comments.