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

Conference ilbbak::ibi_focus

Title:FOCUS, from INFORMATION BUILDERS
Moderator:ZAYIUS::BROUILLETTE
Created:Thu Feb 19 1987
Last Modified:Mon May 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:615
Total number of notes:1779

609.0. "RMS error in a JOIN" by JURA::COISSARD () Fri Jun 23 1995 10:36

    I have a strange error when joining two RMS files. The first file is
    quite big (800000 records) and the second has 100000 records.
    During the join, a file FOCSORT.FTM is created (523000 blocks).
    The error is happening when FOCUS tries to read FOCSORT.FTM to create
    the final file. I get the following :
    
    %RMS-F-UBF, invalid user buffer
    
     ERROR AT OR NEAR LINE  197 IN PROCEDURE SPORT$$D_EXE:ACCR_R_R.FEX
    
    (FOC198) FATAL ERROR IN DATABASE I/O. FOCUS TERMINATING.   ERROR
    READING  FOC$TMP:FOCSORT.FTM ,PAGE      1 ,CODE=01000000R
    %NONAME-W-NOMSG, Message number 00000000
    
    The program was running quite well until now, and no modification was
    made except it runs now under DECStep 6.
    
    Can somebody help me ?
    Dominique.
T.RTitleUserPersonal
Name		DateLines
609.1Need more info..AIMHI::CLARKThu Jul 06 1995 16:5714
First of all- I wasn't aware that you could JOIN two RMS files 
unless one was indexed.   Is one ??

Secondly, depending upon the record size, you might be maxing out 
your internal buffer.  FOCUS doesn't handle LRGE files well.  

Has this identical procedure been used before successfully ?

If so, has the record count increased in this run vs a previous working one?

Thirdly, do you have enough space in the directory where the focsort is
being created ? Quota ?

Good luck
609.2SolvedJURA::COISSARDFri Jul 07 1995 09:1311
    I've just solved my problem. The report has been changed to select the 
    earlier it can the datas it just needs. Now it works because the files
    are quite little.
    
    But, to answer your questions, FOCUS can Join two RMS files but the 
    second one has to be sorted by the join key.
    I think that the problem was coming from the size of the files and/or the
    record size, because there was enough place on the disk.
    
    Thanks for all,
    Dominique.