Data load from Teradata to Oracle using OleLoad

Tools & Utilities
Highlighted
New Member

Data load from Teradata to Oracle using OleLoad

Hello all,

 

I've been trying for some time to load data from a Teradata database to an Oracle one. I found the OleLoad utility, but I cannot get it to work. I would deeply appreciate some help.

The connections are fine, but the data never reaches the Oracle database. 

I am really not sure what is going on... The Teradata version is 16.20, running on Windows 10. I am not quite sure about the Oracle database version as it's a remote test environment, but i'm using OraOLEDB12.

 

I'm using the TPT Export option of OleLoad:

 

###############################

SET MyTdpId='*******';
SET MyUserName='*******';
SET MyPassword='******';
SET MyDatabase='******';
USING CHAR SET UTF8
DEFINE JOB MyJob
(
DEFINE SCHEMA MySchema
(
cust_no DECIMAL(8,0)
);
DEFINE OPERATOR MyProducer()
TYPE EXPORT
SCHEMA MySchema
ATTRIBUTES
(
VARCHAR DateForm = 'IntegerDate',
VARCHAR PrivateLogName = 'producer_log',
VARCHAR SelectStmt = 'SELECT cust_no FROM test_oracle',
VARCHAR TdpId = @MyTdpId,
VARCHAR UserName = @MyUserName,
VARCHAR UserPassword = @MyPassword,
VARCHAR WorkingDatabase = @MyDatabase,
VARCHAR TraceLevel = 'ALL'
);
DEFINE OPERATOR DataConnOper()
TYPE DATACONNECTOR CONSUMER
SCHEMA MySchema
ATTRIBUTES
(
VARCHAR AccessModuleName = 'Oledb_Axsmod',
VARCHAR AccessModuleInitStr = 'noprompt jobid=1',
VARCHAR FileName = 'C:\Work\Various Scripts\test.amj',
VARCHAR Format = 'Formatted',
VARCHAR IndicatorMode = 'Yes',
VARCHAR PrivateLogName = 'consumer_log'
);
STEP export_the_data
(
APPLY TO OPERATOR (DataConnOper)
SELECT * FROM OPERATOR (MyProducer);
);
);

###############################

 

I'm noticing a ***Job step export_the_data terminated (status 4)*** but I could not find anything on what that status code is, nor anything in the logs themselves.

 

And this is the log:

 

###########################

Job started at: 04/16/19 16:11:10


Public log:


TPT_INFRA: TPT04101: Warning: Teradata PT cannot connect to Unity EcoSystem Manager.
The job will continue without event messages being sent to Unity EcoSystem Manager.
TPT_INFRA: TPT04197: Warning: OMD API failed to initialize
Teradata Parallel Transporter PlanExecutor Version 16.20.00.03

Total Available Memory: 6291456
DSMemoryPercentage: 70
Using Message Size: 1048576

Teradata Parallel Transporter Coordinator Version 16.20.00.03
Teradata Parallel Transporter Executor Version 16.20.00.03
Teradata Parallel Transporter Executor Version 16.20.00.03
Teradata Parallel Transporter Export Operator Version 16.20.00.03
MyProducer: private log specified: producer_log
Teradata Parallel Transporter DataConnector Operator Version 16.20.00.03
DataConnOper[1]: TPT19206 Attribute 'TraceLevel' value reset to 'Statistics Only'.
DataConnOper[1]: Instance 1 directing private log report to 'consumer_log-1'.
DataConnOper[1]: DataConnector Consumer operator Instances: 1
DataConnOper[1]: TPT19203 Required attribute 'OpenMode' not found. Defaulting to 'Write'.
DataConnOper[1]: ECI operator ID: 'DataConnOper-17896'
MyProducer: connecting sessions
DataConnOper[1]: Operator instance 1 processing file 'C:\Work\Various Scripts\test.amj'.
MyProducer supports the max row size 1024KB.
DataConnOper supports the max row size 64KB.
Job step 'export_the_data' uses the max row size 64KB.
Job is running in Buffer Mode
Task(INSERT_1[0001]): checkpoint completed, status = Success
Task(SELECT_2[0001]): checkpoint completed, status = Success
MyProducer: sending SELECT request
Data Block size: 1048600 Buffers/Block: 2 Data Buffer size: 524296
MyProducer: entering End Export Phase
MyProducer: Total Rows Exported: 10
MyProducer: Total Rows Discarded: 0
TASK(SELECT_2[0001]) sends internal checkpoint request
TASK(SELECT_2[0001]) ready to take checkpoint, DS status = 0
Task(SELECT_2[0001]) ready to checkpoint after PXTB_AcceptRow

