Teradata Database Setup errors out for some queries

Tools & Utilities
Enthusiast

Teradata Database Setup errors out for some queries

We have installed Teradata on Windows machine. Now on running Database Setup and providing the following information (in the WIndows GUI):
Database Name : db1
Super User: DBC
Super User Password: dbc
Console Password: dbc
Set up DB for Teradata Manager: Yes
Perm Space: 100 MB
DB Type: MPRAS
Spool Space: Same as Parent

Create a Teradata Manager User: Yes
User Name: DBCMANAGER
User Account String: $H-DBC-MANAGER
User Password: dbcmngr
Perm Space: 100MB
Spool Space: Same as Parent
Give user privilages to run: Selected all options in combo
Migrate TDQM Database: Yes

On proceeding further, there are some errors in the log file, while the user is created and most of the operations succeed. We want to eliminate the errors, more specifically the error while creating the table TDWMUpsertConfigurations, because when creating TDWM we get errors against this table.

Below is the error log for this (after running Database Setup). I can also provide the complete log if any one wants a peek:

REPLACE PROCEDURE TDWMUpsertConfigurations(
IN ConfigId INTEGER,
IN ConfigName VARCHAR(30),
IN Description VARCHAR(80),
IN MinEstConfidence VARCHAR(10),
IN DeadlockCycles INTEGER,
IN DeadlockAction VARCHAR(20),
IN MonitorInterval INTEGER,
IN LoggingInterval INTEGER,
IN DashboardInterval INTEGER,
OUT NewConfigId INTEGER,
OUT CreateDate INTEGER,
OUT CreateTime INTEGER,
OUT ResultCode INTEGER
)
BEGIN
DECLARE cdate INTEGER;
DECLARE ctime INTEGER;
DECLARE myConfigId INTEGER;
SELECT DATE INTO :cdate;
SELECT TIME INTO :ctime;
SET ResultCode = 0;
SET CreateDate = cdate;
SET CreateTime = ctime;
SET myConfigId = ConfigId;
SET NewConfigId = myConfigId;
IF ConfigId <= 0 THEN
BEGIN
SELECT ZEROIFNULL(MAX(ConfigId)) + 1 INTO :myConfigId
FROM Configurations;
SET NewConfigId = myConfigId;
END;
ELSE
BEGIN
LOCKING Configurations FOR WRITE
UPDATE Configurations SET
RemoveDate = :cdate,
RemoveTime = :ctime
WHERE ConfigId = :ConfigId AND ConfigId = :myConfigId AND RemoveDate = 0;
END;
END IF;
INSERT Configurations (ConfigId, ConfigName, CreateDate, CreateTime,
Description, RemoveDate, RemoveTime,
MinEstConfidence, DeadlockCycles, DeadlockAction,
MonitorInterval, LoggingInterval, DashboardInterval)
VALUES (:myConfigId, :ConfigName, :cdate, :ctime,
:Description, 0, 0,
:MinEstConfidence, :DeadlockCycles, :DeadlockAction,
:MonitorInterval, :LoggingInterval, :DashboardInterval);
END;
*** Query failed
*** CLI2: BADSEGMENT(373): TDSP Input Segment is InValid.

Code= 373 Function= 4

1 REPLY
Enthusiast

Re: Teradata Database Setup errors out for some queries

This error cropped up on our V2R6 install. There were some C++ errors in the log as well. We tried installing the .net runtime but in vain.

On another install of TD 12, we installed MS Visual Studio 2003 first (with C++ selected) and then ran Database setup. It ran without any C++ errors and after that all TDWM tables were created successfully and we are able to create WD rulesets and save them on database.