Conference orarep::nomahs::dectrace_v20

446.0. "Formatting Errors" by M5::BLEHLBAC (RDB: 34% better than real life) Thu Mar 06 1997 15:22

Hi,

  Here is a log with a failing process.

  Any idea what is causing the error??

  I will be happy to provide any additional information.
 
  I am not that familiar with trace so perhaps there is an obvious
solution.

                               Thanks,

                                  Barry Lehlbach
                                  WWCS - Rdb Team

  
----------------------------------

Trace version 2.2
Rdb version 6.1
VMS Version 6.1 [AXP]

The log file from the failing process:

(12:09:03) $ set process/priv=all
(12:09:03) $ set verify
(12:09:03) $ set noon
(12:09:03)
(12:09:03) $ collect format dba_root:[trace]rdb_data.dat                -
                         dba_root:[trace]rdb_formatted_data.rdb -
                   /rdbvms_optimization=(allocation=10000               -
                                        ,num_buffers=1000               -
                                        ,buffer_size=12                 -
                                        ,nojournal                      )
%EPC-I-FMT_RDB_CREATE, Creating database
DBA_ROOT:[TRACE]RDB_FORMATTED_DATA.RDB
%EPC-S-FMT_RDB_SUCCESS, Successfully created database
%EPC-I-FMT_DCF_BEGIN, Formatting data file DBA_ROOT:[TRACE]RDB_DATA.DAT
%EPC-E-FMT_DCF_FAILURE, Failed formatting at block 295 of file
DBA_ROOT:[TRACE]RDB_DATA.DAT
%EPC-E-FMT_DCF_CORRUPT, Data file is corrupted
%EPC-E-FMT_DCF_ITEPOS, Found items with same position number
%EPC-E-FMT_FAILURE, Formatting failed
%EPC-E-OPFAIL, Operation failed

The selection for this collection is:

Trace> show selection rdb_selection /format=full
6-MAR-1997 13:21         Facility Selection Information              Page 1
                                                               Oracle Trace
V2.2
 
   Selection:           RDB_SELECTION
   Comment:
   Created By:          VJJALBERT
 
   Facility:            *
   Version:             (latest)
   Collection Class:    ALL
Trace>

----------------------------------

Please get the output from
a coll sho def /format=full rdbvms.

Thanks
George

>>Please get the output from
>>a coll sho def /format=full rdbvms.

>>Thanks
>>George

Hi George,

  The output came to a 280 page report.

  They have multiple facilities with acms servers.

  He did facility=all.

  Do you really want all this information, or is there a way to pare
it down??

                      Thanks,  Barry

I only wanted RDB

coll sho def rdbvms /version=  /for=full

Specify the version string of the version he collected for...

What I'm trying to find out is if the facility definition in the
administration database is toast.  You should never get a duplicate item
error like the one he encountered.

The sho def command will print out all the items etc for each event and
show us that info.

The data collected by the customer in that .dat file is unsalvagable.

They could just try running @epc$examples:epc$insert.com and re-insert
the rdb facility definition in question.  

Then try another collection and see if it formats.

Maybe there was a blip during the initial facility definition insert.

I have NEVER seen this error in the 8+ years of Trace's existance.  The
code that handles the extraction and insertion of the facility definition
stuff has been pretty solid...


George