Task(SELECT_2[0001]): checkpoint completed, status = Success
Task(INSERT_1[0001]) gets checkpoint marker.

Task(INSERT_1[0001]) ready to checkpoint.
Task(INSERT_1[0001]): checkpoint completed, status = Success
Task(INSERT_1[0001]) gets EndOfData marker.

Task(INSERT_1[0001]) ready to take EOD checkpoint, status = End Of Data

Task(SELECT_2[0001]) ready to take EOD checkpoint, status = Success
Task(SELECT_2[0001]): checkpoint completed, status = Success
Task(INSERT_1[0001]): checkpoint completed, status = Success
TASK(SELECT_2[0001]) completes EOD checkpoint, status = Success
TASK(INSERT_1[0001]) completes EOD checkpoint, status = Success
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 0, Total Rows Sent = 0
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 0, Total Rows Sent = 0
MyProducer: disconnecting sessions
DataConnOper[1]: Total files processed: 1.
MyProducer: Performance metrics:
MyProducer: MB/sec in Export phase: 0.000
MyProducer: Elapsed time from start to Select phase: 68 second(s)
MyProducer: Elapsed time in Select phase: 1 second(s)
MyProducer: Elapsed time in Export phase: 1 second(s)
MyProducer: Elapsed time from Export phase to end: 21 second(s)
MyProducer: Total processor time used = '12.3594 Second(s)'
MyProducer: Start : Tue Apr 16 16:11:10 2019
MyProducer: End : Tue Apr 16 16:12:41 2019
Job step export_the_data terminated (status 4)
Job OleLoad-q9vqzhqzeab completed successfully, but with warning(s).
Job start: Tue Apr 16 16:11:10 2019
Job end: Tue Apr 16 16:12:41 2019
Total available memory: 6291456
Largest allocable area: 0
Memory use high water mark: 1056208
Free map size: 1024
Free map use high water mark: 16
Free list use high water mark: 0


Private log PXCRM:


CheckPoint Resource Manager initialized.
Checking whether a valid CheckPoint exists for restart.
CheckPoint No. 1 started.
CheckPoint No. 1 finished successfully.
CheckPoint No. 2 started.
CheckPoint No. 2 finished successfully.
CheckPoint No. 3 started.
CheckPoint No. 3 finished successfully.

Private log TWB_SRCTGT:


export_the_data SELECT_2[0001] MyProducer SQL *****
export_the_data INSERT_1[0001] DataConnOper ACCESS MODULE Oledb_Axsmodous Scripts\test.amj

Private log TWB_STATUS:


