All Forums Tools
boriscb 22 posts Joined 09/13
27 Nov 2013
TPT load script fails with incompatible message

Hi,
Your advice with the following will be greatly appreciated.
I am using the TTU 14.10 set of tools with a Teradata DB 14.0.2.11
With the OLELoad tool, The Fastload utility works perfectly but for some reason the TPT utility fails with the following message:
"Teradata OleLoad has detected a problem in the request from the calling software "execute.exe". It is possible that the calling software is incompatible with the access module"
Is there a way around this problem ?... Would using TTU 13.x resolve this problem ?... If so, what is the download URL for TTU 13.x ?... (I looked everywhere for it)....
Thank you for your time.
Boris. (boris.cb@weareperitas.com)
 
 
 
 

feinholz 1234 posts Joined 05/08
04 Dec 2013

Never seen that message before.
The OLE-DB Access module has no knowledge of who is calling it (that I know of).
Please reply with the full TPT script.
Thanks!
 

--SteveF

SuSeSi 61 posts Joined 10/08
05 Dec 2013

Hi Boris,
Should not be problem while using TPT.
Can you please provide more details on the problem to get reproduced.
> Was the import job submitted using OleLoad tool or it was executed in batch mode?
> Please provide full TPT script.
> What is the source database and how it was connected.
> Was the .amj file saved before used in TPT script?
> Was the TPT script created separately/manually, or the scipt was created using OleLoad tool?
 
Thanks !!
-Sudhansu
 

-Sudhansu

boriscb 22 posts Joined 09/13
10 Jan 2014

Hi Sudhansu,
I desperately need your help with this. I am new to TPT so I am not sure what to do here. Your assistance is greatly appreciated.
Below are the result lines from running the TPT script created by OLELoad (Fastload runs with no problem for the same tables in this wizard).

Teradata Parallel Transporter Version 14.10.00.02

Job log: C:\Program Files\Teradata\client\14.10\Teradata Parallel Transporter/logs/OleLoad-yae620yg

Job id is OleLoad-yae620yg2t-29, running on DG3

Teradata Parallel Transporter SQL DDL Operator Version 14.10.00.02

DDLOperator: private log specified: ddl_log

DDLOperator: connecting sessions

DDLOperator: sending SQL requests

DDLOperator: disconnecting sessions

DDLOperator: Total processor time used = '0.109375 Second(s)'

DDLOperator: Start : Fri Jan 10 14:12:54 2014

DDLOperator: End   : Fri Jan 10 14:12:57 2014

Job step create_the_table completed successfully

Teradata Parallel Transporter Load Operator Version 14.10.00.02

MyConsumer: private log specified: consumer_log

Teradata Parallel Transporter DataConnOper: TPT19006 Version 14.10.00.02

DataConnOper Instance 1 directing private log report to 'producer_log-1'.

DataConnOper: TPT19003 NotifyMethod: 'None (default)'

DataConnOper: TPT19008 DataConnector Producer operator Instances: 1

MyConsumer: connecting sessions

MyConsumer: preparing target table

MyConsumer: entering Acquisition Phase

DataConnOper: TPT19003 ECI operator ID: DataConnOper-9768

DataConnOper: TPT19127 WARNING file 'Untitled' not processed.

 

DataConnOper: TPT19003 The system cannot find the file specified.

 

DataConnOper: TPT19003 TPT Exit code set to 12.

DataConnOper: TPT19221 Total files processed: 0.

MyConsumer: disconnecting sessions

MyConsumer: Total processor time used = '0.84375 Second(s)'

MyConsumer: Start : Fri Jan 10 14:13:01 2014

MyConsumer: End   : Fri Jan 10 14:13:42 2014

Job step load_the_data terminated (status 12)

Job OleLoad-yae620yg2t terminated (status 12)

Job start: Fri Jan 10 14:12:53 2014

Job end:   Fri Jan 10 14:13:42 2014
This is the script generated by the wizard:

SET MyTdpId='xxx.xx.x.x';

SET MyUserName='xxxxxx';

SET MyPassword='xxxxx';

SET MyDatabase='Dev_DBTEST';

USING CHAR SET UTF8

DEFINE JOB MyJob

(

  DEFINE SCHEMA MySchema

  (

    WorkflowId              INTEGER,

    "Name"                  VARCHAR(150),

    WorkflowTypeId          INTEGER,

    WorkflowTypeServiceName VARCHAR(3000),

    IsCurrent               BYTEINT

  );

  DEFINE OPERATOR DDLOperator()

  TYPE DDL

  ATTRIBUTES

  (

    VARCHAR PrivateLogName = 'ddl_log',

    VARCHAR TdpId = @MyTdpId,

    VARCHAR UserName = @MyUserName,

    VARCHAR UserPassword = @MyPassword,

    VARCHAR WorkingDatabase = @MyDatabase

  );

  DEFINE OPERATOR DataConnOper()

  TYPE DATACONNECTOR PRODUCER

  SCHEMA MySchema

  ATTRIBUTES

  (

    VARCHAR AccessModuleName = 'Oledb_Axsmod',

    VARCHAR AccessModuleInitStr = 'noprompt jobid=1',

    VARCHAR FileName = 'Untitled',

    VARCHAR Format = 'Formatted',

    VARCHAR EnableScan = 'No',

    VARCHAR IndicatorMode = 'Yes',

    VARCHAR PrivateLogName = 'producer_log'

  );

  DEFINE OPERATOR MyConsumer()

  TYPE LOAD

  SCHEMA MySchema

  ATTRIBUTES

  (

    VARCHAR DateForm = 'IntegerDate',

    VARCHAR ErrorTable1 = 'Workflow_errors1',

    VARCHAR ErrorTable2 = 'Workflow_errors2',

    VARCHAR LogTable = '"Dev_DBTEST"."Workflow_Log"',

    VARCHAR PrivateLogName = 'consumer_log',

    VARCHAR TargetTable = '"Workflow"',

    VARCHAR TdpId = @MyTdpId,

    VARCHAR UserName = @MyUserName,

    VARCHAR UserPassword = @MyPassword,

    VARCHAR WorkingDatabase = @MyDatabase

  );

  STEP create_the_table

  (

    APPLY

    ('CREATE MULTISET TABLE "Workflow" ( WorkflowId              INTEGER NOT NULL ,

                                         "Name"                  VARCHAR(50) CHARACTER SET UNICODE NOT NULL CASESPECIFIC  ,

                                         WorkflowTypeId          INTEGER NOT NULL ,

                                         WorkflowTypeServiceName VARCHAR(1000) CHARACTER SET UNICODE NOT NULL CASESPECIFIC  ,

                                         IsCurrent               BYTEINT NOT NULL );')

      TO OPERATOR (DDLOperator);

  );

  STEP load_the_data

  (

    APPLY

    ('INSERT INTO "Workflow" ( :WorkflowId, :"Name", :WorkflowTypeId, 

                               :WorkflowTypeServiceName, :IsCurrent );')

      TO OPERATOR (MyConsumer)

      SELECT * FROM OPERATOR (DataConnOper);

  );

);
The error dialog that pops-up a few times is:
Oledb_axsmod
Teradata OleLoad has detected a problem in the request from the calling software, “executor.exe”. It is possible that the calling software version is incompatible with this access module.
 
