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.
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.