export_the_data SELECT_2[0001] Success MyProducer 1 1 INITIATE-Started 16:11:10 0.0000 0.0000 1048576 0 0 0 0 0 N Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 INITIATE-Started 16:11:10 0.0000 0.0000 1048576 0 0 0 0 0 N Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 INITIATE-Ended 16:12:17 67.0000 11.5469 1048576 0 0 0 0 0 N Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 INITIATE-Ended 16:12:17 67.0000 2.5156 1048576 0 0 0 0 0 N Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 EXECUTE-Started 16:12:17 0.0000 0.0000 1048576 0 0 0 0 0 N Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 EXECUTE-Started 16:12:17 0.0000 0.0000 1048576 0 0 0 0 0 N Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 CHECKPOINT-Started 16:12:17 0.0000 0.0000 1048576 0 0 0 0 0 N Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 CHECKPOINT-Started 16:12:17 0.0000 0.0000 1048576 0 0 0 0 0 N Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 CHECKPOINT-Ended 16:12:18 1.0000 0.0000 1048576 0 0 0 0 0 N Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 CHECKPOINT-Ended 16:12:18 1.0000 0.0000 1048576 0 0 0 0 0 N Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 CHECKPOINT-Started 16:12:20 3.0000 0.8125 1048600 1 0 0 0 0 Y Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 CHECKPOINT-Ended 16:12:21 4.0000 0.8125 1048600 1 0 0 0 0 Y Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 CHECKPOINT-Started 16:12:21 4.0000 0.0000 1048576 1 0 0 0 0 N Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 CHECKPOINT-Ended 16:12:24 7.0000 0.0156 1048576 1 0 0 0 0 N Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 CHECKPOINT-Started 16:12:24 7.0000 0.0156 1048576 1 0 0 0 0 Y Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 CHECKPOINT-Started 16:12:24 7.0000 0.8125 1048600 1 0 0 0 0 Y Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 CHECKPOINT-Ended 16:12:25 8.0000 0.8125 1048600 1 0 0 0 0 Y Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 CHECKPOINT-Ended 16:12:25 8.0000 0.0156 1048576 1 0 0 0 0 Y Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 EXECUTE-Ended 16:12:25 8.0000 0.8125 1048600 1 0 0 0 0 Y Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 EXECUTE-Ended 16:12:25 8.0000 0.0156 1048576 1 0 0 0 0 Y Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 TERMINATE-Started 16:12:25 0.0000 0.0000 1048576 0 0 0 0 0 Y Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 TERMINATE-Started 16:12:25 0.0000 0.0000 1048600 0 0 0 0 0 Y Y
export_the_data INSERT_1[0001] Success DataConnOper 1 1 TERMINATE-Ended 16:12:25 0.0000 0.0313 1048576 0 0 0 0 0 Y Y
export_the_data SELECT_2[0001] Success MyProducer 1 1 TERMINATE-Ended 16:12:41 16.0000 0.4375 1048600 0 0 0 0 0 Y Y

Private log TWB_EVENTS:


OleLoad-q9vqzhqzeab-2,17,5,OperatorEnter,export_the_data,MyProducer,1,2019-04-16,2019-04-16 16:11:10,2,0
OleLoad-q9vqzhqzeab-2,176,5,OperatorVersion,export_the_data,MyProducer,1,2019-04-16,16.20.00.03,2,0
OleLoad-q9vqzhqzeab-2,177,1,OperatorType,export_the_data,MyProducer,1,2019-04-16,1,2,0
OleLoad-q9vqzhqzeab-2,178,1,OperatorInstances,export_the_data,MyProducer,1,2019-04-16,1,2,0
OleLoad-q9vqzhqzeab-2,184,5,PrivateLogName,export_the_data,MyProducer,1,2019-04-16,producer_log,2,0
OleLoad-q9vqzhqzeab-2,116,5,UtilityName,export_the_data,MyProducer,1,2019-04-16,TPT Export Operator,2,0
OleLoad-q9vqzhqzeab-2,8,5,ExportVersionId,export_the_data,MyProducer,1,2019-04-16,16.20.00.03,2,0
OleLoad-q9vqzhqzeab-2,115,1,UtilityId,export_the_data,MyProducer,1,2019-04-16,3,2,0
OleLoad-q9vqzhqzeab-2,131,5,ExportTdpId,export_the_data,MyProducer,1,2019-04-16,*****,2,0
OleLoad-q9vqzhqzeab-2,9,5,ExportUserName,export_the_data,MyProducer,1,2019-04-16,*****,2,0
OleLoad-q9vqzhqzeab-2,127,5,ExportDbase,export_the_data,MyProducer,1,2019-04-16,*****,2,0
OleLoad-q9vqzhqzeab-2,180,1,TotalSessAssigned,export_the_data,MyProducer,1,2019-04-16,1152,2,0
OleLoad-q9vqzhqzeab-2,181,1,TotalSessConnected,export_the_data,MyProducer,1,2019-04-16,299,2,0
OleLoad-q9vqzhqzeab-2,182,1,TASMSessionLimit,export_the_data,MyProducer,1,2019-04-16,0,2,0
OleLoad-q9vqzhqzeab-2,86,0,ExportBegin,export_the_data,MyProducer,1,2019-04-16,,2,0
OleLoad-q9vqzhqzeab-2,88,5,ExportReqSubmitBegin,export_the_data,MyProducer,1,2019-04-16,SELECT cust_no FROM test_oracle,2,0
OleLoad-q9vqzhqzeab-2,89,0,ExportReqSubmitEnd,export_the_data,MyProducer,1,2019-04-16,,2,0
OleLoad-q9vqzhqzeab-2,99,37,ExportStmtCount,export_the_data,MyProducer,1,2019-04-16,4294967297,2,0
OleLoad-q9vqzhqzeab-2,100,37,ExportBlockCount,export_the_data,MyProducer,1,2019-04-16,65088030347624448,2,0
OleLoad-q9vqzhqzeab-2,90,5,ExportReqFetchBegin,export_the_data,MyProducer,1,2019-04-16,2019-04-16 16:12:19,2,0
OleLoad-q9vqzhqzeab-2,92,0,ExportStmtFetchBegin,export_the_data,MyProducer,1,2019-04-16,,2,0
OleLoad-q9vqzhqzeab-2,94,37,ExportStmtNumber,export_the_data,MyProducer,1,2019-04-16,4294967297,2,0
OleLoad-q9vqzhqzeab-2,95,37,ExportStmtBlockCount,export_the_data,MyProducer,1,2019-04-16,6724021715661225984,2,0
OleLoad-q9vqzhqzeab-2,93,0,ExportStmtFetchEnd,export_the_data,MyProducer,1,2019-04-16,,2,0
OleLoad-q9vqzhqzeab-2,96,37,ExportStmtRowsFetched,export_the_data,MyProducer,1,2019-04-16,10,2,0
OleLoad-q9vqzhqzeab-2,91,5,ExportReqFetchEnd,export_the_data,MyProducer,1,2019-04-16,2019-04-16 16:12:20,2,0
OleLoad-q9vqzhqzeab-2,87,0,ExportEnd,export_the_data,MyProducer,1,2019-04-16,,2,0
OleLoad-q9vqzhqzeab-2,97,37,ExportRowsExported,export_the_data,MyProducer,1,2019-04-16,10,2,0
OleLoad-q9vqzhqzeab-2,98,37,ExportRowsRejected,export_the_data,MyProducer,1,2019-04-16,0,2,0
OleLoad-q9vqzhqzeab-2,126,1,DCCheckPointNo,export_the_data,DataConnOper,1,2019-04-16,0,1,0
OleLoad-q9vqzhqzeab-2,120,1,DCRowsWritten,export_the_data,DataConnOper,1,2019-04-16,10,1,0
OleLoad-q9vqzhqzeab-2,122,1,DCFilesWritten,export_the_data,DataConnOper,1,2019-04-16,1,1,0
OleLoad-q9vqzhqzeab-2,125,1,DCRowErrorNo,export_the_data,DataConnOper,1,2019-04-16,0,1,0
OleLoad-q9vqzhqzeab-2,124,5,DCFileName,export_the_data,DataConnOper,1,2019-04-16,C:\Work\Various Scripts\test.amj,1,0
OleLoad-q9vqzhqzeab-2,186,3,CPUTimeByInstance,export_the_data,MyProducer,1,2019-04-16,12.359375,2,0
OleLoad-q9vqzhqzeab-2,138,0,ExportSessEnd,export_the_data,MyProducer,1,2019-04-16,,2,0
OleLoad-q9vqzhqzeab-2,179,5,OperatorEndTS,export_the_data,MyProducer,1,2019-04-16,2019-04-16 16:12:41,2,0
OleLoad-q9vqzhqzeab-2,18,1,OperatorExit,export_the_data,MyProducer,1,2019-04-16,4,2,0