THANK YOU
 
Boris.

SuSeSi 61 posts Joined 10/08
13 Jan 2014

Hi Boris,
Are you using 64bit of TPT with 32 bit OleLoad? Please use 32bit TPT along with 32bit OleLoad.
Additionally, Can you please generate TPT trace file by adding following lines in the OleLoad generated script?
VARCHAR TraceLevel            = 'ALL'
 

-Sudhansu

boriscb 22 posts Joined 09/13
14 Jan 2014

Hi,
Thank you for your assistance with this...
Using the Teradata Parallel Transporter wizard (instead of the OLELoad) , I have tried both MSSQL ODBC and DataDirect ODBC 32 bits. 64 bits gives me an imcompatible message right away... But I get the following Job output failure report with any of the 32 bit ODBC DNS connections:
I don't know what else to look for anymore ... 

Teradata Parallel Transporter Version 14.10.00.02

Job log: C:\Program Files (x86)\Teradata\client\14.10\Teradata Parallel Transporter/logs/JOBWorkflow4-8.out

Job id is JOBWorkflow4-8, running on WAREHOUSEBUILD1

Teradata Parallel Transporter Load Operator Version 14.10.00.02

W_1_o_Workflow: private log not specified

Teradata Parallel Transporter ODBC Operator Version 14.10.00.02

W_0_o_Workflow: private log not specified

W_0_o_Workflow: connecting sessions

W_0_o_Workflow: TPT17176: Info: Message received from ODBC driver:

STATE=01000, CODE=5701,

MSG='[Microsoft][SQL Server Native Client 10.0][SQL Server]Changed database context to 'DEV_DB'.' 

W_0_o_Workflow: TPT17176: Info: Message received from ODBC driver:

STATE=01000, CODE=5703,

MSG='[Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language setting to us_english.' 

W_0_o_Workflow: TPT17175: Warning: Message received from ODBC driver:

STATE=S1092, CODE=0,

MSG='[Microsoft][SQL Server Native Client 10.0]Invalid attribute/option identifier' 

W_1_o_Workflow: connecting sessions

W_1_o_Workflow: preparing target table

W_1_o_Workflow: entering Acquisition Phase

W_1_o_Workflow: TPT10508: RDBMS error 3857: Cannot use value (or macro parameter) to match 'Name_6'.

W_1_o_Workflow: disconnecting sessions

W_1_o_Workflow: Total processor time used = '2.03125 Second(s)'

W_1_o_Workflow: Start : Tue Jan 14 08:44:00 2014

W_1_o_Workflow: End   : Tue Jan 14 08:44:08 2014

W_0_o_Workflow: disconnecting sessions

W_0_o_Workflow: Total processor time used = '0.0625 Second(s)'

W_0_o_Workflow: Start : Tue Jan 14 08:44:00 2014

W_0_o_Workflow: End   : Tue Jan 14 08:44:08 2014

Job step MAIN_STEP terminated (status 12)

Job JOBWorkflow4 terminated (status 12)

Job start: Tue Jan 14 08:43:59 2014

Job end:   Tue Jan 14 08:44:08 2014

 

 
The Job script:

/* 1 */  

/* 2 */  

/* 3 */  DEFINE JOB Workflow

