Conference orarep::nomahs::dec_data_distributor

202.0. "INVALID_BLR when updating a transfert to ORACLE" by PRSSOS::MISTLER () Wed Apr 03 1996 10:47

	Hello,

	DDD doesn't seems to handle correctly the BLR for a transfert to
a oracle database through DBI.I have reproduced the customer environnment
on a single platform and got the same error :

%DDAL-E-ERRACCDSTDB, error occurred accessing the destination database
-DDAL-E-SUPP, %RDB-E-INVALID_BLR, request BLR is incorrect at offset 13
-DDAL-E-SUPP, -DBI-I-CTXVAR_EXISTS, Context variable 0 previously declared at
 BLR offset 103

	DDD or DBI GTW for oracle problem ? ECO available ?

	didier


	Cross-posted in the DBI GTW ORACLE note.
	
	Here is the script to run :
	- On a AXP OVMS V6.1
	- Oracle7 Server  7.1.3.2.0
	- DBI gateway for Oracle V3.1-02A
	- DDD V6.0-0
	- The acces to Oracle database through  SQLPLUS  works fine.
	- The access to Oracle database through the DBI GTW ORACLE works fine.
	- The Initial Replication transfert works fine.
	- The Update Replication transfert fails at BLR errors.

 Here are the output for transfert definition and the 2 log files:

!========================================================================
$mc sql$
attach 'filename rdb_source';
CREATE TABLE tab1
       (f1 smallint CONSTRAINT PK_tab1 PRIMARY KEY,
	f2 CHAR(10) ,
	f3 CHAR(20) ) ;
commit;

create transfer transf3 type is replication
move tables
	select * from tab1
to existing filename 
'/type=oracle/user=SCOTT/password=TIGER/node=2:'
 with no checking
prologue file is prolog$dir:prolog.com
epilogue file is epilog$dir:epilogue.com
log file is      logfil$dir:log_file.log;
commit;
!==============================================================================
$ RUN DDAL$COPY_PROCESS

Product version:	DEC Data Distributor V6.0-0

-----  3-APR-1996 15:32:13.67 ----- Process         -------------------------
Process name:  DDAL_COPY_01                  Priority:  5                       
Username:  MISTLER                           UIC:  [TPDB,MISTLER]               
Nodename:  PADNOM                            PID:  36200B54                     
Privileges currently enabled:
    CMKRNL, CMEXEC, SYSNAM, GRPNAM, ALLSPOOL, DETACH, DIAGNOSE, LOG_IO, GROUP, 
    ACNT, PRMCEB, PRMMBX, PSWAPM, ALTPRI, SETPRV, TMPMBX, WORLD, MOUNT, OPER, 
    EXQUOTA, NETMBX, VOLPRO, PHY_IO, BUGCHK, PRMGBL, SYSGBL, PFNMAP, SHMEM, 
    SYSPRV, BYPASS, SYSLCK, SHARE, UPGRADE, DOWNGRADE, GRPPRV, READALL, 
    SECURITY

Image privileges:
    SYSPRV, BYPASS, SYSLCK, SECURITY

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

Transfer database = SYS$COMMON:[SYSEXE]DDAL$TR_DB
Transfer name     = TRANSF3                        
Transfer option   = I (Initial replication transfer)

15:32:13  %DDAL-I-READTRDEF, reading the transfer definition from the transfer database
15:32:16  %DDAL-I-ATTACHSDB, attaching to source database WORKD$:<MISTLER.DBI.ORACLE>DDD_DBI_ORACLE.RDB
15:32:23  %DDAL-I-STOTRADEF, storing transfer definition in WORKD$:<MISTLER.DBI.ORACLE>DDD_DBI_ORACLE.RDB
15:32:24  %DDAL-I-ATTACHTDB, attaching to target database /TYPE=ORACLE/USER=SCOTT/PASSWORD=TIGER/NODE=2:
15:32:36  %DDAL-I-STADATTRM, starting data transfer/modification

          %DDAL-I-DEFGBLFLD, defining global field DDAL$OBJECT_NAME
          %DDAL-I-DEFGBLFLD, defining global field DDAL$OBJECT_TYPE
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_TIME
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_TSER
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_NODE
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_BUSY
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_ID
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_NAME
15:32:47  %DDAL-I-LOARELDAT, loading data for relation DDAL$TRANSFER_INFO

          %DDAL-I-DEFGBLFLD, defining global field DDAL$DBKEY
          %DDAL-I-DEFGBLFLD, defining global field SQL$SML
          %DDAL-I-DEFGBLFLD, defining global field SQL$10CHR
          %DDAL-I-DEFGBLFLD, defining global field SQL$20CHR