Private log producer_log:

 

===================================================================
= =
= TERADATA PARALLEL TRANSPORTER 32-BIT =
= =
= EXPORT OPERATOR VERSION 16.20.00.03 =
= =
= OPERATOR SUPPORT LIBRARY VERSION 16.20.00.03 =
= =
= COPYRIGHT 2001-2018, TERADATA CORPORATION. =
= ALL RIGHTS RESERVED. =
= =
= Process I.D.: 3860 =
= =
===================================================================

**** 16:11:10 Processing starting at: Tue Apr 16 16:11:10 2019

===================================================================
= =
= Module Identification =
= =
===================================================================

32-bit Export Operator for Windows on BUK30LAP4001018
ExportMain : 16.20.00.01
ExportCLI : 16.10.00.01
ExportUtil : 14.10.00.01
PcomCLI : 16.20.00.13
PcomMBCS : 14.10.00.02
PcomMsgs : 16.00.00.04
PcomNtfy : 15.10.00.01
PcomPx : 16.20.00.05
PcomUtil : 16.20.00.06
PXICU : 16.20.00.03
TDICU : 16.20.00.00
CLIv2 : 16.20.00.07

===================================================================
= =
= Attribute Definitions =
= =
===================================================================

**** 16:11:11 Options in effect for this job:
OperatorType: Producer
Instances: 1
Character set: 'UTF8'
Checkpoint: No checkpoint in effect
Notify: Not enabled
Unicode Pass Through: Not enabled
Tenacity: 4 hour limit to successfully connect
Sleep: 6 minute(s) between connect retries
Date format: INTEGERDATE
Blocksize: Maximum allowable
OutLimit: No limit in effect
Discard large row: Not enabled
SpoolMode: Spool

===================================================================
= =
= Column/Field Definition =
= =
===================================================================

Column Name Offset Length Type
============================== ======= ====== ========================
cust_no 0 4 DECIMAL(8,0)
============================== ======= ====== ========================
INDICATOR BYTES NEEDED: 1
EXPECTED RECORD LENGTH: 5

===================================================================
= =
= Control Session Connection =
= =
===================================================================

**** 16:11:11 Connecting to RDBMS: '*****'
**** 16:11:11 Connecting with UserId: '*****'

**** 16:11:11 Number of Query Band data bytes sent to the RDBMS: 118
**** 16:11:11 Current working DATABASE set: '*****'

===================================================================
= =
= Teradata Database Information =
= =
===================================================================

**** 16:11:11 Teradata Database Version: '16.10.02.14'
**** 16:11:11 Teradata Database Release: '16.10.02.11'
**** 16:11:11 Session character set: 'UTF8'
**** 16:11:11 Total AMPs available: 1152
**** 16:11:11 Data Encryption: supported
**** 16:11:11 NoSpool Export: supported
**** 16:11:11 Unicode Pass Through: supported
**** 16:11:11 Maximum request size supported: 1048500 bytes
**** 16:11:11 Maximum row size supported: 1000000 bytes
**** 16:11:11 Maximum message size supported: 7340032 bytes
**** 16:11:11 Enhanced Statement Status Level: 1
**** 16:11:11 Blocksize for this job: 1048472 bytes

===================================================================
= =
= Special Session Connection =
= =
===================================================================

**** 16:12:17 Maximum number of special sessions requested: All
**** 16:12:17 Minimum number of special sessions required: 1

Instance Assigned Connected Result
======== ======== ========= ======================
1 1152 299 CLI Error 301
======== ======== ========= ======================
Total 1152 299 Warning

===================================================================
= =
= Select Request =
= =
===================================================================