/* 4 */  (

/* 5 */   DEFINE OPERATOR W_1_o_Workflow

/* 6 */   TYPE LOAD

/* 7 */   SCHEMA *

/* 8 */   ATTRIBUTES

/* 9 */   (

/* 10 */   VARCHAR UserName, 

/* 11 */   VARCHAR UserPassword, 

/* 12 */   VARCHAR LogTable, 

/* 13 */   VARCHAR TargetTable, 

/* 14 */   INTEGER BufferSize, 

/* 15 */   INTEGER ErrorLimit, 

/* 16 */   INTEGER MaxSessions, 

/* 17 */   INTEGER MinSessions, 

/* 18 */   INTEGER TenacityHours, 

/* 19 */   INTEGER TenacitySleep, 

/* 20 */   VARCHAR AccountID, 

/* 21 */   VARCHAR DateForm, 

/* 22 */   VARCHAR ErrorTable1, 

/* 23 */   VARCHAR ErrorTable2, 

/* 24 */   VARCHAR NotifyExit, 

/* 25 */   VARCHAR NotifyExitIsDLL, 

/* 26 */   VARCHAR NotifyLevel, 

/* 27 */   VARCHAR NotifyMethod, 

/* 28 */   VARCHAR NotifyString, 

/* 29 */   VARCHAR PauseAcq, 

/* 30 */   VARCHAR PrivateLogName, 

/* 31 */   VARCHAR TdpId, 

/* 32 */   VARCHAR TraceLevel, 

/* 33 */   VARCHAR WorkingDatabase

/* 34 */   );

/* 35 */  

/* 36 */   DEFINE SCHEMA W_0_s_Workflow

/* 37 */   (

/* 38 */   WorkflowId INTEGER,

/* 39 */   Name_3 VARCHAR(50),

/* 40 */   WorkflowTypeId INTEGER,

/* 41 */   WorkflowTypeServiceName VARCHAR(1000),

/* 42 */   IsCurrent BYTEINT

/* 43 */   );

/* 44 */  

/* 45 */   DEFINE OPERATOR W_0_o_Workflow

/* 46 */   TYPE ODBC

/* 47 */   SCHEMA W_0_s_Workflow

/* 48 */   ATTRIBUTES

/* 49 */   (

/* 50 */   VARCHAR UserName, 

/* 51 */   VARCHAR UserPassword, 

/* 52 */   VARCHAR SelectStmt, 

/* 53 */   VARCHAR PrivateLogName, 

/* 54 */   VARCHAR DSNName, 

/* 55 */   VARCHAR ConnectString, 

/* 56 */   VARCHAR TruncateData

/* 57 */   );

/* 58 */  

/* 59 */   APPLY

/* 60 */   (

/* 61 */   'INSERT INTO Dev_DB_LAND.Workflow (WorkflowId,Name,WorkflowTypeId,WorkflowTypeServiceName,IsCurrent) VALUES (:WorkflowId,:Name_4,:WorkflowTypeId,:WorkflowTypeServiceName,:IsCurrent);'

/* 62 */   )

/* 63 */   TO OPERATOR

/* 64 */   (

/* 65 */   W_1_o_Workflow[1]

/* 66 */  

/* 67 */   ATTRIBUTES

/* 68 */   (

/* 69 */   UserName = @TeradataDestinationUser, 

/* 70 */   UserPassword = @TeradataDestinationPassword, 

/* 71 */   LogTable = 'Dev_DB_LAND.Workflow_log', 

/* 72 */   TargetTable = 'Dev_DB_LAND.Workflow', 

/* 73 */   TdpId = '172.xx.xx.x'

/* 74 */   )

/* 75 */   )

/* 76 */   SELECT * FROM OPERATOR

/* 77 */   (

/* 78 */   W_0_o_Workflow[1]

/* 79 */  

/* 80 */   ATTRIBUTES

/* 81 */   (

/* 82 */   UserName = @OdbcSourceUser, 

/* 83 */   UserPassword = @OdbcSourcePassword, 

/* 84 */   SelectStmt = 'SELECT WorkflowId,Name,WorkflowTypeId,WorkflowTypeServiceName,IsCurrent FROM DEV_DB.App.Workflow;', 

/* 85 */   DSNName = 'SQL Server MS Client'

/* 86 */   )

/* 87 */   );

/* 88 */  );
 

feinholz 1234 posts Joined 05/08
14 Jan 2014

The error you are receiving is this:
 
TPT10508: RDBMS error 3857: Cannot use value (or macro parameter) to match 'Name_6'.
 
(the other messages are warnings because you are using a non-DataDirect driver).
 
Looks like your INSERT statement is not valid for the table you are loading.
 
What is the DDL for the target table?

--SteveF

boriscb 22 posts Joined 09/13
14 Jan 2014

Hi,
 
Thank you for your feedback. I have also tried to exclude the "Name" column as it seems like it is a reserved word for Teradata ?... but it still gives me the following error:
 

Teradata Parallel Transporter Version 14.10.00.02

Job log: C:\Program Files (x86)\Teradata\client\14.10\Teradata Parallel Transporter/logs/JOBWorkflow7-12.out

Job id is JOBWorkflow7-12, running on WAREHOUSEBUILD1

Found CheckPoint file: C:\Program Files (x86)\Teradata\client\14.10\Teradata Parallel Transporter/checkpoint\JOBWorkflow7LVCP

This is a restart job; it restarts at step MAIN_STEP.

Teradata Parallel Transporter ODBC Operator Version 14.10.00.02

Teradata Parallel Transporter Load Operator Version 14.10.00.02

W_0_o_Workflow: private log not specified

W_1_o_Workflow: private log not specified

W_0_o_Workflow: connecting sessions

W_0_o_Workflow: TPT17176: Info: Message received from ODBC driver:

STATE=01000, CODE=5701,

MSG='[Microsoft][SQL Server Native Client 10.0][SQL Server]Changed database context to 'DEV_DB'.' 

W_0_o_Workflow: TPT17176: Info: Message received from ODBC driver:

STATE=01000, CODE=5703,

MSG='[Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language setting to us_english.' 

W_0_o_Workflow: TPT17175: Warning: Message received from ODBC driver:

STATE=S1092, CODE=0,

MSG='[Microsoft][SQL Server Native Client 10.0]Invalid attribute/option identifier' 

W_1_o_Workflow: connecting sessions

W_1_o_Workflow: preparing target table

W_1_o_Workflow: entering Acquisition Phase

W_0_o_Workflow: sending SELECT request

W_0_o_Workflow: TPT15111: Error 19 allocating memory for data buffer

W_0_o_Workflow: disconnecting sessions

W_1_o_Workflow: disconnecting sessions

W_0_o_Workflow: Total processor time used = '0.03125 Second(s)'

W_0_o_Workflow: Start : Tue Jan 14 09:17:10 2014

W_0_o_Workflow: End   : Tue Jan 14 09:17:17 2014

W_1_o_Workflow: Total processor time used = '1.89063 Second(s)'

W_1_o_Workflow: Start : Tue Jan 14 09:17:10 2014

W_1_o_Workflow: End   : Tue Jan 14 09:17:19 2014

Job step MAIN_STEP terminated (status 12)

Job JOBWorkflow7 terminated (status 12)

Job start: Tue Jan 14 09:17:07 2014

Job end:   Tue Jan 14 09:17:19 2014

 

 

Below is the DDL for the table in Teradata:

 

CREATE MULTISET TABLE Dev_DB_LAND.Workflow ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      WorkflowId INTEGER NOT NULL,

      Name VARCHAR(50) CHARACTER SET UNICODE CASESPECIFIC NOT NULL,

      WorkflowTypeId INTEGER NOT NULL,

      WorkflowTypeServiceName VARCHAR(1000) CHARACTER SET UNICODE CASESPECIFIC NOT NULL,

      IsCurrent BYTEINT NOT NULL)

