Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Another Major Bug - COM+ Crash In DBC SP
Message
De
23/12/2004 14:44:48
 
 
À
23/12/2004 11:48:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00971709
Message ID:
00971892
Vues:
24
Aleksey, please read below.

>>The memo file was and is not corrupt.
>
>And what makes you think that? The fact that VFP8 doesn't complain? This is not a good test for MEMO file integrity.

Amoung other things, I used a version of the code below which comes straight from the VFP9 Help docs concerning how to check for memo field corruption.
TRY
  USE myTable EXCLUSIVE NOUPDATE 
  SCAN
    SCATTER MEMO MEMVAR
  ENDSCAN
CATCH TO loError
  IF loError.ErrorNo=41
    * handle error here
  ENDIF
ENDTRY
USE IN myTable
>> The error occurs only if the table is opened exclusive.
>
>So? VFP uses MEMO files a little bit differently when it is shared, might as well avoid accessing the corrupted spot.

I am not avoiding anything. I'm passing you information as I am trying to get to the bottom of this.

>Have you tried to recreate the MEMO file the way I've suggested?

Yes. I did all of that before you suggested it.

I am also investigating another aspect of the problem. The error occurs during a call to a COM Server only AFTER another call to the same COM Server which does an update via ApplyDiffGram. It appears that there is a commitment delay that didn't exist before.

Here is the error that was trapped:
Source :  UPDATE bizsystem!tb_fields SET ikey_fld=xmltable_7eb45317_86a2_4a47_8984_638282469348_.ikey_fld,ikey_vws=xmltable_7eb45317_86a2_4a47_8984_638282469348_.ikey_vws,ikey_tlb=xmltable_7eb45317_86a2_4a47_8984_638282469348_.ikey_tlb,cfield=xmltable_7eb45317_86a2_4a47_8984_638282469348_.cfield,chelptitle=xmltable_7eb45317_86a2_4a47_8984_638282469348_.chelptitle,cupdatename=xmltable_7eb45317_86a2_4a47_8984_638282469348_.cupdatename,ctype=xmltable_7eb45317_86a2_4a47_8984_638282469348_.ctype,iwidth=xmltable_7eb45317_86a2_4a47_8984_638282469348_.iwidth,idecimals=xmltable_7eb45317_86a2_4a47_8984_638282469348_.idecimals,ibordercolor=xmltable_7eb45317_86a2_4a47_8984_638282469348_.ibordercolor,linputrequired=xmltable_7eb45317_86a2_4a47_8984_638282469348_.linputrequired,lallownulls=xmltable_7eb45317_86a2_4a47_8984_638282469348_.lallownulls,lkeyfield=xmltable_7eb45317_86a2_4a47_8984_638282469348_.lkeyfield,lupdatable=xmltable_7eb45317_86a2_4a47_8984_638282469348_.lupdatable,mdefaultvalue=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mdefaultvalue,mcaption=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mcaption,mvalidate_onclient=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mvalidate_onclient,mvalidate_onserver=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mvalidate_onserver,mvalidatetext=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mvalidatetext,mhelpcontent=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mhelpcontent,mcomment=xmltable_7eb45317_86a2_4a47_8984_638282469348_.mcomment WHERE ikey_fld=OLDVAL('ikey_fld','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND ikey_vws=OLDVAL('ikey_vws','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND ikey_tlb=OLDVAL('ikey_tlb','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND cfield=OLDVAL('cfield','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND chelptitle=OLDVAL('chelptitle','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND cupdatename=OLDVAL('cupdatename','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND ctype=OLDVAL('ctype','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND iwidth=OLDVAL('iwidth','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND idecimals=OLDVAL('idecimals','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND ibordercolor=OLDVAL('ibordercolor','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND linputrequired=OLDVAL('linputrequired','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND lallownulls=OLDVAL('lallownulls','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND lkeyfield=OLDVAL('lkeyfield','xmltable_7eb45317_86a2_4a47_8984_638282469348_') AND lupdatable=OLDVAL('lupdatable','xmltable_7eb45317_86a2_4a47_8984_638282469348_')

Cause  :  Memo file c:\program files\microsoft visual foxpro 9\projects\appserver\data\tb_views.FPT is missing or is invalid.
- Jeff
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform