Can you please provide information about OLE DB Provider used for pulling data from Oracle?
Also, provide information about table structure at Oracle database.
-Sudhansu
Hello SuSeSi,
Happy 2012! Thanks for your response. Sorry for not responding earlier, as I have been offline due to the holidays....
One of our Teradata contractors was able to solve this (or at least get a workaround) by not specifying LDAP in the script file, and instead authenticating with the Teradata password itself. This is an acceptable solution for me, as I'm now focused on trying to get tbuild/TPT working with my ODBC driver. Anyway, the info you asked for is below:
SOURCE:
==========
Provider Name: MSDAORA.DLL, Version 02.81.1132.0
DBMS Name: Oracle, Version 11.01.0000 Oracle Database 11g Enterprise Edition
DESTINATION:
============
Provider Name and Version is blank and gray'ed-out
DBMS Name: Teradata, Version 13.10.0101
Oracle Source Table
Name Null? Type
----------------------------------------- -------- ----------------------------
PROV_ID VARCHAR2(18)
PROV_SPECIALTY_1 VARCHAR2(254)
PROV_SPECIALTY_2 VARCHAR2(254)
PROV_SPECIALTY_3 VARCHAR2(254)
PROV_SPECIALTY_4 VARCHAR2(254)
PROV_SPECIALTY_5 VARCHAR2(254)
Ooops, Correction from my last post:
by not specifying LDAP in the script file, and instead authenticating with the Teradata password itself.
SHOULD BE
by not specifying ldap as Mechanism in the OLELoad login prompt, and instead using "default" as the authentication mechanism.
Hello,
I am using OLELoad 13.10.00.02 to pull data from Oracle 11g to Teradata 13.10. Some tables load with no problem, but with some, I am getting a win32 exception. The exception appears to happen randomly. A table will fail at one time and succeed later. When the exception happens, the table is created at the destination, but it is empty. Any help would be greatly appreciated. Below is the error, generated script, and log. Thanks!
An unhandled win32 exception occurred in fastload.exe [3748]
in VB debugger:
Unhandled exception at 0x781450ac in fastload.exe: 0xC0000005: Access violation reading location 0x00d89000.
msvcr80.dll!781450ac()
[Frames below may be incorrect and/or mising, no symbols loaded for msvcr80.dll]
wincli32.dll!32022cf7()
/* Launch the FastLoad utility with the -c <character_set_name>
option set to UTF8. (i.e. "fastload -c UTF8") */
.LOGMECH LDAP;
LOGON xxxxxxxxxxxx;
DATABASE xxxxxxxxxx;
CREATE MULTISET TABLE "ASTHMASMPL_PROV_SPECIALTY" ( PROV_ID VARCHAR(18) CHARACTER SET UNICODE CASESPECIFIC ,
PROV_SPECIALTY_1 VARCHAR(254) CHARACTER SET UNICODE CASESPECIFIC ,
PROV_SPECIALTY_2 VARCHAR(254) CHARACTER SET UNICODE CASESPECIFIC ,
PROV_SPECIALTY_3 VARCHAR(254) CHARACTER SET UNICODE CASESPECIFIC ,
PROV_SPECIALTY_4 VARCHAR(254) CHARACTER SET UNICODE CASESPECIFIC ,
PROV_SPECIALTY_5 VARCHAR(254) CHARACTER SET UNICODE CASESPECIFIC ) ;
BEGIN LOADING "ASTHMASMPL_PROV_SPECIALTY"
ERRORFILES ErrorFile1, ErrorFile2
INDICATORS ;
AXSMOD Oledb_Axsmod "noprompt";
DEFINE PROV_ID (VARCHAR(72)),
PROV_SPECIALTY_1 (VARCHAR(1016)),
PROV_SPECIALTY_2 (VARCHAR(1016)),
PROV_SPECIALTY_3 (VARCHAR(1016)),
PROV_SPECIALTY_4 (VARCHAR(1016)),
PROV_SPECIALTY_5 (VARCHAR(1016)) FILE=Untitled ;
INSERT INTO "ASTHMASMPL_PROV_SPECIALTY" ( PROV_ID, PROV_SPECIALTY_1,
PROV_SPECIALTY_2,
PROV_SPECIALTY_3,
PROV_SPECIALTY_4,
PROV_SPECIALTY_5 )
VALUES ( :PROV_ID, :PROV_SPECIALTY_1, :PROV_SPECIALTY_2,
:PROV_SPECIALTY_3, :PROV_SPECIALTY_4, :PROV_SPECIALTY_5 ) ;
END LOADING ;
LOGOFF ;
---------------------------------------------------
====================================================== =============
= =
= FASTLOAD UTILITY VERSION 13.10.00.007 =
= PLATFORM WIN32 =
= =
====================================================== =============
====================================================== =============
= =
= Copyright 1984-2010, Teradata Corporation. =
= ALL RIGHTS RESERVED. =
= =
====================================================== =============
**** 08:50:34 Processing starting at: Fri Dec 23 08:50:34 2011
**** 08:50:34 Character set has been set to: UTF-8
/* Launch the FastLoad utility with the -c <character_set_name>
option set to UTF8. (i.e. "fastload -c UTF8") */
0001 .LOGMECH LDAP;
====================================================== =============
= =
= Logon/Connection =
= =
====================================================== =============
0002 LOGON xxxxxxxx,
**** 08:50:38 Teradata Database Release: 13.10.01.01
**** 08:50:38 Teradata Database Version: 13.10.01.01
**** 08:50:38 Current CLI or RDBMS allows maximum row size: 64K
**** 08:50:38 Character set for this job: UTF-8
0003 DATABASE xxxxxxx ;
**** 08:50:39 Command completed successfully
0004 CREATE MULTISET TABLE "ASTHMASMPL_PROV_SPECIALTY" ( PROV_ID VARCHA
R(18) CHARACTER SET UNICODE CASESPECIFIC ,
PROV_SPECIALTY_1 VARCH
AR(254) CHARACTER SET UNICODE CASESPECIFIC ,
PROV_SPECIALTY_2 VARCH
AR(254) CHARACTER SET UNICODE CASESPECIFIC ,
PROV_SPECIALTY_3 VARCH
AR(254) CHARACTER SET UNICODE CASESPECIFIC ,
PROV_SPECIALTY_4 VARCH
AR(254) CHARACTER SET UNICODE CASESPECIFIC ,
PROV_SPECIALTY_5 VARCH
AR(254) CHARACTER SET UNICODE CASESPECIFIC ) ;
**** 08:50:39 Command completed successfully
0005 BEGIN LOADING "ASTHMASMPL_PROV_SPECIALTY"
ERRORFILES ErrorFile1, ErrorFile2
INDICATORS ;