[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | DB Integrator Public Conference |
| Notice: | Database Integration - today! Kit/Doc info see note 36 |
| Moderator: | BROKE::ABUGOV |
|
| Created: | Mon Sep 21 1992 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1171 |
| Total number of notes: | 5187 |
1159.0. "%DDAL-E-BADDBINFO in extraction from "trans gateway to PC DATA"" by rdb4me.au.oracle.com::DLAWLER (Press any key to continue or any other key to quit...) Wed Apr 23 1997 04:45
Hi,
I've cross posted this in Rdb, Data Distributor and DBI conferences.
A high profile customer is currently evaluating the Rdb Transparent Gateway
for PCData and is attempting a Data Distributor extraction from a MS SQLServer
database on an NT/intel box. The transfer is failing with %DDAL-E-BADDBINFO.
I've included the transfer log file for the failed extraction and another for
a successful extraction from an Rdb database on the same system.
Respective products and versions are:
NT/intel 3.51
MS SQLServer 6.5
VAX/Vms 6.1
Rdb 6.0-15
DDal 6.0-7
Rdb Transparent Gateway for PCDATA 7.0.
The customer is anxious about this as they intended to go live soon and this
could be a show stopper.
Any help will be appreciated.
Cheers,
Dennis.
HV3> TY GATE_EXTRACTION.LOG
%SYSTEM-W-NOTALLPRIV, not all requested privileges authorized
%SET-W-NOTSET, error modifying MBA6797:
-CLI-E-IVDEVTYPE, invalid device type - specify a mailbox device
%SET-W-NOTSET, error modifying MBA6797:
-CLI-E-IVDEVTYPE, invalid device type - specify a mailbox device
%DCL-I-DEFKEY, DEFAULT key PF4 has been defined
%DCL-I-DEFKEY, DEFAULT key F20 has been defined
$ SHOW = "SHOW"
$ RUN = "RUN"
$ LOGOUT = "LOGOUT"
$ SHOW PROCESS
22-APR-1997 14:07:57.33 User: DICKSONA Process ID:
2023025C
Node: HV3 Process name:
"DDAL_COPY_01 "
Terminal: MBA6797:
User Identifier: [DBA,DICKSONA]
Base priority: 4
Default file spec: DBA:[DICKSONA]
$ DEFINE DDAL$CP_CONTINUE "SUCCESS"
$ DEFINE/TRANS=TERMINAL DDAL$TRANSFER_NAME GATE_EXTRACTION
$ DDAL$CP_ACTION :== E
$ DDAL$CP_RETRY_ITERATION == 00
$ RUN DDAL$COPY_PROCESS
Product version: DEC Data Distributor V6.0-7
----- 22-APR-1997 14:07:57.79 ----- Process
-----------------------
--
Process name: DDAL_COPY_01 Priority: 4
Username: DICKSONA UIC: [DBA,DICKSONA]
Nodename: HV3 PID: 2023025C
Privileges currently enabled:
CMKRNL, SYSNAM, DETACH, PRMMBX, PSWAPM, ALTPRI, TMPMBX, WORLD,
OPER,
EXQUOTA, NETMBX, VOLPRO, SYSGBL, SYSPRV, BYPASS, SYSLCK, READALL
Image privileges:
SYSPRV, BYPASS, SYSLCK, SECURITY
Image name:
DSA0:[SYS0.SYSCOMMON.][SYSEXE]DDAL$COPY_PROCESS.EXE
Transfer database = SYS$COMMON:[SYSEXE]DDAL$TR_DB
Transfer name = GATE_EXTRACTION
Transfer option = E (Extraction transfer)
14:07:57 %DDAL-I-READTRDEF, reading the transfer definition from the
transfer database
14:08:00 %DDAL-I-ATTACHSDB, attaching to source database
/TYPE=ODBC/NODE=HCOHQ314.HQ.AUSTPOST.COM.AU/DATABASE=ALANSTESTGATE
----- 22-APR-1997 14:08:18.44 ----- Error
-----------------------
--
%DDAL-E-BADDBINFO, invalid information returned from
Rdb$DATABASE_INFO call
$ LOGOUT
DICKSONA job terminated at 22-APR-1997 14:08:19.33
Accounting information:
Buffered I/O count: 465 Peak working set size:
7259
Direct I/O count: 114 Peak page file size:
27793
- Page faults: 7487 Mounted volumes:
0
=========================================================================
SQL> $ty dba:[dicksona.gate]test_vmsddal.log;
%SYSTEM-W-NOTALLPRIV, not all requested privileges authorized
%SET-W-NOTSET, error modifying MBA4621:
-CLI-E-IVDEVTYPE, invalid device type - specify a mailbox device
%SET-W-NOTSET, error modifying MBA4621:
-CLI-E-IVDEVTYPE, invalid device type - specify a mailbox device
%DCL-I-DEFKEY, DEFAULT key PF4 has been defined
%DCL-I-DEFKEY, DEFAULT key F20 has been defined
$ SHOW = "SHOW"
$ RUN = "RUN"
$ LOGOUT = "LOGOUT"
$ SHOW PROCESS
22-APR-1997 16:53:35.43 User: DICKSONA Process ID:
2021C8E8
Node: HV3 Process name:
"DDAL_COPY_01 "
Terminal: MBA4621:
User Identifier: [DBA,DICKSONA]
Base priority: 4
Default file spec: DBA:[DICKSONA]
$ DEFINE DDAL$CP_CONTINUE "SUCCESS"
$ DEFINE/TRANS=TERMINAL DDAL$TRANSFER_NAME TEST_VMS_DDAL
$ DDAL$CP_ACTION :== E
$ DDAL$CP_RETRY_ITERATION == 00
$ RUN DDAL$COPY_PROCESS
Product version: DEC Data Distributor V6.0-7
----- 22-APR-1997 16:53:35.99 ----- Process
-----------------------
--
Process name: DDAL_COPY_01 Priority: 5
Username: DICKSONA UIC: [DBA,DICKSONA]
Nodename: HV3 PID: 2021C8E8
Privileges currently enabled:
CMKRNL, SYSNAM, DETACH, PRMMBX, PSWAPM, ALTPRI, TMPMBX, WORLD,
OPER,
EXQUOTA, NETMBX, VOLPRO, SYSGBL, SYSPRV, BYPASS, SYSLCK, READALL
Image privileges:
SYSPRV, BYPASS, SYSLCK, SECURITY
Image name:
DSA0:[SYS0.SYSCOMMON.][SYSEXE]DDAL$COPY_PROCESS.EXE
Transfer database = SYS$COMMON:[SYSEXE]DDAL$TR_DB
Transfer name = TEST_VMS_DDAL
Transfer option = E (Extraction transfer)
16:53:36 %DDAL-I-READTRDEF, reading the transfer definition from the
transfer d
atabase
16:53:38 %DDAL-I-ATTACHSDB, attaching to source database
DBA:[DICKSONA.GATE]TES
T_VMS_GATE.RDB
16:53:39 %DDAL-I-CRETARGDB, creating target database
DBA:[DICKSONA.GATE]TEST_DD
AL.RDB
16:53:58 %DDAL-I-ATTACHTDB, attaching to target database
DBA:[DICKSONA.GATE]TES
T_DDAL.RDB
- 16:53:58 %DDAL-I-STADATTRM, starting data transfer/modification
%DDAL-I-DEFGBLFLD, defining global field
RDB$VINTAGE_TIMESTAMP
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TSER
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TRANSFER_ADDR
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TRANSFER_NODE
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TRANSFER_BUSY
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TRANSFER_ID
%DDAL-I-DEFGBLFLD, defining global field
RDBVMS$VINTAGE_TRANSFER_NAME
16:53:59 %DDAL-I-DEFINEREL, defining relation RDB$VINTAGE
16:54:01 %DDAL-I-LOARELDAT, loading data for relation RDB$VINTAGE
%DDAL-I-DEFGBLFLD, defining global field POST_CODE
%DDAL-I-DEFGBLFLD, defining global field
POST_CODE_ALLOC_STATE_CODE
%DDAL-I-DEFGBLFLD, defining global field
NATIONAL_PRESORT_CODE
%DDAL-I-DEFGBLFLD, defining global field REGION_ORG_UNIT_ID
%DDAL-I-DEFGBLFLD, defining global field
POST_CODE_STATUS_CODE
%DDAL-I-DEFGBLFLD, defining global field
NXT_POST_CODE_LOCALITY_SEQ_NB
R
16:54:05 %DDAL-I-DEFINEREL, defining relation EXPORT_POST_CODE
16:54:05 %DDAL-I-LOARELDAT, loading data for relation
EXPORT_POST_CODE
16:54:05 %DDAL-I-RELATSTAT, RELATION EXPORT_POST_CODE
%DDAL-I-RECFRMSRC, 0 records copied from
DBA:[DICKSONA.GATE]T
EST_VMS_GATE.RDB
%DDAL-I-RECTOTARG, 0 records copied into
DBA:[DICKSONA.GATE]T
EST_DDAL.RDB
16:54:05 %DDAL-I-LOARELDAT, loading data for relation RDB$VINTAGE
16:54:06 %DDAL-I-SUMRYSTAT, SUMMARY STATISTICS
%DDAL-I-RECFRMSRC, 0 records copied from
DBA:[DICKSONA.GATE]T
EST_VMS_GATE.RDB
%DDAL-I-RECTOTARG, 0 records copied into
DBA:[DICKSONA.GATE]T
EST_DDAL.RDB
16:54:06 %DDAL-I-ENDDATTRM, ending data transfer/modification
16:54:06 %DDAL-I-COPY_EXIT, normal copy process termination
$ LOGOUT
DICKSONA job terminated at 22-APR-1997 16:54:07.10
Accounting information:
Buffered I/O count: 288 Peak working set size:
10014
Direct I/O count: 1295 Peak page file size:
27789
Page faults: 11912 Mounted volumes:
0
Charged CPU time: 0 00:00:08.16 Elapsed time: 0
00:00:36.81
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 1159.1 | I think you need to upgrade DDD... | BROKE::ABUGOV | | Wed Apr 23 1997 10:18 | 10 |
|
Hi,
I'm not sure DDD V6.0 knows anything about the PC data gateway. I'd
advise you to upgrade to V7.0 of the Rdb Replication Option (which is
the new name for DDD).
Hope this helps,
Dan
|
| 1159.2 | Is Rdb 6.0 supported with DDD V7? | BROKE::GREEN | | Wed Apr 23 1997 17:18 | 14 |
| Doesn't DDD V7 require a minimum of Rdb 6.1?
I could be wrong on this. The V7 BYI says for software requirements to
check a web page. I'm having problems getting to the web at the
moment. The URL in the BYI is:
http://www.oracle.com/products/servers/rdb/html/Matrix.html
Somehow I got spoiled with the old way of mentioning software
requirements in either an SPD or manual.
I'd check on this before I upgraded Replication to V7.
Don
|
| 1159.3 | Need ROR 7.0 and Rdb 6.1 or 7.0 | BROKE::PROTEAU | Jean-Claude Proteau | Thu Apr 24 1997 08:18 | 3 |
|
You need the Replication Option for Rdb 7.0 and either Rdb 6.1 or Rdb
7.0 in order to be able to perform transfers via the PC Data Gateway.
|
| 1159.4 | Can't get more authoritative answers than that! | BROKE::ABUGOV | | Thu Apr 24 1997 10:00 | 2 |
|
Thanks Guys...
|