PRIMARY INDEX ( WorkflowId );

 

 

Below is the script: I cannot see what could be wrong with this....

 

/* 1 */  

/* 2 */  

/* 3 */  DEFINE JOB Workflow

/* 4 */  (

/* 5 */   DEFINE OPERATOR W_1_o_Workflow

/* 6 */   TYPE LOAD

/* 7 */   SCHEMA *

/* 8 */   ATTRIBUTES

/* 9 */   (

/* 10 */   VARCHAR UserName, 

/* 11 */   VARCHAR UserPassword, 

/* 12 */   VARCHAR LogTable, 

/* 13 */   VARCHAR TargetTable, 

/* 14 */   INTEGER BufferSize, 

/* 15 */   INTEGER ErrorLimit, 

/* 16 */   INTEGER MaxSessions, 

/* 17 */   INTEGER MinSessions, 

/* 18 */   INTEGER TenacityHours, 

/* 19 */   INTEGER TenacitySleep, 

/* 20 */   VARCHAR AccountID, 

/* 21 */   VARCHAR DateForm, 

/* 22 */   VARCHAR ErrorTable1, 

/* 23 */   VARCHAR ErrorTable2, 

/* 24 */   VARCHAR NotifyExit, 

/* 25 */   VARCHAR NotifyExitIsDLL, 

/* 26 */   VARCHAR NotifyLevel, 

/* 27 */   VARCHAR NotifyMethod, 

/* 28 */   VARCHAR NotifyString, 

/* 29 */   VARCHAR PauseAcq, 

/* 30 */   VARCHAR PrivateLogName, 

/* 31 */   VARCHAR TdpId, 

/* 32 */   VARCHAR TraceLevel, 

/* 33 */   VARCHAR WorkingDatabase

/* 34 */   );

/* 35 */  

/* 36 */   DEFINE SCHEMA W_0_s_Workflow

/* 37 */   (

/* 38 */   WorkflowId INTEGER,

/* 39 */   WorkflowTypeId INTEGER,

/* 40 */   WorkflowTypeServiceName VARCHAR(1000),

/* 41 */   IsCurrent BYTEINT

/* 42 */   );

/* 43 */  

/* 44 */   DEFINE OPERATOR W_0_o_Workflow

/* 45 */   TYPE ODBC

/* 46 */   SCHEMA W_0_s_Workflow

/* 47 */   ATTRIBUTES

/* 48 */   (

/* 49 */   VARCHAR UserName, 

/* 50 */   VARCHAR UserPassword, 

/* 51 */   VARCHAR SelectStmt, 

/* 52 */   VARCHAR PrivateLogName, 

/* 53 */   VARCHAR DSNName, 

/* 54 */   VARCHAR ConnectString, 

/* 55 */   VARCHAR TruncateData

/* 56 */   );

/* 57 */  

/* 58 */   APPLY

/* 59 */   (

/* 60 */   'INSERT INTO Dev_DB_LAND.Workflow (WorkflowId,WorkflowTypeId,WorkflowTypeServiceName,IsCurrent) VALUES (:WorkflowId,:WorkflowTypeId,:WorkflowTypeServiceName,:IsCurrent);'

/* 61 */   )

/* 62 */   TO OPERATOR

/* 63 */   (

/* 64 */   W_1_o_Workflow[1]

/* 65 */  

/* 66 */   ATTRIBUTES

/* 67 */   (

/* 68 */   UserName = 'xxxxx', 

/* 69 */   UserPassword = 'xxxxx', 

/* 70 */   LogTable = 'DEV_DB_LAND.Workflow_log', 

/* 71 */   TargetTable = 'DEV_DB_LAND.Workflow', 

/* 72 */   TdpId = '172.xx.xx.x'

/* 73 */   )

/* 74 */   )

/* 75 */   SELECT * FROM OPERATOR

/* 76 */   (

/* 77 */   W_0_o_Workflow[1]

/* 78 */  

/* 79 */   ATTRIBUTES

/* 80 */   (

/* 81 */   UserName = 'xxxxxx', 

/* 82 */   UserPassword = 'xxxxx', 

/* 83 */   SelectStmt = 'SELECT WorkflowId,WorkflowTypeId,WorkflowTypeServiceName,IsCurrent FROM DEV_DB.App.Workflow;', 

/* 84 */   DSNName = 'SQL Server MS Client'

/* 85 */   )

/* 86 */   );

/* 87 */  );

 

boriscb 22 posts Joined 09/13
15 Jan 2014

Hello,
 
I am now considering using MLOAD to import data directly from MSSQL to Teradata.

  1. Can MLOAD be used to run a Select statement from MSSQL to import directly to a Teradata table ?
  2. Where could I find an example of that script please ?...

Thank you for your assistance.
 
Boris.

feinholz 1234 posts Joined 05/08
15 Jan 2014

No. MLOAD does not support that functionality.
You will need to use TPT.
 

--SteveF

SuSeSi 61 posts Joined 10/08
16 Jan 2014

Hi Boris,

 

With the error message, I think you have to first save the amj file by clicking File-> Save As button in OleLoad GUI menu option. Then please re-create the problem with OLE DB Access Module. Add foolowing line in generated TPT script at ATTRIBUTES section of DataConnOper().

 

, VARCHAR TraceLevel            = 'ALL'

 

After the job is completed or failed. note down the job id at the start of the tpt log. Then open a separate  command prompt and give following command. This will generate the trace. Please remove sensitive information and post the trace file.

 

tlogview -j <job-id> -f producer_log-1 -g

 

 

 

 

-Sudhansu

boriscb 22 posts Joined 09/13
16 Jan 2014

Hi,
Thank you again for your time in looking into this for me. It is greatly appreciated !...
Below is the result of the tlogview command as requested:

 

C:\Program Files\Teradata\Client\14.10\Teradata Parallel Transporter\logs>tlogview -j OleLoad-e2f60hz93t-53 -f producer_log-1 -g

 

