OLELoad generating win32 exception

Tools
Enthusiast

OLELoad generating win32 exception

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 ;

3 REPLIES
Teradata Employee

Re: OLELoad generating win32 exception

Can you please provide information about OLE DB Provider used for pulling data from Oracle?

Also, provide information about table structure at Oracle database.

Enthusiast

Re: OLELoad generating win32 exception

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)   

Enthusiast

Re: OLELoad generating win32 exception

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.