**** 16:12:18 This job is submitting the following request:

SELECT cust_no FROM test_oracle

**** 16:12:19 This job will run in the Spool Export mode.
**** 16:12:19 Select execution completed. 1 data blocks generated.

===================================================================
= =
= End Export Phase =
= =
===================================================================

**** 16:12:20 END EXPORT SUBMITTED
**** 16:12:20 END EXPORT COMPLETED

Total Records Exported From RDBMS = 10
Records exported by instance 1 = 10

Total Bytes Exported From RDBMS = 50

Total Records Discarded = 0
Records discarded by instance 1 = 0

**** 16:12:20 Export Phase statistics:
Elapsed time: 00:00:01 (hh:mm:ss)
CPU time: 0.8125 Second(s)
MB/sec: 0.000
MB/cpusec: 0.000

===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================

**** 16:12:25 Logging off all sessions

Instance Cpu Time
======== ================
1 12.36 Seconds

**** 16:12:41 Total processor time used = '12.3594 Second(s)'
. Start : Tue Apr 16 16:11:10 2019
. End : Tue Apr 16 16:12:41 2019
. Highest return code encountered = '4'.
**** 16:12:41 This job terminated

Private log consumer_log-1:


= TraceFunction: 'NO (defaulted)' (=0) =
==========================================================================
= =
= TERADATA PARALLEL TRANSPORTER 32-BIT =
= =
= DATACONNECTOR OPERATOR VERSION 16.20.00.03 =
= =
= DataConnector UTILITY LIBRARY VERSION 16.20.00.05 =
= =
= COPYRIGHT 2001-2018, Teradata Corporation. ALL RIGHTS RESERVED. =
= =
==========================================================================

Operator name: 'DataConnOper' instance 1 of 1 [Consumer]

**** 16:11:10 Processing starting at: Tue Apr 16 16:11:10 2019

==========================================================================
= =
= Operator module static specifics =
= =
= Operator module name:'dtacop', version:'16.20.00.03' =
= =
= pmdcomt_HeaderVersion: 'Common 16.00.00.02' - packing 'pack (push, 1)' =
= pmddamt_HeaderVersion: 'Common 16.00.00.01' - packing 'pack (push, 1)' =
= =
==========================================================================

==========================================================================
= =
= > General attribute Definitions < =
= =
= TraceLevel: '' =
= EndianFlip: 'NO (defaulted)' (=0) =
= IndicatorMode: 'YES' (=1) =
= NullColumns: 'YES (defaulted)' (=1) =
= SYSTEM_CharSetId: 'UTF8' =
= =
==========================================================================

LITTLE ENDIAN platform
Operator 'dtacop' main source version:'16.20.00.05'
DirInfo global variable name: 'DirInfo'
FileNames global variable name: 'FileNames'
DC_PREAD_SM_TOKENS global variable name: 'DC_PREAD_SM_TOKENS'

==========================================================================
= =
= > Operator attribute Definitions < =
= =
==========================================================================

FileList: 'NO (defaulted)' (=0)
MultipleReaders: 'NO (defaulted)' (=0)
RecordsPerBuffer: (use default calculation per schema)
Initializing with CharSet = 'UTF8'.
Alphabetic CSName=UTF8
Established character set UTF8
Multi-byte character set in use
AccessModuleName: 'Oledb_Axsmod'
WARNING! Access module will not be called for checkpoint support.
AccessModuleInitStr: 'noprompt jobid=1'

==========================================================================
= =
= Module Identification =
= =
==========================================================================

32-bit DC Operator for Windows on BUK30LAP4001018
TDICU................................... 16.20.00.00
PXICU................................... 16.20.00.03
Appending access module suffix:.dll
Loading AM:Oledb_Axsmod.dll
PMPROCS................................. 16.00.00.07
PMRWFMT................................. 16.20.00.01
PMTRCE.................................. 16.00.00.01
PMMM.................................... 15.10.00.03
DCUDDI.................................. 16.20.00.04
PMHEXDMP................................ 16.00.00.02
PMHDFSDSK............................... 16.00.00.01
Oledb_Axsmod.dll........................ 16.20.0.0
Oledb_Axsmodenu.DLL..................... 16.20.0.0