Private log producer_log-1:

 

 

     =                  TraceFunction: 'NO (defaulted)' (=0)                  =

     ==========================================================================

     =                                                                        =

     =                     TERADATA PARALLEL TRANSPORTER                      =

     =                                                                        =

     =              DATACONNECTOR OPERATOR VERSION  14.10.00.02               =

     =                                                                        =

     =           DataConnector UTILITY LIBRARY VERSION 14.10.00.43            =

     =                                                                        =

     =    COPYRIGHT 2001-2011, Teradata Corporation.  ALL RIGHTS RESERVED.    =

     =                                                                        =

     ==========================================================================

 

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

 

**** 11:44:06 Processing starting at: Thu Jan 16 11:44:06 2014

 

     ==========================================================================

     =                                                                        =

     =                    Operator module static specifics                    =

     =                                                                        =

     =                 Compiled for platform: '32-bit WIN64'                  =

     =          Operator module name:'dtacop', version:'14.10.00.02'          =

     =                                                                        =

     = pmdcomt_HeaderVersion: 'Common 14.00.00.06' - packing 'pack (push, 1)' =

     =      pmddamt_HeaderVersion: 'Common 13.10.00.01' - packing 'none'      =

     =                                                                        =

     ==========================================================================

 

     ==========================================================================

     =                                                                        =

     =                   > General attribute Definitions <                    =

     =                                                                        =

     =                           TraceLevel: 'ALL'                            =

     =                   EndianFlip: 'NO (defaulted)' (=0)                    =

     =                       IndicatorMode: 'YES' (=1)                        =

     =                  NullColumns: 'YES (defaulted)' (=1)                   =

     =                        SYSTEM_CharSetId: 'UTF8'                        =

     =                                                                        =

     ==========================================================================

 

     LITTLE ENDIAN platform

     WARNING!  NotifyMethod: 'None (default)'

     Operator 'dtacop' main source version:'14.10.00.20'

 

     ==========================================================================

     =                                                                        =

     =                   > Operator attribute Definitions <                   =

     =                                                                        =

     ==========================================================================

 

     DirectoryPath defaulting to: 'C:\Teradata_load_scripts\Utilities\TPT'

     FileList: 'NO (defaulted)' (=0)

     MultipleReaders: 'NO (defaulted)' (=0)

     EnableScan: 'NO'

     pmInit entry <<<<

     Initializing with CharSet = 'UTF8'.

     Alphabetic CSName=UTF8

     comparing: 'UTF8' with 'ASCII'

     comparing: 'UTF8' with 'LATIN1250_1A0'

     Established character set UTF8

     Multi-byte character set in use

     ReturnCode=0

     AccessModuleName: 'Oledb_Axsmod'

     WARNING!  Access module will not be called for checkpoint support.

     AccessModuleInitStr: 'noprompt jobid=1'

 

     ==========================================================================

     =                                                                        =

     =                       > Module Identification <                        =

     =                                                                        =

     ==========================================================================

 

     Windows on WAREHOUSEBUILD1

     TDICU................................... 14.10.00.00

     PXICU................................... 14.10.00.02

     pmAttach entry <<<<

     Initializing Access Module=Oledb_Axsmod

     Appending access module suffix:.dll

     Loading AM:Oledb_Axsmod.dll

     attached Access Module, PIDM_LIB_pointer=x'30000000'

     calling PIDMMain via COMM_WITH_AM

     Parameter block

hex: Hexadecimal formatted display from address 033A2440 for 832 bytes.

hex:  0000  41 58 53 4D.4F 44 20 62.6C 6F 63 6B.3A 49 6E 69  *AXSMOD block:Ini*

hex:  0010  74 5F 74 00.00 00 00 00.00 00 00 00.00 00 00 00  *t_t.............*

hex:  0020  40 03 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *@...............*

hex:  0030  E8 03 D0 07.0E 00 00 00.10 00 00 00.55 6E 6B 6E  *............Unkn*

hex:  0040  6F 77 6E 20.43 6C 69 65.6E 74 00 00.00 00 00 00  *own Client......*

hex:  0050  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  ....

hex:  0130  00 00 00 00.00 00 00 00.00 00 00 00.6E 6F 70 72  *............nopr*

hex:  0140  6F 6D 70 74.20 6A 6F 62.69 64 3D 31.00 00 00 00  *ompt jobid=1....*

hex:  0150  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  ....

hex:  0330  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

     PIDMMain rc=0

     pmGetID entry <<<<

     calling PIDMMain via COMM_WITH_AM

     Parameter block

hex: Hexadecimal formatted display from address 033A29C0 for 108 bytes.

hex:  0000  41 58 53 4D.4F 44 20 62.6C 6F 63 6B.3A 49 44 5F  *AXSMOD block:ID_*

hex:  0010  74 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *t...............*

hex:  0020  6C 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *l...............*

hex:  0030  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  ....

hex:  0060  00 00 00 00.00 00 00 00.00 00 00 00              *............    *

     PIDMMain rc=0

     PMPROCS................................. 14.10.00.04

     PMRWFMT................................. 14.10.00.03

     PMTRCE.................................. 13.00.00.02

     PMMM.................................... 03.00.00.01

     DCUDDI.................................. 14.10.00.37

     PMHEXDMP................................ 14.10.00.01

     ........................................

 

     Sending to access module: attribute 'TBR_OP_HANDLE'=x'80da60'

     pmAPutAttr entry <<<<

     Attribute Name

hex: Hexadecimal formatted display from address 001D51D0 for 13 bytes.

hex:  0000  54 42 52 5F.4F 50 5F 48.41 4E 44 4C.45           *TBR_OP_HANDLE   *

     Attribute Value

hex: Hexadecimal formatted display from address 001D5D80 for 8 bytes.