15:32:50  %DDAL-I-DEFINEREL, defining relation TAB1
15:32:52  %DDAL-I-LOARELDAT, loading data for relation TAB1

15:32:52  %DDAL-I-RELATSTAT,                RELATION TAB1

          %DDAL-I-RECFRMSRC,          0 records copied from WORKD$:<MISTLER.DBI.ORACLE>DDD_DBI_ORACLE.RDB

          %DDAL-I-RECTOTARG,          0 records copied into /TYPE=ORACLE/USER=SCOTT/PASSWORD=TIGER/NODE=2:

15:32:52  %DDAL-I-DEFINEIDX, defining index DDAL$KEY_IDX1_2
15:32:53  %DDAL-I-LOARELDAT, loading data for relation DDAL$TRANSFER_INFO

15:32:55  %DDAL-I-SUMRYSTAT,                SUMMARY STATISTICS

          %DDAL-I-RECFRMSRC,          0 records copied from WORKD$:<MISTLER.DBI.ORACLE>DDD_DBI_ORACLE.RDB

          %DDAL-I-RECTOTARG,          0 records copied into /TYPE=ORACLE/USER=SCOTT/PASSWORD=TIGER/NODE=2:

15:32:55  %DDAL-I-ENDDATTRM, ending data transfer/modification

15:32:55  %DDAL-I-COPY_EXIT, normal copy process termination
!==============================================================================
$ RUN DDAL$COPY_PROCESS

Product version:	DEC Data Distributor V6.0-0

-----  3-APR-1996 15:53:22.60 ----- Process         -------------------------
Process name:  DDAL_COPY_01                  Priority:  5                       
Username:  MISTLER                           UIC:  [TPDB,MISTLER]               
Nodename:  PADNOM                            PID:  36200B58                     
Privileges currently enabled:
    CMKRNL, CMEXEC, SYSNAM, GRPNAM, ALLSPOOL, DETACH, DIAGNOSE, LOG_IO, GROUP, 
    ACNT, PRMCEB, PRMMBX, PSWAPM, ALTPRI, SETPRV, TMPMBX, WORLD, MOUNT, OPER, 
    EXQUOTA, NETMBX, VOLPRO, PHY_IO, BUGCHK, PRMGBL, SYSGBL, PFNMAP, SHMEM, 
    SYSPRV, BYPASS, SYSLCK, SHARE, UPGRADE, DOWNGRADE, GRPPRV, READALL, 
    SECURITY

Image privileges:
    SYSPRV, BYPASS, SYSLCK, SECURITY

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

Transfer database = SYS$COMMON:[SYSEXE]DDAL$TR_DB
Transfer name     = TRANSF3                        
Transfer option   = U (Replication update transfer)

15:53:22  %DDAL-I-READTRDEF, reading the transfer definition from the transfer database
15:53:25  %DDAL-I-ATTACHSDB, attaching to source database WORKD$:<MISTLER.DBI.ORACLE>DDD_DBI_ORACLE.RDB
15:53:28  %DDAL-I-ATTACHTDB, attaching to target database /TYPE=ORACLE/USER=SCOTT/PASSWORD=TIGER/NODE=2:
15:53:40  %DDAL-I-STADATTRM, starting data transfer/modification
          %DDAL-I-DEFGBLFLD, defining global field DDAL$OBJECT_NAME
          %DDAL-I-DEFGBLFLD, defining global field DDAL$OBJECT_TYPE
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_TIME
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_TSER
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_NODE
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_BUSY
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_ID
          %DDAL-I-DEFGBLFLD, defining global field DDAL$TRANSFER_NAME
-----  3-APR-1996 15:54:02.77 ----- Error           -------------------------
%DDAL-E-ERRACCDSTDB, error occurred accessing the destination database
-DDAL-E-SUPP, %RDB-E-INVALID_BLR, request BLR is incorrect at offset 13
-DDAL-E-SUPP, -DBI-I-CTXVAR_EXISTS, Context variable 0 previously declared at
 BLR offset 103

  

    
    Didier,
    
    I believe this problem has been corrected in a later version of Data
    Distributor 6.0.  Now that our product is owned by Oracle corporation,
    any replacement kit must be obtained through Oracle.
    
    We are working right now on making such a kit available, but I do not
    yet know the logistics of obtaining one.  I will forward this note to
    my manager, Steve Serra, so that he is aware of your situation.  Please
    consult with Steve about how to obtain a new Data Distributor 6.0
    kit from Oracle.  You can still send E-Mail to Steve at BROKE::SERRA
    until Friday, approximately 1600 US east coast time.  After that, we
    will be moved from the Digital network and will eventually be accessible
    via mail over the Internet.  You will still be able to access this
    notes conference, only at a new address (see a few notes back).
    
    Regards,
    
    Claude