Conference orarep::nomahs::dec_data_distributor

203.0. "Help with assert failure, best_path" by TINCUP::AGUE (http://www.usa.net/~ague) Thu Apr 04 1996 11:13

    Hopefully this is the right conference.
    
    I'm getting this DBI failure message:
    
    '%RDB-F-SYS_REQUEST, error from system services request..-DBI-F-INTERR,
    There is an internal software error - please submit an SPR..
    -DBI-I-ASSERT_FAILURE, Assertion "!(best_path . copath_l_accum_cost  >= 
    MAX_PATH_COST)" failed..
    -DBI-I-AT_LINE, .in DBI$COD
    
    When I attempt the following embedded Pascal/SQL code:
    
       258: EXEC SQL
       259:   INSERT INTO tbl_svc_actn
       260:     (svc_actvty_tbl_id,  svc_actn_class,  svc_actn,     rspbl_segmt,
       261:      svc_actn_status,    actl_start_time, actl_end_time,creatn_date)
       262:   VALUES
       263:     (:svc_actvty_tbl_id, 'CORS',          'RTOS',       'ONST',
       264:      'OPEN',             :ct,             :ct,           :ct);
                                                                    

    (continued, I inadvertently hit ^z when I wanted ^h in the last
    message.)
    
    More information that may or may not help.
    
    Most of the columns in the code fragment are text, the first is an
    integer, and the last three are Date.  For the date columns, my ct
    variable is a string variable in which I've loaded a VMS formatted date
    ('14-APR-1996 08:03:59.11') using $asctim.
    
    I'm presuming that somewhere along the line between my SQL running on a
    VMS platform, DBI Server running on a VMS platform, DBI Client running
    on a PC/NT and the SQL database running on Alpha/UNIX, the text form of
    the date gets converted to the proper Alpha internal format.
    
    I really have two questions:
    
    1) what's causing the assertion failure?
    
    2) is this how dates should be handled?
    
    Thanks,
    -- Jim

    You have the wrong notes conference.  What you want is
    
    	BROKE::DBINTEGRATOR_PUBLIC.NOTE