hex:  0000  60 DA 80 00.00 00 00 00                          *`.......        *

     calling PIDMMain via COMM_WITH_AM

     Parameter block

hex: Hexadecimal formatted display from address 033A2C70 for 568 bytes.

hex:  0000  41 58 53 4D.4F 44 20 62.6C 6F 63 6B.3A 41 74 74  *AXSMOD block:Att*

hex:  0010  72 5F 74 00.00 00 00 00.00 00 00 00.00 00 00 00  *r_t.............*

hex:  0020  38 02 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *8...............*

hex:  0030  0D 00 00 00.54 42 52 5F.4F 50 5F 48.41 4E 44 4C  *....TBR_OP_HANDL*

hex:  0040  45 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *E...............*

hex:  0050  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  ....

hex:  0130  00 00 00 00.08 00 00 00.60 DA 80 00.00 00 00 00  *........`.......*

hex:  0140  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  ....

hex:  0230  00 00 00 00.00 00 00 00                          *........        *

     PIDMMain rc=0

     Access module rc=0

     Sending to access module: attribute 'CHARSET_NAME'='UTF8'

     pmAPutAttr entry <<<<

     Attribute Name

hex: Hexadecimal formatted display from address 001D5200 for 12 bytes.

hex:  0000  43 48 41 52.53 45 54 5F.4E 41 4D 45              *CHARSET_NAME    *

     Attribute Value

hex: Hexadecimal formatted display from address 03440CE0 for 4 bytes.

hex:  0000  55 54 46 38                                      *UTF8            *

     calling PIDMMain via COMM_WITH_AM

     Parameter block

hex: Hexadecimal formatted display from address 033A2C70 for 568 bytes.

hex:  0000  41 58 53 4D.4F 44 20 62.6C 6F 63 6B.3A 41 74 74  *AXSMOD block:Att*

hex:  0010  72 5F 74 00.00 00 00 00.00 00 00 00.00 00 00 00  *r_t.............*

hex:  0020  38 02 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *8...............*

hex:  0030  0C 00 00 00.43 48 41 52.53 45 54 5F.4E 41 4D 45  *....CHARSET_NAME*

hex:  0040  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  ....

hex:  0130  00 00 00 00.04 00 00 00.55 54 46 38.00 00 00 00  *........UTF8....*

hex:  0140  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  ....

hex:  0230  00 00 00 00.00 00 00 00                          *........        *

     PIDMMain rc=0

     Access module rc=0

     Sending to access module: attribute 'PRESERVE_RESTART_INFO'='YES'

     pmAPutAttr entry <<<<

     Attribute Name

hex: Hexadecimal formatted display from address 001D5200 for 21 bytes.

hex:  0000  50 52 45 53.45 52 56 45.5F 52 45 53.54 41 52 54  *PRESERVE_RESTART*

hex:  0010  5F 49 4E 46.4F                                   *_INFO           *

     Attribute Value

hex: Hexadecimal formatted display from address 001D5D88 for 3 bytes.

hex:  0000  59 45 53                                         *YES             *

     calling PIDMMain via COMM_WITH_AM

     Parameter block

hex: Hexadecimal formatted display from address 033A2C70 for 568 bytes.

hex:  0000  41 58 53 4D.4F 44 20 62.6C 6F 63 6B.3A 41 74 74  *AXSMOD block:Att*

hex:  0010  72 5F 74 00.00 00 00 00.00 00 00 00.00 00 00 00  *r_t.............*

hex:  0020  38 02 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *8...............*

hex:  0030  15 00 00 00.50 52 45 53.45 52 56 45.5F 52 45 53  *....PRESERVE_RES*

hex:  0040  54 41 52 54.5F 49 4E 46.4F 00 00 00.00 00 00 00  *TART_INFO.......*

hex:  0050  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  ....

hex:  0130  00 00 00 00.03 00 00 00.59 45 53 00.00 00 00 00  *........YES.....*

hex:  0140  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  ....

hex:  0230  00 00 00 00.00 00 00 00                          *........        *

     PIDMMain rc=0

     Access module rc=0

     WARNING!  OpenMode attribute not specified, default 'Read' 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)

     WARNING!  RecordErrorFilePrefix attribute not specified, there is no default

     RecordErrorVerbosity: OFF (default) (=0)

     FileName: 'C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj'

     OpenMode: 'READ' (1)

     Format: 'FORMATTED' (3)

     IOBufferSize: 131072

 

     Full File Path: C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj

     UTF8 File Flag: 0

     Schema column count=9

     Data Type              Ind  Length  Offset M

              INTEGER (  1)   1       4       0 N

              INTEGER (  1)   1       4       4 N

             SMALLINT (  2)   1       2       8 N

                 CHAR (  5)   1      19      10 N

              INTDATE ( 11)   1       4      29 N

                 CHAR (  5)   1       8      33 N

              DECIMAL (  4)   1       8      41 N

              DECIMAL (  4)   1      16      49 N

              DECIMAL (  4)   1      16      65 N

     Schema is not all character data

     Schema is not compatible with delimited data

     SG_VARtypesFlag=0, NumIndBytes=2, TotalFixedLength=83

     Validating parsing case: 2200000.

     MBCS (QUOTED DATA: No), Delimiter[0]: ''

     Delimiter: x''

     Escape Delimiter: x''

     Open Quote: x''

     Close Quote: x''

     Escape Quote: x''

     ECI operator ID: DataConnOper-2336

     Absolute File Path, Directory Scan Disabled

     Single Reader, Full Path

     Calling PX_CreateGlobalVar for DirInfo

     Calling PX_CreateGlobalVar for FileNames

     1 entries of 280 length each

     Method PX_Initiate entry:  Phase 2

     GLOBAL files in scan for all instances: 1

     Global    Global    Assigned   Usage      File  File

      index  entry size  instance  status      size  name

          1      280         1        1       10517  C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj

     LOCAL files for instance 1: 1

      Local  Global   Usage       File  File

      index   index   status      size  name

          1      1       1       10517  C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj

     time=10357

     CPUtime=10.357

     pmOpen entry <<<<

     strlen(FileName)=63

     FileName='C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj', Format=3, OpenMode=1

     opening via paramod=Oledb_Axsmod

     default is LITTLE endian

     VLI formatted I/O

     calling PIDMMain via COMM_WITH_AM

     Parameter block

hex: Hexadecimal formatted display from address 033A2780 for 328 bytes.

