Skip to content

Posts from the ‘Error Resolution’ Category

Teradata – DBQL DETAIL TABLES did not load

ISSUE:

PDCR job failed with below error:
LD_Error6: The DBQL DETAIL TABLES did not load. SqlState = ‘T2646’, SqlCode = 2646 when executing SQL statement number 106

or

[Teradata Database] [TeraJDBC 15.10.00.09] [Error 2646] [SQLState HY000] No more spool space in PDCRAdmin.

DESCRIPTION:

PDCR job will fail with this error if spool for PDCRADMIN is not big enough. Try to increase the spool for PDCRAdmin user and re-run the job. No other action is needed to fix this issue.

Teradata database backup job failed and is not running since last failure.

ISSUE:

Teradata database backup job failed and is not running since last failure.

Job Execution Errors and Warnings:
Error Code: 1005
Error Message:
224: CLISQL Exception: CLI reported error 224: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

RESOLUTION:

You may see this issue if Teradata backup job is not able to resolve the host name in /etc/hosts. In order to fix the issue make sure the below entry in /etc/hosts file in all the COP nodes:

127.0.0.1 localhost tdatcop1 SERVERNAMEcop1

To verify this entry on all the nodes by just logging in to one node:

# psh “cat /etc/hosts | grep cop1”
all 4 nodes:
127.0.0.1 localhost tdatcop1 SERVERNAMEcop1
11.11.22.22 byn201-8 dbccop1