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

Conference orarep::nomahs::dec_data_distributor

Title:The Replication Option for Rdb
Notice:Product renamed to Replication Option for Rdb
Moderator:BROKE::PROTEAU
Created:Wed Mar 02 1994
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:287
Total number of notes:1231

274.0. "Version 7.0 installation errors" by 10245::COBROWN (Colin from Danmark) Tue Apr 01 1997 09:34

    OpenVMS 6.2 Alpha AXP, Rdb 6.1-04 installed.
    Replication option 7.0.
    When installing we observered to problems:
    
    1. The installation failed when SQL$INT and SQL$SHR70 was not
    installed. The error message is clear that this is the problem, but
    there was no explaination as to why they must be installed.
    
    2. IVP generates a whole bunch of errors, but still completes
    successfully. Error is "%COSI-F-NOSUCHID, unknown rights identifier".
    
    Full IVP log in .1
    
    Colin - Danmark
T.RTitleUserPersonal
Name		DateLines
274.1IVP log...10245::COBROWNColin from DanmarkTue Apr 01 1997 09:36265
Full log of IVP:
    
 ****************************************************

    ERROR -- IVP tests failed to execute correctly

    Did you remember to change your LOGIN.COM pro-
    cedure so that the copy process has the correct
    SQL (and Rdb, if appropriate) environment set
    and sufficient privileges to create a transfer
    database and start execution of a transfer moni-
    tor?

 ****************************************************

$
$	RDO

	@SYS$COMMON:[SYSTEST.DDAL]DDAL$IVP.RDO
RDO> !
RDO> !  DDAL$IVP.RDO
RDO> !
RDO> !  A brief exercise of the Replication Option for Rdb using the RDO utility.
RDO> 
RDO> 	INVOKE DATABASE DDAL$TEST_DB = FILENAME 'DDAL$IVP_DIR:DDAL$TEST_DB'
RDO> 
RDO> 	SHOW RELATION
User Relations in Database with db_handle DDAL$TEST_DB
     EMPLOYEES                       
RDO> 	SHOW RELATION SYSTEM
System Relations in Database with db_handle DDAL$TEST_DB
     RDB$COLLATIONS                  
     RDB$CONSTRAINTS                 
     RDB$CONSTRAINT_RELATIONS        
     RDB$DATABASE                    
     RDB$FIELDS                      
     RDB$FIELD_VERSIONS              
     RDB$INDEX_SEGMENTS              
     RDB$INDICES                     
     RDB$INTERRELATIONS              
     RDB$MODULES                     
     RDB$PARAMETERS                  
     RDB$PRIVILEGES                  
     RDB$QUERY_OUTLINES              
     RDB$RELATIONS                   
     RDB$RELATION_CONSTRAINTS        
     RDB$RELATION_CONSTRAINT_FLDS    
     RDB$RELATION_FIELDS             
     RDB$ROUTINES                    
     RDB$STORAGE_MAPS                
     RDB$STORAGE_MAP_AREAS           
     RDB$TRIGGERS                    
     RDB$VIEW_RELATIONS              
     RDBVMS$COLLATIONS                A view.
     RDBVMS$INTERRELATIONS            A view.
     RDBVMS$PRIVILEGES                A view.
     RDBVMS$RELATION_CONSTRAINTS      A view.
     RDBVMS$RELATION_CONSTRAINT_FLDS  A view.
     RDBVMS$STORAGE_MAPS              A view.
     RDBVMS$STORAGE_MAP_AREAS         A view.
     RDBVMS$TRIGGERS                  A view.
RDO> 
RDO> 	DEFINE TRANSFER IVP_TR EXTRACTION
cont> 	  TO SYS$COMMON:[SYSTEST.DDAL.DDAL$CP]DDAL$REMOTE_DB 
cont> 	  MOVE RELATION E IN EMPLOYEES
cont> 	    SELECT FIELDS ALL
cont> 	  LOGFILE IS DDAL$CP_DIR:DDAL$IVP_CP.LOG
cont> 	END.
RDO> 
RDO> !  Test to see if RDO communicates with the transfer monitor.
RDO> 
RDO> 	SHOW TRANSFER DEFINITION FOR IVP_TR
%COSI-F-NOSUCHID, unknown rights identifier
RDO> 	SHOW TRANSFER STATUS FOR IVP_TR
%COSI-F-NOSUCHID, unknown rights identifier
RDO> 
RDO> 	FINISH
RDO> 
RDO> !  Test that the copy process can be invoked to perform a transfer.
RDO> 
RDO> 	START TRANSFER IVP_TR NOW WAIT
RDO> 	SHOW TRANSFER STATUS FOR IVP_TR 
%COSI-F-NOSUCHID, unknown rights identifier
RDO> 
RDO> 	EXIT
$
$	SET NOVERIFY

 ****************************************************

    The following is a list of differences between
    the expected and actual results.

 ****************************************************