hex:  0000  41 58 53 4D.4F 44 20 62.6C 6F 63 6B.3A 4F 70 65  *AXSMOD block:Ope*

hex:  0010  6E 5F 74 00.00 00 00 00.00 00 00 00.00 00 00 00  *n_t.............*

hex:  0020  48 01 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *H...............*

hex:  0030  01 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  0040  3F 00 43 3A.5C 54 65 72.61 64 61 74.61 5F 6C 6F  *?.C:\Teradata_lo*

hex:  0050  61 64 5F 73.63 72 69 70.74 73 5C 55.74 69 6C 69  *ad_scripts\Utili*

hex:  0060  74 69 65 73.5C 54 50 54.5C 41 4D 4A.5C 43 6C 69  *ties\TPT\AMJ\Cli*

hex:  0070  65 6E 74 5F.53 61 6C 65.73 5F 54 50.54 2E 61 6D  *ent_Sales_TPT.am*

hex:  0080  6A 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *j...............*

hex:  0090  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

hex:  ....

hex:  0140  00 00 00 00.00 00 00 00                          *........        *

     PIDMMain rc=0

     BufferSize=0, BlkHeaderLen=0, BufferBlkStrt=0

     Allocating buffer size=0

**** 11:44:16 From file 'C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj', starting to send rows.

     PX_Initiate: Complete.  Returning EndMethod

     AllowBufferMode: 'YES (defaulted)' (=1)

     Method PX_Checkpoint entry:  Phase 1

**** 11:44:16 Checkpointing instance 1, file count 0 of 1:

     pmGetPos entry <<<<

     Bypassing call to AM for checkpoint

     BlkOffset=0

     RecCount=0

     EOF=0

     Returning position for file 'C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj', record 0

     Position data from DTACON:

  Hexadecimal formatted display from address 007C1490 for 9 bytes.

   0000  00 00 00 00.00 00 00 00.00                       *.........       *

     No error row position data from DTACON

     dcPosSummary_t struct: Length=33

ErrRowCount=0, FileRecCount=0, DatPosLen=9, ErrPosLen=0

     RecordInstanceTarget = 0

     Aggregate position data:

  Hexadecimal formatted display from address 00840290 for 33 bytes.

   0000  00 00 00 00.00 00 00 00.09 00 00 00.00 00 00 00  *................*

   0010  00 00 00 00.00 00 00 00.00 00 00 00.00 33 20 30  *.............3 0*

   0020  30                                               *0               *

     Instance position data from DC_GetPos():

  Hexadecimal formatted display from address 00840290 for 33 bytes.

   0000  00 00 00 00.00 00 00 00.09 00 00 00.00 00 00 00  *................*

   0010  00 00 00 00.00 00 00 00.00 00 00 00.00 33 20 30  *.............3 0*

   0020  30                                               *0               *

     Calling DC_GetPos

     pmGetPos entry <<<<

     Bypassing call to AM for checkpoint

     BlkOffset=0

     RecCount=0

     EOF=0

     Returning position for file 'C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj', record 0

     Position data from DTACON:

  Hexadecimal formatted display from address 007C1490 for 9 bytes.

   0000  00 00 00 00.00 00 00 00.00                       *.........       *

     No error row position data from DTACON

     dcPosSummary_t struct: Length=33

ErrRowCount=0, FileRecCount=0, DatPosLen=9, ErrPosLen=0

     RecordInstanceTarget = 0

     Aggregate position data:

  Hexadecimal formatted display from address 00840290 for 33 bytes.

   0000  00 00 00 00.00 00 00 00.09 00 00 00.00 00 00 00  *................*

   0010  00 00 00 00.00 00 00 00.00 00 00 00.00 33 20 30  *.............3 0*

   0020  30                                               *0               *

     Processed=0, CheckpointBufferSize=1161

     size(Dir)=828, FileCount=1, size(File)=280, Pos.len=33, size(CountCurrent)=4, sizeof(usercmd_desc)=16

     DirName=C:\Teradata_load_scripts\Utilities\TPT\, DirNameSpecified=0, FileCount=1, TotalInstances=1, RowCount=0, RowsSkipped=0

     bMultiInstanceRead=0, EvtCkptCount=0, EvtRecordCount=0, EvtFileCount=0, Instance 1 CountCurrent=0

              size ins s name

            10517   1 1 'C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj'

     Position data to TPT:

  Hexadecimal formatted display from address 00843240 for 1161 bytes.

   0000  43 3A 5C 54.65 72 61 64.61 74 61 5F.6C 6F 61 64  *C:\Teradata_load*

   0010  5F 73 63 72.69 70 74 73.5C 55 74 69.6C 69 74 69  *_scripts\Utiliti*

   0020  65 73 5C 54.50 54 5C 00.00 00 00 00.00 00 00 00  *es\TPT\.........*

   0030  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

   ....

   0100  43 00 3A 00.5C 00 54 00.65 00 72 00.61 00 64 00  *C.:.\.T.e.r.a.d.*

   0110  61 00 74 00.61 00 5F 00.6C 00 6F 00.61 00 64 00  *a.t.a._.l.o.a.d.*

   0120  5F 00 73 00.63 00 72 00.69 00 70 00.74 00 73 00  *_.s.c.r.i.p.t.s.*

   0130  5C 00 55 00.74 00 69 00.6C 00 69 00.74 00 69 00  *\.U.t.i.l.i.t.i.*

   0140  65 00 73 00.5C 00 54 00.50 00 54 00.5C 00 00 00  *e.s.\.T.P.T.\...*

   0150  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

   ....

   0320  00 00 00 00.01 00 00 00.00 00 00 00.01 00 00 00  *................*

   0330  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

   ....

   0350  01 00 00 00.01 00 00 00.15 29 00 00.00 00 00 00  *.........)......*

   0360  43 3A 5C 54.65 72 61 64.61 74 61 5F.6C 6F 61 64  *C:\Teradata_load*

   0370  5F 73 63 72.69 70 74 73.5C 55 74 69.6C 69 74 69  *_scripts\Utiliti*

   0380  65 73 5C 54.50 54 5C 41.4D 4A 5C 43.6C 69 65 6E  *es\TPT\AMJ\Clien*

   0390  74 5F 53 61.6C 65 73 5F.54 50 54 2E.61 6D 6A 00  *t_Sales_TPT.amj.*

   03A0  00 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

   ....

   0470  09 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *................*

   0480  00 00 00 00.00 33 20 30.30                       *.....3 00       *

     PX_Checkpoint: Complete-Setting Execute CkptJustCompleted flag.  Returning EndMethod

     Entering phase 1

     SYSTEM_BUFFERMODE: 'yes'

     BUFFERLENGTHSIZE: 2

     BUFFERHEADERSIZE: 4

     BUFFERTRAILERSIZE: 6

     BUFFERMAXSIZE: 64260

     Buffer mode attributes defined by consumer instance:

     BUFFERLENGTHSIZE set to: 4

     BUFFERHEADERSIZE set to: 4

     BUFFERTRAILERSIZE set to: 0

     BUFFERMAXSIZE set to: 524262

     pmRead entry <<<<

     pmrwfmtRvli entry <<<<

     pmReadn2Buf entry <<<<

     calling PIDMMain via COMM_WITH_AM

     Parameter block