Sending to access module: attribute 'TBR_OP_HANDLE'=x'15bd068'
Access module rc=33
WARNING! pmAPutAttr returned 'Unrecognized attribute name' (33)
Sending to access module: attribute 'INSTANCE_NUMBERS'=[1,1]
Access module rc=33
WARNING! pmAPutAttr returned 'Unrecognized attribute name' (33)
Sending to access module: attribute 'CHARSET_NAME'='UTF8'
Sending to access module: attribute 'PRESERVE_RESTART_INFO'='YES'
Access module rc=33
WARNING! pmAPutAttr returned 'Unrecognized attribute name' (33)
>> Enter DC_DataConFileInfo
Job Type=0
WARNING! OpenMode attribute not specified, default 'Write' being used.
UseGeneralUDDIcase: 'NO (defaulted)' (=0)
WriteBOM: 'NO (defaulted)' (=0)
AcceptExcessColumns: 'NO (defaulted)' (=0)
AcceptMissingColumns: 'NO (defaulted)' (=0)
TruncateColumnData: 'NO (defaulted)' (=0)
TruncateColumns: 'NO (defaulted)' (=0)
TruncateLongCols: 'NO (defaulted)' (=0)
WARNING! RecordErrorFilePrefix attribute not specified, there is no default
RecordErrorVerbosity: OFF (default) (=0)
FileName: 'C:\Work\Various Scripts\test.amj'
OpenMode: 'WRITE' (2)
Format: 'FORMATTED' (3)
Data Type Ind Length Offset M Name
DECIMAL ( 4) 1 4 0 N cust_no
Schema is not all character data
Schema is compatible with delimited data
Validating parsing case: 2200000.
MBCS (QUOTED DATA: No), Delimiter[0]: ''
Delimiter: x''
Escape Delimiter: x''
Open Quote: x''
Close Quote: x''
Escape Quote: x''
IOBufferSize: 1048586

Full File Path: C:\Work\Various Scripts\test.amj
UTF8 File Flag: 0
Data Type Ind Length Offset M Name
DECIMAL ( 4) 1 4 0 N cust_no
Schema is not all character data
Schema is compatible with delimited data
Validating parsing case: 2200000.
MBCS (QUOTED DATA: No), Delimiter[0]: ''
Delimiter: x''
Escape Delimiter: x''
Open Quote: x''
Close Quote: x''
Escape Quote: x''
==========================================================================
= =
= > Log will include stats only < =
= =
==========================================================================
WARNING! Overwriting existing file 'C:\Work\Various Scripts\test.amj' (size 0).
**** 16:11:16 Starting to send rows to file 'C:\Work\Various Scripts\test.amj'
AllowBufferMode: 'YES (defaulted)' (=1)
**** 16:12:25 Finished sending rows to C:\Work\Various Scripts\test.amj (index 1)
Rows sent: 10, (size: 0) CPU Time: 74.69 Seconds
Sending stat to infrastructure: DCCheckPointNo=0
Sending stat to infrastructure: DCRowsWritten=10
Sending stat to infrastructure: DCFilesWritten=1
Sending stat to infrastructure: DCRowErrorNo=0
Sending stat to infrastructure: DCFileName='C:\Work\Various Scripts\test.amj'
Files written by this instance: 1
**** 16:12:25 Total processor time used = '74.69 Seconds(s)'
**** 16:12:25 Total files processed: 1

 

 

######################

 

1 REPLY 1
Teradata Employee

Re: Data load from Teradata to Oracle using OleLoad

Looks like the DC operator sent the data to the file you provided in the FileName attribute, and not to the access module.

Try removing the FileName attribute and see what happens.

 

-- SteveF