Your advice with the following will be greatly appreciated.
I am using the TTU 14.10 set of tools with a Teradata DB 126.96.36.199
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.
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.
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?
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).
This is the script generated by the wizard:
The error dialog that pops-up a few times 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.
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'
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 ...
The Job script:
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?
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:
I am now considering using MLOAD to import data directly from MSSQL to Teradata.
Thank you for your assistance.