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

Conference orarep::nomahs::dectrace_v20

Title:DECtrace V2.0 and All-in-1 Perf Rpts conf.
Notice:Kits+Doc, 2 | Patches, 3
Moderator:OMYGOD::LAVASH
Created:Mon Apr 26 1993
Last Modified:Mon Jun 02 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:467
Total number of notes:2058

314.0. "EPC$1_221_REQUEST_BLR table not found on import" by KERNEL::WILESL (Louise Wiles, Oracle Rdb Support) Mon Apr 24 1995 06:24

T.RTitleUserPersonal
Name
DateLines
314.1May have a bad definition fileOOTOOL::CRAIGTue Apr 25 1995 15:4914
314.2no EPC$1_221_REQUEST_BLRKERNEL::WILESLLouise Wiles, Oracle Rdb SupportWed Apr 26 1995 06:115
314.3Try to replace this file from the Rdb kitOOTOOL::CRAIGTue May 02 1995 15:4430
314.4Any reasons why?KERNEL::WILESLLouise Wiles, Oracle Rdb SupportTue May 09 1995 13:178
314.5What's the exact error message they were receiving?OOTOOL::CRAIGFri May 12 1995 10:415
314.6KERNEL::WILESLLouise Wiles, Oracle Rdb SupportMon May 15 1995 05:4312
314.7No joyKERNEL::WILESLLouise Wiles, Oracle Rdb SupportMon May 15 1995 06:067
314.8if it's still not working send us the .dat fileDTRACY::LAVASHSame as it ever was...Mon May 15 1995 11:1010
314.9KERNEL::WILESLLouise Wiles, Oracle Rdb SupportMon May 15 1995 12:4912
314.10Could not copy file - remote node unknownOOTOOL::CRAIGMon May 15 1995 13:4320
314.11KERNEL::WILESLLouise Wiles, Oracle Rdb SupportTue May 16 1995 05:026
314.12SPR receivedOOTOOL::CRAIGTue May 16 1995 14:067
314.13SPR Number is UVO103055 / CFS.28013OOTOOL::CRAIGTue May 16 1995 14:081
314.14Quick work somewhereKERNEL::WILESLLouise Wiles, Oracle Rdb SupportTue May 16 1995 14:103
314.15What ever happened to this???M5::BLITTINFri Feb 14 1997 13:542
    
    What ever happened to this?  
314.16The customer was able to resolve the issue by redefining the class in his selectionOOTOOL::CRAIGMon Feb 17 1997 10:4284
	Hi,

	Sorry that I had to rush out Friday when you called.

	This is the error that this customer was seeing:

   Error: The DECTrace database <filename> is not a valid RDB collection.
           The following tables were not found :

           EPC$1_221_REQUEST_BLR
  
	What version of Rdb, Trace, and Expert is the customer running?

	This problem had to do with the customers selection
	being defined as using a CLASS other than ALL or 
	RDBEXPERT.

        When DECTrace sets up the repostitory that it uses to capture the
        data from the Collection it creates the Tables based upon what the
        customer has defined. If something in the customers
        definition is not set up properly the table will not be
        created during the collection.
 
	Have the customer send a log (set host 0 )of what they are 
	seeing and the exact error along with the information on
	their collection, selection, facility definitions, etc.

	Some information that is helpful in determining the problem
	would be to have the customer provide the following information:

	SHOW COLLECTION:
	Look and see what Selection that they are using.

	SHOW SELECTION:

	 DECtrace> show selection customer_selection_name  

   Selection Name        Facility         Version     Class
   --------------------  ---------------  ----------  --------------------
   customer_selection_name  RDBVMS           V6.0-04     PERFORMANCE

     If the customers CLASS is not ALL or RDBEXPERT, have them add a qualifier 
     to their selection definition to make the class be ALL.

	SHOW DEFINITION:

               $ COLLECT SHOW DEFINITION RDBVMS/VERSION = "V6.0-04"
 
       They would need to use a statement such as follows to create a Facility
        selection to include any other products or their application for
        which they want to collect:

                $ COLLECT CREATE SELECTION SELECTION_1 -
                _$ OPTIONS

                Option> FACILITY RDBVMS /VERSION = "V6.0-04" /CLASS = ALL
                Option> FACILITY there_application_name /VERSION = "Vxxxx"
                Option> ctrl z

	Be sure to verify that they have the correct facility file for 
	the version of RDB that they are running. 

	After the customer verifies everything, if they need to redefine the 
	SELECTION, first have them delete the previous one,
	$COLLECT DELETE SELECTION selection_name. Then they need to rerun 
	the collection and then reformat the .DAT file:

        Then they would need to reschedule and run their collection:

        $ COLLECT SCHEDULE COLLECTION customer_selection_file -
        _$ output_name.DAT -
        -$ /DURATION = :30
        _$ /COLLECTION_FILES = (PROTECTION = (W:RW)
        ...

        Then he needs to REFORMAT his .DAT file to an .RDB file and
        Import the workload to his Expert repository.
 

	Hope that this information is helpful to track down this problem.

	Let me know what you find and I'll help track this down.

	Sheri
314.17Required RDBEXPERT class...M5::BLITTINTue Feb 18 1997 10:5310
    
    Thank you Sheri...
    
    Your last utterance about the RDBex... class:-) on Friday was the fix.  
    I had the CT add the RDBEXPERT class to the selection and this worked.
    CT is on 2.2, rdb6.0 (will be upgrading to 7 soon).
    
    CT had been using ALL and/or PERFORMANCE only.