************
File SYS$COMMON:[SYSTEST.DDAL]DDAL$IVP.LOG;1
   58   %COSI-F-NOSUCHID, unknown rights identifier
   59   RDO> 	SHOW TRANSFER STATUS FOR IVP_TR
   60   %COSI-F-NOSUCHID, unknown rights identifier
   61   RDO>
******
File SYS$COMMON:[SYSTEST.DDAL]DDAL$IVP.BMK;1
   58   
------------------------------------------------------------

   59   Transfer Definition for IVP_TR                          

   60        Definer XXXXXXXXXXXXXXXXX
   61        Extraction
   62        From SYS$COMMON:[SYSTEST.DDAL]DDAL$TEST_DB.RDB
   63        To New SYS$COMMON:[SYSTEST.DDAL.DDAL$CP]DDAL$REMOTE_DB
   64        Move Relation E IN EMPLOYEES
   66             Select Fields E.EMPLOYEE_ID,
   67                           E.LAST_NAME,
   68                           E.FIRST_NAME,
   69                           E.MIDDLE_INITIAL,
   70                           E.ADDRESS_DATA_1,
   71                           E.ADDRESS_DATA_2,
   72                           E.CITY,
   73                           E.STATE,
   74                           E.POSTAL_CODE,
   75                           E.SEX,
   76                           E.BIRTHDAY,
   77                           E.STATUS_CODE
   78        Log File is SYS$COMMON:[SYSTEST.DDAL.DDAL$CP]DDAL$IVP_CP.LOG
   79        Noprologue
   80        Noepilogue
   81   

   82   RDO> 	SHOW TRANSFER STATUS FOR IVP_TR
   83   
------------------------------------------------------------

   84   Transfer Status for IVP_TR                          

   85        Transfer State:  UNSCHEDULED since dd-mmm-yyyy hh:mm:ss.xxxx
   86        Transfer has never been executed successfully
   87   

   88   RDO>
************
************
File SYS$COMMON:[SYSTEST.DDAL]DDAL$IVP.LOG;1
   68   %COSI-F-NOSUCHID, unknown rights identifier
   69   RDO>
******
File SYS$COMMON:[SYSTEST.DDAL]DDAL$IVP.BMK;1
   95   
------------------------------------------------------------

   96   Transfer Status for IVP_TR                          

   97        Transfer State:  UNSCHEDULED since dd-mmm-yyyy hh:mm:ss.xxxx
   98        Last transfer status: transfer was successful
   99        Last successful transfer time:   dd-mmm-yyyy hh:mm:ss.xxxx
  100   

  101   RDO>
************

Number of difference sections found: 2
Number of difference records found: 35

DIFFERENCES /IGNORE=(TRAILING_SPACES,BLANK_LINES)/MERGED=1/OUTPUT=SYS$COMMON:[SYSTEST.DDAL]DDAL$IVP.TMP;1-
    SYS$COMMON:[SYSTEST.DDAL]DDAL$IVP.LOG;1-
    SYS$COMMON:[SYSTEST.DDAL]DDAL$IVP.BMK;1

 ****************************************************

    The following is the COPY_PROCESS log file.

 ****************************************************

                                     .
 Please note that the database version is set to 7.0 

Current PROCESS Oracle Rdb environment is version V7.0-0 (MULTIVERSION)
Current SYSTEM Oracle Rdb environment is version V6.1-1 (MULTIVERSION)
Current PROCESS SQL environment is version V7.0-0 (MULTIVERSION)
Current PROCESS Rdb/Dispatch environment is version V7.0-0 (MULTIVERSION)
Current SYSTEM SQL environment is version V6.1-1 (MULTIVERSION)
Current SYSTEM Rdb/Dispatch environment is version V6.1-1 (MULTIVERSION)
$ SHOW = "SHOW"
$ RUN = "RUN"
$ LOGOUT = "LOGOUT"
$ SHOW PROCESS 

