[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference rocks::dec_edi

Title:DEC/EDI
Notice:DEC/EDI V2.1 - see note 2002
Moderator:METSYS::BABER
Created:Wed Jun 06 1990
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:3150
Total number of notes:13466

3135.0. "More problems since upgrade to 2.1d" by JOBURG::BERETTA () Wed May 21 1997 17:51

    Hi,
    
    Seems like more problems with 2.1d, we have a document stuck in the
    state "identifying" and the decedi$schedule process keeps dying.
    
    %DECEDI-I-DSTERMINATED, process DECEDI$SCHEDULE terminated/disconnected
    -SYSTEM-F-ACCVIO, access violation, reason mask=38, virtual
    address=20202020, PC=20202020, PS=20202020
    -DECEDI-I-CONDLOGGED, condition logged by DECEDI$DS on node EDIIT1:: at
    20-MAY-1997 15:39:53.77
    
    %DECEDI-I-DSTERMINATED, process DECEDI$SCHEDULE terminated/disconnected
    -SYSTEM-F-ACCVIO, access violation, reason mask=A0, virtual
    address=20202020, PC=20202020, PS=20202020
    -DECEDI-I-CONDLOGGED, condition logged by DECEDI$DS on node EDIIT1:: at
    21-MAY-1997 11:48:56.11
    
    
    
    
    +-+-+-+-+-+-+-+                     DEC/EDI                      
    NODE:EDIIT1::
    |d|i|g|i|t|a|l|      Full Transmission File Details - PEDI         
    21-May-1997
    +-+-+-+-+-+-+-+-----------------------------------------------------------------
    
     Transmission File                                    Status
     20MAY199715541451_AKX400                             IDENTIFYING          
    
     Creation Date        : 20-MAY-1997 15:54                                      
     Last Modified Date   : 21-MAY-1997 11:48                                      
     Storage Directory    : DECEDI$STORE_3:                                        
     Connection Id        : AKX400               Character Count      : 24         
     Priority             : NORMAL               Retry Count          : 0          
     Syntax               : SPLIT                Direction            :
    INBOUND    
     Partner ID/Reference :                                                        
                                                                                   
     Obsoleted Messages   : NO                   Related Messages     : NO         
     Expiry Date/Time     :                                                        
     EDI Message ID       :                                                        
     X.400 MTS ID         : EFE3C7F411D0D11700081180                               
     Neg. Notif. Reason   :                                                        
     Notification Sent    : NO                                                     
    --------------------------------------------------------------------------------
    
    
    
     Transmission File                                    Status
     20MAY199715541451_AKX400                             IDENTIFYING          
    
     Tracking Date       Tracking Status                                           
                                                                                   
     20-MAY-1997 15:54   Transmission file is being received from trading
    partner  
     20-MAY-1997 15:54   Transmission file received from trading partner           
     21-MAY-1997 11:48   Transmission file standard is being identified            
                                                                                   
                                                                                   
                                                                                   
    The transmission file has been stuck here since yesterday.
    
    Regards
    
    Peter.
    
T.RTitleUserPersonal
Name
DateLines
3135.1METSYS::THOMPSONWed May 21 1997 20:117
Is it just this one transmission?

SSB or patch image for the Comms Controller?


Mark
3135.2Patch Image - all documents stuckJOBURG::BERETTAThu May 22 1997 13:5437
    Hello Mark,                                   
    
    Based on the mail you sent out some time ago, I copied over the 2.1d
    images from the directory you mentioned in the mail. I manually copied
    them all to their respective places and restarted EDI. 
    
    EDIENG""::USER2:[DECEDI_V21D_PATCHES]
    
    What we have is the following:
    
    EDI> list trans/sin=20-may
    
     20MAY199715392987_AKX400                              RECEIVED             
     20MAY199715541451_AKX400                              IDENTIFYING          
     21MAY199712321342_EDGCYB                              AWAIT_TRANSMISSION   
     21MAY199712321470_ESKCYB                              AWAIT_TRANSMISSION   
     21MAY199712321521_NEDCYB                              AWAIT_TRANSMISSION   
     21MAY199712321599_SANCYB                              AWAIT_TRANSMISSION   
     21MAY199712321661_SARCYB                              AWAIT_TRANSMISSION   
     21MAY199712321716_SEN1CB                              AWAIT_TRANSMISSION   
     21MAY199712321766_SEN2CB                              AWAIT_TRANSMISSION   
     21MAY199712321823_TLKCYB                              AWAIT_TRANSMISSION   
     21MAY199712321874_TRA2CB                              AWAIT_TRANSMISSION   
    
    
    Now we suspect that the document stuck in identifying state is causing
    the problem. The actual document itself is just some plain text, coming
    in via bypass. 
    
    Have you got some sql statements for me to delete to delete this from
    EDI? One cannot cancel or do anything with it. Stoping and starting
    DEC/EDI does not help. The schedule process crashes immediately.
    
    Regards
    
    Peter
    
3135.3METSYS::THOMPSONThu May 22 1997 18:4010
$ sql :== $sql$
$sql
SQL> attach 'filename decedi$audit_db';
SQL> delete from clf_table where trnsfle_s='<trans-file-name>';
SQL> delete from chf_table where trnsfle_s='< ditto >';
SQL> commit;
SQL>exit
$

3135.4Thanks for the sqlJOBURG::BERETTAThu May 22 1997 19:116
    Thanks for the sql statements,
    
    I had to roll back to the 2.1c pedi image to get the rest of the
    "awaiting_transmission" files to get sent.
    
    Peter.