hex: Hexadecimal formatted display from address 033A23C0 for 64 bytes.

hex:  0000  41 58 53 4D.4F 44 20 62.6C 6F 63 6B.3A 52 57 5F  *AXSMOD block:RW_*

hex:  0010  74 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *t...............*

hex:  0020  40 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *@...............*

hex:  0030  00 00 00 00.00 00 00 00.48 F7 82 00.00 00 00 00  *........H.......*

     PIDMMain rc=0

     BufferEnd=0

     Buffer received:

hex: Hexadecimal formatted display from address 0082F748 for 0 bytes.

     New API layer Buffer:

hex: Hexadecimal formatted display from address 0082F748 for 0 bytes.

     NeededLength=1

     BufferSize=0

     NeededLength>BufferSize

     DataLength=0

     Buffer contents

hex: Hexadecimal formatted display from address 00000000 for 0 bytes.

     !ERROR! returning rcode=17

     Last RecCount=0

     RecCount=0

     Buffer->Data

hex: Hexadecimal formatted display from address 00000000 for 0 bytes.

     pmGetErrText entry <<<<

     LastReturnCode=17

     !ERROR!  pmRead rc=17

     !ERROR!  'Buffer overflow'

     !ERROR!  TPT Exit code set to 12.

     Method PX_Terminate entry:  Phase 1

     Attribute 'PX_ExitCode': 12

     Attribute 'SYSTEM_ExecutePassed' value is 'N'

     Files read by this instance: 0

**** 11:44:18 Total processor time used = '0.00 Seconds(s)'

     Processing of file 'C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj' by instance 1 failed.  Status is: still processing.

     Total files processed in pass: 0

**** 11:44:18 Total files processed: 0

     CkptCount=1

     Enter DC_Term Phase 2

     pmShutDown entry <<<<

     Shutting down API

     Closing paramods

     pmDetach entry <<<<

     Detaching Access Module=Oledb_Axsmod

     pmClose entry <<<<

     Closing file=C:\Teradata_load_scripts\Utilities\TPT\AMJ\Client_Sales_TPT.amj

     closed via paramod=Oledb_Axsmod

     Record count=0

     calling PIDMMain via COMM_WITH_AM

     Parameter block

hex: Hexadecimal formatted display from address 033A28C8 for 48 bytes.

hex:  0000  41 58 53 4D.4F 44 20 62.6C 6F 63 6B.3A 43 6C 6F  *AXSMOD block:Clo*

hex:  0010  73 65 5F 74.00 00 00 00.00 00 00 00.00 00 00 00  *se_t............*

hex:  0020  30 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *0...............*

     PIDMMain rc=0

     calling PIDMMain via COMM_WITH_AM

     Parameter block

hex: Hexadecimal formatted display from address 033A2980 for 56 bytes.

hex:  0000  41 58 53 4D.4F 44 20 62.6C 6F 63 6B.3A 53 68 75  *AXSMOD block:Shu*

hex:  0010  74 5F 74 00.00 00 00 00.00 00 00 00.00 00 00 00  *t_t.............*

hex:  0020  38 00 00 00.00 00 00 00.00 00 00 00.00 00 00 00  *8...............*

hex:  0030  02 00 00 00.00 00 00 00                          *........        *

     PIDMMain rc=0

     closing DDAM at PIDM_LIB_pointer=x'30000000'

     Exit code is 12

     Closing logs

 

C:\Program Files\Teradata\Client\14.10\Teradata Parallel Transporter\logs>

SuSeSi 61 posts Joined 10/08
21 Jan 2014

Hi Boris,

Thanks for the detailed logs. Please use 14.10.00.03 version of TPT which has the fix for this issue. You seems to be using TPT 14.10.00.02. If you cannot download the latest TPT patch from TSS (Teradata Software Server) then contact Teradata support center to get the patch.

-Sudhansu

boriscb 22 posts Joined 09/13
21 Jan 2014

Sudhansu,
Thank you very much for your help and advice. It is greatly appreciated !!!...
I will follow up on your suggestion.
 
 

WB255000 11 posts Joined 11/09
29 Jan 2016

Hi friends.

 

I'm having, I think, the same problems loading an Excel File.

 

But in my case I'm using:

 

TPT version 14.10.00.04

 

OLELoad 14.10.00.02

 

The Oleload Error message is: "Teradata Oleload has detected  a problem in the request from the calling software , executor.exe. It is possible that the calling  software version is incompatible with this Access module"

 

The TPT Error message is: "DaTaConnOper: TPT19417 pmRead fail. Buffer Overflow (17)"

 

I have tried to load any kind of Excel file (with different type of columns) but I couldn't load them.

 

At first I thought that It was something with the Excel because I've used OLeLoad before and It worked fine loading Excel files, but now I'm working on Win8 and Office 2013, and may have some incompatibility.

 

 I Attach information that may be useful

 

Could you help me with this error?
 

You must sign in to leave a comment.