26-MAR-1997 14:28:40.09   User: COBROWN          Process ID:   0000138F
                          Node: DKAXP3           Process name: "COBROWN_4"

Terminal:           MBA3057:
User Identifier:    [RDB,COBROWN]
Base priority:      4
Default file spec:  DISK$RDB1:[COBROWN]
$ DEFINE DDAL$CP_CONTINUE "SUCCESS"
$ DEFINE/TRANS=TERMINAL DDAL$TRANSFER_NAME IVP_TR
$ DDAL$CP_ACTION :== E
$ DDAL$CP_RETRY_ITERATION == 00
$ RUN DDAL$COPY_PROCESS

Product version:	 Replication Option for Rdb V7.0-0

----- 26-MAR-1997 14:28:40.69 ----- Process         -------------------------
Process name:  COBROWN_4                     Priority:  4                       
Username:  COBROWN                           UIC:  [RDB,COBROWN]                
Nodename:  DKAXP3                            PID:  0000138F                     
Privileges currently enabled:
    SYSNAM, TMPMBX, OPER, NETMBX, BYPASS

Image privileges:
    SYSPRV, BYPASS, SYSLCK, SECURITY

Image name:
    DKAXP3$DKA0:[SYS0.SYSCOMMON.][SYSEXE]DDAL$COPY_PROCESS.EXE

Transfer database = SYS$COMMON:[SYSTEST.DDAL]DDAL$TR_DB
Transfer name     = IVP_TR                         
Transfer option   = E (Extraction transfer)

14:28:40  %DDAL-I-READTRDEF, reading the transfer definition from the transfer database
14:28:42  %DDAL-I-ATTACHSDB, attaching to source database SYS$COMMON:[SYSTEST.DDAL]DDAL$TEST_DB.RDB
14:28:43  %DDAL-I-CRETARGDB, creating target database SYS$COMMON:[SYSTEST.DDAL.DDAL$CP]DDAL$REMOTE_DB
14:28:47  %DDAL-I-ATTACHTDB, attaching to target database SYS$COMMON:[SYSTEST.DDAL.DDAL$CP]DDAL$REMOTE_DB
14:28:47  %DDAL-I-STADATTRM, starting data transfer/modification

          %DDAL-I-CREDOMAIN, creating domain RDB$VINTAGE_TIMESTAMP
          %DDAL-I-CREDOMAIN, creating domain RDBVMS$VINTAGE_TSER
          %DDAL-I-CREDOMAIN, creating domain RDBVMS$VINTAGE_TRANSFER_ADDR
          %DDAL-I-CREDOMAIN, creating domain RDBVMS$VINTAGE_TRANSFER_NODE
          %DDAL-I-CREDOMAIN, creating domain RDBVMS$VINTAGE_TRANSFER_BUSY
          %DDAL-I-CREDOMAIN, creating domain RDBVMS$VINTAGE_TRANSFER_ID
          %DDAL-I-CREDOMAIN, creating domain RDBVMS$VINTAGE_TRANSFER_NAME
14:28:47  %DDAL-I-CREATABLE, creating table RDB$VINTAGE
14:28:48  %DDAL-I-LOATABDAT, loading data for table RDB$VINTAGE

          %DDAL-I-CREDOMAIN, creating domain ADDRESS_DATA_1
          %DDAL-I-CREDOMAIN, creating domain ADDRESS_DATA_2
          %DDAL-I-CREDOMAIN, creating domain CITY
          %DDAL-I-CREDOMAIN, creating domain FIRST_NAME
          %DDAL-I-CREDOMAIN, creating domain ID_NUMBER
          %DDAL-I-CREDOMAIN, creating domain LAST_NAME
          %DDAL-I-CREDOMAIN, creating domain MIDDLE_INITIAL
          %DDAL-I-CREDOMAIN, creating domain POSTAL_CODE
          %DDAL-I-CREDOMAIN, creating domain SEX
          %DDAL-I-CREDOMAIN, creating domain STANDARD_DATE
          %DDAL-I-CREDOMAIN, creating domain STATE
          %DDAL-I-CREDOMAIN, creating domain STATUS_CODE
