Problems with SP compilation

Database

Problems with SP compilation

I have problems to compile any sp with Teradata 13 Express and VS Express 2008 sp1. Compilation of a trivial procedure

Replace procedure RETAIL.sp_T()
begin
declare job char(12);
end;

fails with *** Failure 5547 Internal Error: Can not find mt.exe

The routine exists in Windows SDK, that is installed with VS Express. Adding the directory to the path variable does not help.

When I use diagnostic spldebug on for session, I can find, beside souce c code, other 5 files in the directory C:\ProgramData\Teradata\Tdat\tdconfig\TDSPTemp with following suffixes .clist, .mds, .olist, .req, .uni. No object file was created.

The problem is the same for both Win 7 RC and Win XP sp3.

Any help would be appreciated.
Tags (1)
10 REPLIES
Teradata Employee

Re: Problems with SP compilation

I am afraid this is DR 135079 which may not have a 13.0 fix yet. I have made an inquiry about it. "Because of having semicolon in middle, it is not finding mt.exe file."
Could be a VS2005 issue only, not sure at this time.
Teradata Employee

Re: Problems with SP compilation

A fix in 13.0 is on it's way. The best I can determine at this time is that the issue is specific to VS2008 and earlier versions of VS should not have the problem.

Re: Problems with SP compilation

Thank you for the reply. It would be nice to know which Ms VS / VC++ /Windows sdk work beside old VC++6 whis has compatibility problems on Windows 7. Will Teradata intend to ocasionally update the Express editions? Express 12 seems to have the same version that was published about a year ago.
Teradata Employee

Re: Problems with SP compilation

Before I took on my current role in China, I used to manage Teradata database porting programs on the Windows platform and the MS compiler question is one that I get from time to time. Generally speaking, Teradata database supports every MS compiler out there and we put people's time to make sure that our database work with both paid and free versions. Paid versions include every version of MS Visual Studio. Free versions include MS Visual Studio Express (32-bit windows) and MS Windows SDK that includes a free compiler. In the recent versions of Windows SDK, there seems to be several issues with MS either not including key compiler executables in their SDK installer or including older versions of the compiler executables. If you run into these issues, you can copy over the correct executable from the paid versions of MS visual studio. The compilers for both paid and free versions are essentially the same.

Re: Problems with SP compilation

Can you reply into which folder the mt.exe should be inserted? I've put it where the bteq.exe is located, but it is still carping it cannot be found.
Teradata Employee

Re: Problems with SP compilation

it should be put under the bin directory of where your Microsoft SDK or visual studio is installed on the database server. e.g. c:\program files\Microsoft (product) \ version \ bin

Re: Problems with SP compilation

I get the same error/dialog box when I try and add a stored procedure using Teradata SQL Assistant. V13, local Teradata Express.

Any fix out there?
FAQ
Enthusiast

Re: Problems with SP compilation

I have 2 Visual Studio versions installed on my system VS 6 and VS 2008; I am getting the same error, how can I configure Teradata to use VS 6 for compiling Stored Procedures?
Enthusiast

Re: Problems with SP compilation

Hi,

I am getting same error can someone specify which compiler is compatible with Teradata 13 version. windows xp service pack 3 and microsoft vc++ 2008 compiler. prompt reply is Appreciated.

thnx