Conference orarep::nomahs::dbintegrator_public_public

1042.0. "INVALID_BLR when updating a transfert to Oracle" by PRSSOS::MISTLER () Wed Apr 03 1996 10:52

	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 DEC DATA DISTRIBUTOR Conference.
	
	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 replied to your note in the DEC_DATA_DISTRIBUTOR notes conference.
    This sounds like a problem that has been corrected in DDD.
    
    Claude