14:28:49  %DDAL-I-CREATABLE, creating table EMPLOYEES
14:28:49  %DDAL-I-LOATABDAT, loading data for table EMPLOYEES

14:28:49  %DDAL-I-TAB_STATS,                  TABLE  EMPLOYEES

          %DDAL-I-ROWSFMSRC,          3 rows copied from SYS$COMMON:[SYSTEST.DDAL]DDAL$TEST_DB.RDB

          %DDAL-I-ROWSTOTGT,          3 rows copied into SYS$COMMON:[SYSTEST.DDAL.DDAL$CP]DDAL$REMOTE_DB

14:28:49  %DDAL-I-LOATABDAT, loading data for table RDB$VINTAGE

14:28:49  %DDAL-I-SUMRYSTAT,                SUMMARY STATISTICS

          %DDAL-I-ROWSFMSRC,          3 rows copied from SYS$COMMON:[SYSTEST.DDAL]DDAL$TEST_DB.RDB

          %DDAL-I-ROWSTOTGT,          3 rows copied into SYS$COMMON:[SYSTEST.DDAL.DDAL$CP]DDAL$REMOTE_DB

14:28:49  %DDAL-I-ENDDATTRM, ending data transfer/modification

14:28:49  %DDAL-I-COPY_EXIT, normal copy process termination

$ LOGOUT
  COBROWN      job terminated at 26-MAR-1997 14:28:49.93

  Accounting information:
  Buffered I/O count:             734         Peak working set size:  20688
  Direct I/O count:              1246         Peak page file size:    81552
  Page faults:                   2433         Mounted volumes:            0
  Charged CPU time:           0 00:00:03.85   Elapsed time:     0 00:00:13.39
274.2Did you mean to say 70?BROKE::PROTEAUJean-Claude ProteauTue Apr 01 1997 17:2512
    
    Colin,
    
    I'm not at the office so I am going on memory here.  When the
    Replication Option is used with Rdb 6.1, some of the SQL images must be
    installed.  I'm not sure why you listed the 70 version of the SQL image
    rather than the 61 version.  Do you have multiple versions of Rdb and
    SQL on the system?  It is the 61 versions we expect to be installed in
    this case.  Rdb 6.1 installation does not install the SQL images
    whereas Rdb 7.0 does.
    
    Claude
274.3That explains 1. but it is still an error10245::COBROWNColin from DanmarkTue Apr 08 1997 07:227
    That is a reasonable explaination for the first question.  At the time
    we first encountered the problem it refered to 70, but only 6.1 was
    installed. We installed the images and all worked fine.
    
    Later we installed Rdb 7.0. All is MV.
    
    Colin
274.4Same problem with Rdb 7.0-014177::MHAGEM�rta Hage, Oracle Rdb Support,SwedenTue Apr 15 1997 06:0117
    
    
    I have same problem with Rdb 7.0-01 installed as Standard version
    with 6.1 and 6.0 installed as MV. I didn't have Replication option
    installed previously. 
    The IVP fails with 
    
    RDO>    SHOW TRANSFER DEFINITION FOR IVP_TR
    %COSI-F-NOSUCHID, unknown rights identifier
    RDO>    SHOW TRANSFER STATUS FOR IVP_TR
    %COSI-F-NOSUCHID, unknown rights identifier
    
    I'll reinstall Rdb 7.0 then Replication option and finally ECO1
    for Rdb.
    
    M�rta
274.54177::MHAGEM�rta Hage, Oracle Rdb Support,SwedenTue Apr 15 1997 06:356
    
    That was waste of time, I've still get NOSUCHID so I decided
    to live without IVP now.
    
    
    M�rta
274.6Ooops4177::MHAGEM�rta Hage, Oracle Rdb Support,SwedenTue Apr 15 1997 07:323
    Shame on me, I read the Installation Guide
    
    ADD/IDENTFIER DDAL$TR_MON was the solution
274.7Glad you figured out the problemBROKE::PROTEAUJean-Claude ProteauTue Apr 15 1997 08:094
    
    Wouldn't life be easier if these error messages would tell you which
    identifier or privilege, or quota was missing or exceeded?  I'll bet
    mankind has wasted over 100000 man-hours because of it.